This discussion is archived
1 2 Previous Next 18 Replies Latest reply: May 1, 2013 10:57 PM by 1005659 Go to original post RSS
  • 15. Re: Having trouble creating new connection in SQLDeveloper
    Jim Smith Expert
    Currently Being Moderated
    1002656 wrote:
    >
    What parameters are you referring to?
    You must have entered some parameters in SQL Developer to create the connection.
    How do I find out the hostname, port, and sid of my db? Sorry, I'm new to this.
    The hostname is the machine it is installed on. The port is the port you specified when you created the listener. The sid is the name you provided when you created the database.

    These should all be visible in the lsnrctl status output.
  • 16. Re: Having trouble creating new connection in SQLDeveloper
    1005659 Newbie
    Currently Being Moderated
    Parameters:

    Connection name: dbhome_2 Connection
    Username: system
    Password: "password"

    Hostname: localhost (default)
    Port: 1521 (default)
    SID: dbhome_2

    In terms of the lsnrctl status, this is what you're referring to right?

    LSNRCTL> status
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
    STATUS of the LISTENER
    Alias LISTENER
    Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
    ction
    Start Date 26-APR-2013 17:55:47
    Uptime 0 days 3 hr. 4 min. 19 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File C:\app\Admin\product\11.2.0\dbhome_2\network\admin\lis
    tener.ora
    Listener Log File c:\app\admin\diag\tnslsnr\Admin-PC\listener\alert\log.
    xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Admin-PC)(PORT=1522)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "orcl.gateway.2wire.net" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    Service "orclXDB.gateway.2wire.net" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    The command completed successfully
    LSNRCTL> service
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "orcl.gateway.2wire.net" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER
    Service "orclXDB.gateway.2wire.net" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:1022 state:ready
    DISPATCHER <machine: ADMIN-PC, pid: 4496>
    (ADDRESS=(PROTOCOL=tcp)(HOST=Admin-PC)(PORT=49224))
    The command completed successfully
    LSNRCTL>
  • 17. Re: Having trouble creating new connection in SQLDeveloper
    Jim Smith Expert
    Currently Being Moderated
    dbome_2 is not the sid, it is a name for the installation directory.

    Your sid is orcl.

    It also looks as if your listener is listening on 1522, not 1521.
  • 18. Re: Having trouble creating new connection in SQLDeveloper
    1005659 Newbie
    Currently Being Moderated
    Thank you very much! This would have been resolved long ago had I known where to look for what I needed.
1 2 Previous Next

Legend

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