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
- 2905 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-36994: (XSRELGID11) The SURROGATE DIMENSION workspace object must be numeric.
ORA-22862: specified object identifier doesn't match existing object identifier
NNL-00275: Trace level is currently number
ORA-04094: table string.string is constraining, trigger may not modify it
PCC-02346: PL/SQL found semantic errors
ORA-38408: The ADT "string" does not exist in the current schema.
NID-00140: Specified database name string does not match previous name used string
O2F-00319: No OUTTYPE file specified
ORA-12625: TNS:missing argument
NNO-00853: failed to get LDAP attribute/value: error = number
ORA-02204: ALTER, INDEX and EXECUTE not allowed for views
PCC-02321: only subtraction between two pointers is permitted
Oracle Errors 
