TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or POOL_SIZE parameter from PRESPAWN_DES
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






Leave a Reply