TNS-01155: Incorrectly specified SID_LIST_string parameter in LISTENER.ORA
Cause: SID_LIST_<listener_name> in
LISTENER.ORA has an error in it.
Action: Be sure this parameter is
specified as described in the Oracle9i Net Services Reference Guide. For
example, SID_LIST_LISTENER =
(SID_LIST=(SID_DESC=(SID_NAME=<sid>)(ORACLE_HOME=<oracle_home>)))
Relared Errors:
TNS-01156:
Missing or inappropriate PROTOCOL, TIMEOUT or POOL_SIZE parameter from
PRESPAWN_DES
TNS-01157: Can
only listen on number addresses - ignoring
string
TNS-01158:
Internal connection limit reached, preventing dispatcher from
connecting
TNS-01159:
Internal connection limit has been reached; listener has shut
down
TNS-01160:
Trace level was not specified
TNS-01161:
Spawn alias string was not found. Check listener parameter
file
TNS-01162:
Syntax error in the address resolved from the spawn alias:
string
TNS-01163:
Failed to spawn process: string
TNS-01164: No
spawn alias sent to listener
TNS-01165:
Spawn alias has no program name set in it
September 5th, 2008 at 7:19 pm
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
LSNRCTL> start
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.122)(PORT=1521)))
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…