1 2 Previous Next 25 Replies Latest reply: Dec 16, 2012 2:53 PM by sb92075 RSS

    Listener does not currently know of SID given in connection descriptor

    905429
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            sb92075 rocks. Thanks alot it works
                            • 11. Re: Listener does not currently know of SID given in connection descriptor
                              905429
                              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
                                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
                                  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
                                    how can I configure my listener to listen on localhost
                                    1 2 Previous Next