Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-22800: invalid user-defined type

1 Answers  


NNL-00517: Insert-replaces a data item under an existing name

1 Answers  


ORA-30770: Cannot specify storage options for fixed size opaque type

1 Answers  


RMAN-05514: tablespace string has undo information, cannnot skip

1 Answers  


IMG-00602: unable to access image data

1 Answers  






ORA-03203: concurrent update activity makes space analysis impossible

1 Answers  


NID-00600: Internal Error - [number] [number] [number] [number]

1 Answers  


O2F-00333: An unexpected token appeared where a keyword was expected in the INTYPE file

1 Answers  


ORA-27018: BLKSIZE is not a multiple of the minimum physical block size

1 Answers  


NNL-00202: No shutdown currently scheduled

1 Answers  


ORA-19648: datafile string: incremental-start SCN equals checkpoint SCN

1 Answers  


ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

1 Answers  






Categories