Oracle for Beginners to Expert

Sunday, August 31, 2014

DATE :-- 1^st Sep 2014

Error Starting Listener

Error:--

[oracle@PR11G admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 01-SEP-2014 00:38:45

Starting /u01/app/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/app/oracle/product/11.2.0/db_1/network/admin/liste

Log messages written to /u01/app/oracle/diag/tnslsnr/PR11G/listener/alert/log.xm

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.161)(PORT=152

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

NL-00303: syntax error in NV string

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

Listener.ora entry

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

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

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = PR11G.localdomain)

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

(SID_NAME = DBPR11G)

(SERVICE_NAME = DBPR11G)

)

Resolution :--

SID_LIST_LISTENER was not properly formatted

Once i alligned the brackets as shown above it worked