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
- 2844 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 |
QSM-01079: DML operation occurred on a table referenced by MV, string
NID-00315: Operation already in progress, continuing
PCC-02045: CMD-LINE: Option is not unique:
KUP-04052: error processing column string in a row for datafile string
IMP-00079: Warning: National character set data in this table may be incorrect
RMAN-08521: offline range recid=string stamp=string
ORA-22885: cannot get REF to a non-persistent object
ORA-24402: error occured while creating connections in the pool
ORA-06028: NETASY: unable to intialise for logging
ORA-38426: attribute set assigned to an expression set may not be dropped
LSX-00222: "~1S" is too long (maximum length is ~2d)
ORA-02467: Column referenced in expression not found in cluster definition
Oracle Errors 
