TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or
POOL_SIZE parameter from PRESPAWN_DESC






TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or POOL_SIZE parameter from PRESPAWN_DESC..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer




More Oracle Errors Interview Questions

DRG-13303: value of wildcard offset must be in the range string..string, at line string

1 Answers  


RMAN-06065: The backup operand [string] conflicts with another specified operand.

1 Answers  


ORA-13704: Invalid value "string" specified for parameter "string".

1 Answers  


ORA-31430: subscriber view exists

1 Answers  


EXP-00015: error on row number of table string, column string, datatype number

1 Answers  






ORA-16614: object has an ancestor that is disabled

1 Answers  


ORA-09812: Unable to get user clearance from connection

1 Answers  


PLS-00439: A LIMIT clause must be used within a BULK FETCH

1 Answers  


ORA-29374: resource plan string in top-plan string has no plan directives

1 Answers  


ORA-09795: szrbuild: malloc of role structure failed.

1 Answers  


LPX-00266: invalid language specification ~s

1 Answers  


ORA-30431: refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string

1 Answers  






Categories