Interested to Buy Any Domain ? << Click Here >> for more details...
TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter
from SID_DESC
- 1 Answers
- 3736 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-14255: table is not partitioned by Range, Composite Range or List method
QSM-01086: dimension(s) not present or not used in ENFORCED integrity mode
PCC-02018: found end-of-file while scanning comment
ORA-23431: wrong state: string
NNL-00575: list_objects: list all objects in a domain or subtree
ORA-13146: could not find table substitution variable string
RMAN-08116: output filename is original SPFILE location
ORA-28540: internal result set error
ORA-33060: (XSAGDNGL29) In AGGMAP workspace object, the value for the ERRORLOG MAX option must be greater than 0.
ORA-04030: out of process memory when trying to allocate string bytes (string,string)
ORA-27365: job has been notified to stop, but failed to do so immediately
ORA-22895: referenced table "string" in schema "string" is not an object table
Oracle Errors 
