1 Reply Latest reply: Jan 5, 2014 2: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 Explorer
Currently Being Moderated

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

Legend

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