Cause: PRESPAWN_DESC in each SID_DESC
does not have required fields.
Action: Be sure the parameters required
for PRESPAWN_DESC are specified in each SID_DESC. For example,
SID_LIST_LISTENER =
(SID_LIST=(SID_DESC=(SID_NAME=<sid>)(PRESPAWN_MAX=5)(ORACLE_HOME=<oracle_home>)(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=10)(TIMEOUT=30))))
Add or correct these parameters in the LISTENER.ORA file


Relared Errors:
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

TNS-01167: The
command string is not supported by the listener
contacted