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 |
ORA-13509: error encountered during updates to a SWRF table
ORA-06558: buffer in dbms_pipe package is full. No more items allowed
IMP-00008: unrecognized statement in the export file: string
ORA-19575: expected string blocks in file string, found string
TNS-01407: Status: string Total handlers: string Relevant handlers: string
ORA-29274: fixed-width multibyte character set not allowed for a URL
TNS-01016: change_password [<listener_name>]: changes the password of the listener
NNF-04001: Error converting input file
ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
PLS-00909: object string is not declared or insufficient privileges to access object string
NNO-00610: detected possible alias loop involving name "string"
TNS-00555: no directory specified for wallet resource locator