1 Reply Latest reply: Jan 5, 2014 4:29 AM by fb767351-a660-4b18-9a9f-73bc141f6a0c RSS

    TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA

    fb767351-a660-4b18-9a9f-73bc141f6a0c

      Hi,

       

      Could anyone please let me know why my listener is not getting started. Please check below my listener status and the error I am getting while starting the listener.

       

      [oracle@localhost ~]$ lsnrctl status

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-JAN-2014 05:11:41

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

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

      TNS-12541: TNS:no listener

      TNS-12560: TNS:protocol adapter error

        TNS-00511: No listener

         Linux Error: 2: No such file or directory

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))

      TNS-12541: TNS:no listener

      TNS-12560: TNS:protocol adapter error

        TNS-00511: No listener

         Linux Error: 111: Connection refused

       

      And bleow is the error which I am getting while starting the listener:

       

      [oracle@localhost ~]$ lsnrctl start

      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-JAN-2014 05:11:54

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

      Starting /u01/home/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

      TNSLSNR for Linux: Version 11.2.0.1.0 - Production

      System parameter file is /u01/home/oracle/product/11.2.0/db_1/network/admin/listener.ora

      Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

      TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA

      NL-00305: the specified path name does not exist

      Listener failed to start. See the error message(s) above...

       

      please check below my listener entries:

       

      [oracle@localhost admin]$ more listener.ora

      # listener.ora Network Configuration File: /u01/home/oracle/product/11.2.0/db_1/network/admin/listener.ora

      # Generated by Oracle configuration tools.

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

          )

        )

      SID_LIST_LISTENER =

        (SID_LIST =

          (SID_DESC =

            (GLOBAL_DBNAME = mydb)

            (ORACLE_HOME = /u01/home/oracle/product/11.2.0/db_1)

         )

          (SID_DESC =

            (GLOBAL_DBNAME = orcl)

            (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

            (SID_NAME = ORCL)

       

       

          )

      )

      ADR_BASE_LISTENER = /u01/app/oracle

       

      [oracle@localhost admin]$ more tnsnames.ora

      # tnsnames.ora Network Configuration File: /u01/home/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

      # Generated by Oracle configuration tools.

      MYDB =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = mydb)

          )

        )

      ORCL =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = ORCL)

          )

        )

       

      Please help me how should I get it resolve.

       

      Regards,

      Michel