Interested to Buy Any Domain ? << Click Here >> for more details...
TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC
is greater than the PRESPAWN_MAX
- 1 Answers
- 2840 Views
- I also Faced
- E-Mail Answers
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 |
PLS-00253: Formal parameter string missing in the parameters clause
ORA-01308: initialization parameter utl_file_dir is not set
ORA-12032: cannot use rowid column from materialized view log on "string"."string"
TNS-12634: Memory allocation failed
ORA-29801: missing RETURN keyword
ORA-27501: IPC error creating a port
ORA-13638: The user interrupted the current operation.
TNS-12599: TNS:cryptographic checksum mismatch
ORA-07273: sppst: invalid semaphore id.
RMAN-10014: PL/SQL error number on line number column number: string
ORA-39005: inconsistent arguments
ORA-27485: argument string already exists at a different position
Oracle Errors 
