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-38601: FI Not enough memory for frequent itemset counting: string

1 Answers  


NPL-00302: ASN.1 type tag is greater than maximum of 16383

1 Answers  


ORA-33046: (XSAGDNGL22) In AGGMAP workspace object, you can specify only one SCREENBY clause.

1 Answers  


NZE-29039: There are no matching cipher suites.

1 Answers  


ORA-08183: Flashback cannot be enabled in the middle of a transaction

1 Answers  






ORA-22151: cannot resize non-zero variable-length array to zero elements

1 Answers  


PCC-02438: Arrays of collection objects are not allowed

1 Answers  


ORA-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is running

1 Answers  


NNL-00580: register_ns: <name server> <address> <domain>

1 Answers  


TNS-02404: Service string contains no local handlers

1 Answers  


ORA-12422: max policies exceeded

1 Answers  


CLSS-03000: reconfiguration successful, incarnation string with string nodes

1 Answers  






Categories