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
)
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
)
No comments:
Post a Comment