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
- 2746 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 |
PCC-00038: Unable to open a cursor
ORA-27461: The value for attribute string is too large.
RMAN-03023: executing command: string
RMAN-04008: WARNING from target database: string
ORA-09214: sfdone: I/O error detected
ORA-03203: concurrent update activity makes space analysis impossible
ORA-02338: missing or invalid column constraint specification
ORA-25468: column name not specified for alias: string
ORA-13369: invalid value for etype in the 4-digit format
TNS-12165: TNS:Trying to write trace file into swap space.
ORA-01353: existing Logminer session
ORA-39047: Jobs of type string cannot use multiple execution streams.
Oracle Errors 
