Interested to Buy Any Domain ? << Click Here >> for more details...
TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter
from SID_DESC
- 1 Answers
- 3728 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: PRESPAWN_MAX in each SID_DESC does not have required
fields.
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))))
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-14251: Specified subpartition does not exist
ORA-02028: fetching an exact number of rows is not supported by the server
PLS-00380: functions and procedures are not included in this release of PL/SQL
ORA-06710: TLI Driver: send interrupt break message failed
LFI-01510: fread() failed(OSD return value = string) in string.
UDE-00007: attempt to free unallocated memory
RMAN-06120: uncataloged archive log
ORA-09945: Unable to initialize the audit trail file
ORA-08193: Flashback Table operation is not allowed on temporary tables
PLS-00516: Type mismatch between object table and value 'string' in INSERT statement.
TNS-00031: INTCTL: internal NT error
ORA-24904: invalid callback attribute passed into OCI call
Oracle Errors 
