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
- 2777 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 |
DRG-11106: user database session has terminated during this operation
ORA-13208: internal error while evaluating [string] operator
DRG-12013: This method has already been performed - repeat operation?
ORA-16162: Cannot add new standby databases to protected configuration
EXP-00044: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
RMAN-12005: error during channel cleanup
ORA-23472: materialized view "string"."string" must be atomically refreshed
RMAN-06511: RMAN retention policy is set to redundancy number
ORA-01274: cannot add datafile 'string' - file could not be created
ORA-23369: value of "string" argument cannot be null
PLS-00354: username must be a simple identifier
ORA-31452: invalid value string for parameter, expecting: Y or N
Oracle Errors 
