1 2 3 Previous Next 30 Replies Latest reply on Oct 19, 2012 10:53 AM by EdStevens

    TNS-12541  TNS no listener

    TheHades0210
      Aloha!

      I have an Oracle 11g R2 running on Windows 2003. Currently i have this error every time i try to start the LISTENER on cmd prompt.

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 06-FEB-2012 12:46
      :02

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

      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
      TNS-12541: TNS:no listener
      TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
      32-bit Windows Error: 61: Unknown error

      C:\>lsnrctl service

      Status are:

      On service LISTENER is started, but when i connect to an instance i get this error:

      C:\>sqlplus sys as sysdba

      SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 6 12:59:35 2012

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

      Enter password:
      ERROR:
      ORA-12560: TNS:protocol adapter error


      Enter user-name:

      Can someone please help me. Our prod env is currently stopped. :(

      Hades,
        • 1. Re: TNS-12541  TNS no listener
          sb92075
          TheHades0210 wrote:
          Aloha!

          I have an Oracle 11g R2 running on Windows 2003. Currently i have this error every time i try to start the LISTENER on cmd prompt.

          LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 06-FEB-2012 12:46
          :02

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

          Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
          TNS-12541: TNS:no listener
          TNS-12560: TNS:protocol adapter error
          TNS-00511: No listener
          32-bit Windows Error: 61: Unknown error

          C:\>lsnrctl service

          Status are:

          On service LISTENER is started, but when i connect to an instance i get this error:

          C:\>sqlplus sys as sysdba

          SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 6 12:59:35 2012

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

          Enter password:
          ERROR:
          ORA-12560: TNS:protocol adapter error


          Enter user-name:

          Can someone please help me. Our prod env is currently stopped. :(

          Hades,
          >
          Aloha!

          I have an Oracle 11g R2 running on Windows 2003. Currently i have this error every time i try to start the LISTENER on cmd prompt.

          LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 06-FEB-2012 12:46
          :02

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

          Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
          TNS-12541: TNS:no listener
          TNS-12560: TNS:protocol adapter error
          TNS-00511: No listener
          32-bit Windows Error: 61: Unknown error

          C:\>lsnrctl service

          Status are:

          On service LISTENER is started, but when i connect to an instance i get this error:

          C:\>sqlplus sys as sysdba

          SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 6 12:59:35 2012

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

          Enter password:
          ERROR:
          ORA-12560: TNS:protocol adapter error


          Enter user-name:

          Can someone please help me. Our prod env is currently stopped. :(

          Hades,
          when was last time all was OK & no error?
          What changed since then?

          Are both OS Services for listener & DB started?
          • 2. Re: TNS-12541  TNS no listener
            TheHades0210
            nothing was change since last friday. not even OS update.

            there was just an import i left running since last frinday and when i check this morning, import is still going on and i got this error.

            yes both OS service and listener service is started. what is odd is when i try to LSNRCLT START or LSNRCLT STOP I am prompted with this error:

            C:\>lsnrctl start

            LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 06-FEB-2012 12:47
            :44

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

            Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
            TNS-12541: TNS:no listener
            TNS-12560: TNS:protocol adapter error
            TNS-00511: No listener
            32-bit Windows Error: 61: Unknown error

            C:\>
            • 3. Re: TNS-12541  TNS no listener
              Nikolay Ivankin
              Post listener.ora
              • 4. Re: TNS-12541  TNS no listener
                TheHades0210
                listener.ora

                ============================================================

                # listener.ora Network Configuration File: C:\Oracle\app\product\11.2.0\dbhome_1\network\admin\listener.ora
                # Generated by Oracle configuration tools.

                LISTENER2 =
                (DESCRIPTION_LIST =
                (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = asiaoracle.RS2ASIA.COM)(PORT = 1521))
                )
                )

                SID_LIST_LISTENER =
                (SID_LIST =
                (SID_DESC =
                (SID_NAME = CLRExtProc)
                (ORACLE_HOME = C:\Oracle\app\product\11.2.0\dbhome_1)
                (PROGRAM = extproc)
                )
                (SID_DESC =
                (SID_NAME = CLRExtProc)
                (ORACLE_HOME = C:\Oracle\app\product\11.2.0\dbhome_1)
                (PROGRAM = extproc)
                (ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")
                )
                (SID_DESC =
                (SID_NAME = CLRExtProc)
                (ORACLE_HOME = C:\Oracle\app\product\11.2.0\dbhome_1)
                (PROGRAM = extproc)
                (ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")
                )
                )

                ADR_BASE_LISTENER2 = C:\Oracle\app
                • 5. Re: TNS-12541  TNS no listener
                  sb92075
                  TheHades0210 wrote:
                  nothing was change since last friday. not even OS update.
                  ORA-12560 can result when ORACLE_SID is unset or incorrect.
                  • 6. Re: TNS-12541  TNS no listener
                    TheHades0210
                    where can i find this "ORACLE_SID" and how (procedure, please) can i alter this, if it is wrong?
                    • 7. Re: TNS-12541  TNS no listener
                      Nikolay Ivankin
                      >
                      LISTENER2 =
                      (DESCRIPTION_LIST =
                      (DESCRIPTION =
                      (ADDRESS = (PROTOCOL = TCP)(HOST = asiaoracle.RS2ASIA.COM)(PORT = 1521))
                      )
                      )

                      SID_LIST_LISTENER =
                      ADR_BASE_LISTENER2 = C:\Oracle\app
                      Change to SID_LIST_LISTENER2
                      • 8. Re: TNS-12541  TNS no listener
                        sb92075
                        TheHades0210 wrote:
                        where can i find this "ORACLE_SID" and how (procedure, please) can i alter this, if it is wrong?
                        REALLY?
                        Consider using MS ACCESS which is much more user friendly software

                        http://www.oracle.com/pls/db112/search?word=oracle_sid&partno=
                        • 9. Re: TNS-12541  TNS no listener
                          TheHades0210
                          Change to SID_LIST_LISTENER2


                          from this:

                          # listener.ora Network Configuration File: C:\Oracle\app\product\11.2.0\dbhome_1\network\admin\listener.ora
                          # Generated by Oracle configuration tools.

                          LISTENER2 =
                          (DESCRIPTION_LIST =
                          (DESCRIPTION =
                          (ADDRESS = (PROTOCOL = TCP)(HOST = asiaoracle.RS2ASIA.COM)(PORT = 1521))
                          )
                          )

                          SID_LIST_LISTENER =
                          (SID_LIST =
                          (SID_DESC =
                          (SID_NAME = CLRExtProc)
                          (ORACLE_HOME = C:\Oracle\app\product\11.2.0\dbhome_1)
                          (PROGRAM = extproc)
                          )

                          so it should look like this?

                          # listener.ora Network Configuration File: C:\Oracle\app\product\11.2.0\dbhome_1\network\admin\listener.ora
                          # Generated by Oracle configuration tools.

                          LISTENER2 =
                          (DESCRIPTION_LIST =
                          (DESCRIPTION =
                          (ADDRESS = (PROTOCOL = TCP)(HOST = asiaoracle.RS2ASIA.COM)(PORT = 1521))
                          )
                          )

                          SID_LIST_LISTENER2 =
                          (SID_LIST =
                          (SID_DESC =
                          (SID_NAME = CLRExtProc)
                          (ORACLE_HOME = C:\Oracle\app\product\11.2.0\dbhome_1)
                          (PROGRAM = extproc)
                          )
                          • 10. Re: TNS-12541  TNS no listener
                            Nikolay Ivankin
                            yes, someone edited manually this file.
                            Use Net Manager utility to edit Oracle Net related files. It's quite easy to miss a parenthesis
                            • 11. Re: TNS-12541  TNS no listener
                              TheHades0210
                              current listener.ora


                              # listener.ora Network Configuration File: C:\Oracle\app\product\11.2.0\dbhome_1\network\admin\listener.ora
                              # Generated by Oracle configuration tools.

                              LISTENER2 =
                              (DESCRIPTION_LIST =
                              (DESCRIPTION =
                              (ADDRESS = (PROTOCOL = TCP)(HOST = asiaoracle.RS2ASIA.COM)(PORT = 1521))
                              )
                              )

                              SID_LIST_LISTENER2 =
                              (SID_LIST =
                              (SID_DESC =
                              (SID_NAME = CLRExtProc)
                              (ORACLE_HOME = C:\Oracle\app\product\11.2.0\dbhome_1)
                              (PROGRAM = extproc)
                              )
                              (SID_DESC =
                              (SID_NAME = CLRExtProc)
                              (ORACLE_HOME = C:\Oracle\app\product\11.2.0\dbhome_1)
                              (PROGRAM = extproc)
                              (ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")
                              )
                              (SID_DESC =
                              (SID_NAME = CLRExtProc)
                              (ORACLE_HOME = C:\Oracle\app\product\11.2.0\dbhome_1)
                              (PROGRAM = extproc)
                              (ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")
                              )
                              )

                              ADR_BASE_LISTENER2 = C:\Oracle\app

                              i will restart the service.
                              • 12. Re: TNS-12541  TNS no listener
                                Nikolay Ivankin
                                TheHades0210 wrote:
                                i will restart the service.
                                No need
                                lsnrctl reload
                                will reload config
                                • 13. Re: TNS-12541  TNS no listener
                                  TheHades0210
                                  still the same error:

                                  C:\>lsnrctl reload

                                  LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 06-FEB-2012 14:55
                                  :42

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

                                  Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                                  TNS-12541: TNS:no listener
                                  TNS-12560: TNS:protocol adapter error
                                  TNS-00511: No listener
                                  32-bit Windows Error: 61: Unknown error

                                  C:\>

                                  :(
                                  • 14. Re: TNS-12541  TNS no listener
                                    Nikolay Ivankin
                                    check if oracle service is up
                                    1 2 3 Previous Next