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
- 2808 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 |
ORA-14158: too many subpartition descriptions
ORA-38414: invalid datatype for the attribute string
PROT-00001: Failed to initialize ocrconfig
ORA-02188: Cannot enable instance publicly
ORA-31004: Length string of the BLOB in XDB$H_INDEX is below the minimum string
ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
ORA-07880: sdopnf: internal error
NNL-01060: Cache next checkpointed in: string
ORA-31182: Too many PL/SQL DOM handles specified
ORA-30436: unable to open named pipe 'string'
ORA-06517: PL/SQL: Probe error - string
ORA-35280: (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] USING aggmap-name [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [THREADS #]
Oracle Errors 
