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
- 2846 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-39104: cannot call this function from a SQL parallel query slave process
ORA-14116: partition bound of partition "string" is too long
ORA-19808: recovery destination parameter mismatch
ORA-22855: optional name for LOB storage segment incorrectly specified
ORA-01599: failed to acquire rollback segment (string), cache space is full
ORA-27158: process control failure
ORA-01699: tablespace 'string' is being imported for point in time recovery
ORA-22903: MULTISET expression not allowed
PLS-00520: MAP methods must be declared without any parameters other than (optional) SELF.
DGM-16945: Syntax error before or at "string"
ORA-12090: cannot online redefine table "string"."string"
ORA-25105: RECOVERABLE option can only be used with ALTER INDEX REBUILD
Oracle Errors 
