This discussion is archived
7 Replies Latest reply: Mar 25, 2013 1:29 AM by yoonas RSS

Connect 2 databases via WiFi

996004 Newbie
Currently Being Moderated
I'm new to Oracle database 11g express edition. I have two laptops and, I want conncet 1 laptop's oracle database with the other laptop.
How can I do it?

Thanks in Advance

Edited by: 993001 on Mar 24, 2013 9:17 PM
  • 1. Re: Connect 2 databases via WiFi
    yoonas Expert
    Currently Being Moderated
    Hi,

    What is the url to access oracle apex on the laptop where you have installed 11g express edition?
    Post the output of lsnrctl stauts (start>run>cmd)

    If you want to access database from the other laptop using tools like sqldeveloper,toad etc..

    add an entry for 11g database box to the other laptop hosts file (windows\system32\drivers\etc\hosts)
    ex 192.168.1.1    vmtest.mylearn.com      vmtest
    make sure you can reach the other host with ping command
    ping <hostname> 
    ex: ping vmtest
    If you want to connect using tnsnames install database client and add tns entry to the tnsnames file.

    To connect using sqldeveloper,toad,etc you need the following details with you
    username/password
    hostname/ip (you can user either hostname or IP)
    listener port
    database SID
    by default XE has
    SID = XE
    listener port = 1521


    Regards
    Yoonas
  • 2. Re: Connect 2 databases via WiFi
    996004 Newbie
    Currently Being Moderated
    Ping is successfull. Can you give me what are the steps should I do in sql developer to connect with other database. I 'm trying to connect to other laptop's database using java

    Thanks in Advance
  • 3. Re: Connect 2 databases via WiFi
    yoonas Expert
    Currently Being Moderated
    I have already specified that in my previous post, start sqldeveloper and provide required details

    See this (it uses connection type basic)
    https://www.dropbox.com/s/napeszjy7kyrlkq/sql_dev_conn_page.png

    If you wan to connect using TNS install client from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html and add an entry in tnsnames file.
  • 4. Re: Connect 2 databases via WiFi
    996004 Newbie
    Currently Being Moderated
    I did this and clicked on Tes. But test Faild.
  • 5. Re: Connect 2 databases via WiFi
    yoonas Expert
    Currently Being Moderated
    post the output of lsnrctl status from the other laptop (11g xe installed one)
    start>run>cmd>lsnrctl status (hope you are on windows)
    I am sure oracle will give some hints why the test failed ;) , post the error message as well.
  • 6. Re: Connect 2 databases via WiFi
    996004 Newbie
    Currently Being Moderated
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
    ction
    Start Date 26-FEB-2013 20:42:13
    Uptime 1 days 4 hr. 21 min. 22 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Default Service XE
    Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
    dmin\listener.ora
    Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\THISARA-PC\listene
    r\alert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=THISARA-PC)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=THISARA-PC)(PORT=8080))(Presentation
    =HTTP)(Session=RAW))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "XEXDB" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    The command completed successfully
  • 7. Re: Connect 2 databases via WiFi
    yoonas Expert
    Currently Being Moderated
    post output of "ping THISARA-PC" from the other laptop(laptop without 11gxe)

    username: <username>
    hostname: <password>
    hostname: thisara-pc
    port      : 1521
    SID      : xe

    Try like above and post the output/error message from sqldeveloper(you can also upload and share the screen shot on any free share sites)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points