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
- 2898 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 |
PLS-00169: modifier 'string' conflicts with prior 'string' specification
PLS-00366: subtype of a NOT NULL type must also be NOT NULL
ORA-00027: cannot kill current session
AMD-00104: Level "string" cannot be added to the hierarchy; parent and child parameters represent the same level
ORA-31044: Top-level prefix length string exceeds maximum string
TNS-12540: TNS:internal limit restriction exceeded
PCC-02430: Expecting an expression of some arbitrary LOB type
ORA-06707: TLI Driver: connection failed
ORA-22984: view query cannot contain references to a super view
EXP-00061: unable to find the outer table name of a nested table
ORA-08462: raw buffer contains invalid decimal data
RMAN-06143: LIKE may only be specified with COPY
Oracle Errors 
