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

ORA-16193: Primary and standby network encryption mismatch

1 Answers  


ORA-02437: cannot validate (string.string) - primary key violated

1 Answers  


ORA-32771: cannot add file to bigfile tablespace

2 Answers  


ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.

1 Answers  


ORA-28529: invalid or missing parameter in Net8 service name definition

1 Answers  






ORA-27032: failed to obtain file size limit

1 Answers  


LPX-00200: could not convert from encoding ~1s to ~2s

1 Answers  


NNL-00526: Starts a server using a non-standard executable and optional arguments

1 Answers  


ORA-22990: LOB locators cannot span transactions

1 Answers  


LSX-00242: bad Boolean "~S"

1 Answers  


RMAN-10009: error logging off of Oracle

1 Answers  


O2U-00206: Some characters in a type name were not legal identifier characters

1 Answers  






Categories