TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC
is greater than the PRESPAWN_MAX



TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAX..

Answer / guest

Cause: The minimum value for PRESPAWN_MAX should be the sum
of the POOL_SIZEs.

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=15)(ORACLE_HOME=<oracle_home>)(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=10)(TIMEOUT=30))(PRESPAWN_DESC=(PROTOCOL=ipc)(POOL_SIZE=5)(TIMEOUT=15))))
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-13509: error encountered during updates to a SWRF table

1 Answers  


ORA-06558: buffer in dbms_pipe package is full. No more items allowed

1 Answers  


IMP-00008: unrecognized statement in the export file: string

1 Answers  


ORA-19575: expected string blocks in file string, found string

1 Answers  


TNS-01407: Status: string Total handlers: string Relevant handlers: string

1 Answers  






ORA-29274: fixed-width multibyte character set not allowed for a URL

1 Answers  


TNS-01016: change_password [<listener_name>]: changes the password of the listener

1 Answers  


NNF-04001: Error converting input file

1 Answers  


ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE

1 Answers  


PLS-00909: object string is not declared or insufficient privileges to access object string

1 Answers  


NNO-00610: detected possible alias loop involving name "string"

1 Answers  


TNS-00555: no directory specified for wallet resource locator

1 Answers  


Categories