This discussion is archived
1 2 Previous Next 25 Replies Latest reply: Dec 16, 2012 12:53 PM by sb92075 RSS

Listener does not currently know of SID given in connection descriptor

905429 Newbie
Currently Being Moderated
Oracle 11g R2 64bit on Windows 7 professional giving following Error

Listener refused the connection with following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor.

Oracle 11g R1 64bit on windows 7 professional works perfectly fine

Test through Net Manager. no use
check files ../Network/Admin/listerner.ora and tnsnames.ora which is perfectly fine. Still getting same error when trying to connect using sql developer.
  • 1. Re: Listener does not currently know of SID given in connection descriptor
    sb92075 Guru
    Currently Being Moderated
    12505, 00000, "TNS:listener does not currently know of SID given in connect descriptor"
    // *Cause:  The listener received a request to establish a connection to a
    // database or other service. The connect descriptor received by the listener
    // specified a SID for an instance (usually a database instance) that either
    // has not yet dynamically registered with the listener or has not been
    // statically configured for the listener. This may be a temporary condition
    // such as after the listener has started, but before the database instance
    // has registered with the listener.
    // *Action: 
    //  - Wait a moment and try to connect a second time.
    //  - Check which instances are currently known by the listener by executing:
    //    lsnrctl services <listener name>
    //  - Check that the SID parameter in the connect descriptor specifies
    //    an instance known by the listener.
    //  - Check for an event in the listener.log file.
    post results from following OS commands run on DB Server system

    lsnrctl status
    lsnrctl service
  • 2. Re: Listener does not currently know of SID given in connection descriptor
    905429 Newbie
    Currently Being Moderated
    After executing this command (lsnrctl services <listener name>) I am getting this output

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-DEC-2011 23:45:04

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    The listener supports no services
    The command completed successfully

    My tnsnames.ora look this



    COMCAST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = comcast)
    )
    )

    listener.ora look this

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    )
  • 3. Re: Listener does not currently know of SID given in connection descriptor
    905429 Newbie
    Currently Being Moderated
    C:\Windows\system32>lsnrctl status

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-DEC-2011 23:51:34

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
    Start Date 14-DEC-2011 23:26:50
    Uptime 0 days 0 hr. 24 min. 45 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File C:\app\mycomputer\product\11.1.0\db_1\network\admin\listener.ora
    Listener Log File c:\app\mycomputer\diag\tnslsnr\MW76O5RUIGAO3F\listener\alert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
    The listener supports no services
    The command completed successfully

    C:\Windows\system32>lsnrctl service

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-DEC-2011 23:51:51

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    The listener supports no services
    The command completed successfully
  • 4. Re: Listener does not currently know of SID given in connection descriptor
    sb92075 Guru
    Currently Being Moderated
    You don't follow directions very well.

    if previous post really showed the whole & complete contents of listener.ora,
    then I would expect problems as it appears to be incomplete

    do as below

    lsnrctl stop
    -- now move, delete, or rename listener.ora file; since it is NOT required
    lsnrctl start
    lsnrctl service
    lsnrctl status

    Please issue ALL commands above
    COPY commands & results then PASTE everything back here
  • 5. Re: Listener does not currently know of SID given in connection descriptor
    Sunny kichloo Expert
    Currently Being Moderated
    Update the SID_LIST_LISTENER in listener.ora file with the Service Name and refer this link

    http://www.oracle-base.com/articles/misc/OracleNetworkConfiguration.php

    Then reload the listener with the help of following command

    lsnrctl reload
  • 6. Re: Listener does not currently know of SID given in connection descriptor
    905429 Newbie
    Currently Being Moderated
    C:\Windows\system32>lsnrctl stop

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-DEC-2011 00:14:40

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    The command completed successfully
    ---------------------------------------------------------------------------------------------------------------------------------------------------

    C:\Windows\system32>lsnrctl start

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-DEC-2011 00:15:59

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Starting tnslsnr: please wait...

    TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
    Log messages written to c:\app\mycomputer\diag\tnslsnr\MW76O5RUIGAO3F\listener\alert\log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MW76O5RUIGAO3F.dir.svc.accenture.com)(PORT=1521)))

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
    Start Date 15-DEC-2011 00:16:06
    Uptime 0 days 0 hr. 0 min. 5 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File c:\app\mycomputer\diag\tnslsnr\MW76O5RUIGAO3F\listener\alert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MW76O5RUIGAO3F.dir.svc.accenture.com)(PORT=1521)))
    The listener supports no services
    The command completed successfully


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    C:\Windows\system32>lsnrctl service

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-DEC-2011 00:17:38

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    Services Summary...
    Service "comcast" has 1 instance(s).
    Instance "comcast", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER
    Service "comcastXDB" has 1 instance(s).
    Instance "comcast", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:1022 state:ready
    DISPATCHER <machine: MW76O5RUIGAO3F, pid: 5800>
    (ADDRESS=(PROTOCOL=tcp)(HOST=MW76O5RUIGAO3F.dir.svc.accenture.com)(PORT=52996))
    The command completed successfully

    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    C:\Windows\system32>lsnrctl status

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-DEC-2011 00:18:51

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
    Start Date 15-DEC-2011 00:16:06
    Uptime 0 days 0 hr. 2 min. 49 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File c:\app\mycomputer\diag\tnslsnr\MW76O5RUIGAO3F\listener\alert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MW76O5RUIGAO3F.dir.svc.accenture.com)(PORT=1521)))
    Services Summary...
    Service "comcast" has 1 instance(s).
    Instance "comcast", status READY, has 1 handler(s) for this service...
    Service "comcastXDB" has 1 instance(s).
    Instance "comcast", status READY, has 1 handler(s) for this service...
    The command completed successfully
  • 7. Re: Listener does not currently know of SID given in connection descriptor
    sb92075 Guru
    Currently Being Moderated
    Instance "comcast", status READY, has 1 handler(s) for this service...
    This looks promising.

    sqlplus scott/tiger@comcast

    what results from command above?
  • 8. Re: Listener does not currently know of SID given in connection descriptor
    Shivananda Rao Guru
    Currently Being Moderated
    1st check if your database is started and running. Your oracle instance is not registered with the listener

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = <SID-NAME>
    (ORACLE_HOME = <ORACLE_HOME PATH>)
    )
    )

    Add this in your listener.ora file and later restart the listener. Later post the status of listener status using the command "*lsnrctl status*"
  • 9. Re: Listener does not currently know of SID given in connection descriptor
    Sunny kichloo Expert
    Currently Being Moderated
    Update the SID_LIST_LISTENER in listener.ora file as suggested by me in previous thread
  • 10. Re: Listener does not currently know of SID given in connection descriptor
    905429 Newbie
    Currently Being Moderated
    sb92075 rocks. Thanks alot it works
  • 11. Re: Listener does not currently know of SID given in connection descriptor
    905429 Newbie
    Currently Being Moderated
    One more problem i am not able to connect throught sqldeveloper if i put hostname : as localhost
  • 12. Re: Listener does not currently know of SID given in connection descriptor
    905429 Newbie
    Currently Being Moderated
    i am not able to connect throught sqldeveloper if i put hostname : as localhost
  • 13. Re: Listener does not currently know of SID given in connection descriptor
    sb92075 Guru
    Currently Being Moderated
    user8708908 wrote:
    i am not able to connect throught sqldeveloper if i put hostname : as localhost
    Then don't do that.

    the listener is NOT listening for localhost.
  • 14. Re: Listener does not currently know of SID given in connection descriptor
    905429 Newbie
    Currently Being Moderated
    how can I configure my listener to listen on localhost
1 2 Previous Next

Legend

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