Issue : While starting the listener we got the below error.
linux01(oracle:orcl1)/home/oracle: lsnrctl start LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-SEP-2015 03:43:02 Copyright (c) 1991, 2013, Oracle. All rights reserved. Starting /opt/oracle/product/11.2.0.4.RAC/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /opt/oracle/product/11.2.0.4.RAC/network/admin/listener.ora Log messages written to /opt/oracle/diag/tnslsnr/linux01/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) 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...
Solution:
In the listener.ora file there were blank lines under the section SID_LIST_LISTENER. We removed the blank line entries and brought up the listener. (please note that this may be one of the scenarios)
Erroneous listener.ora file excerpts below:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL1) (ORACLE_HOME = /opt/oracle/product/11.2.0.4.RAC) (SID_NAME = ORCL1) ) <<<<< blank line (SID_DESC = (GLOBAL_DBNAME = ORCL2) (ORACLE_HOME = /opt/oracle/product/11.2.0.4.RAC) (SID_NAME = ORCL2) ) <<<<< blank line )
Comments
Tags: APPS DBA, ERP, ERP Application, errors, Incorrectly specified SID_LIST_LISTENER parameter, LISTENER.ORA, Oracle, Oracle Application, Oracle Apps, Oracle DBA, oracle erp, Oracle erp application, Oracle Forms, TNS-01155, TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA