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

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/