Interested to Buy Any Domain ? << Click Here >> for more details...
TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter
from SID_DESC
- 1 Answers
- 3656 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-27020: named devices not supported
NID-00603: No datafiles found in database
ORA-22318: input type is not an array type
TNS-01158: Internal connection limit reached, preventing dispatcher from connecting
ORA-16815: incorrect log transport setting for AlternateLocation of standby "string"
ORA-16569: Data Guard configuration is not enabled.
ORA-02423: schema name does not match schema authorization identifier
ORA-23469: %s is different between templates
ORA-12826: hung parallel query server was killed
EXP-00042: Missing NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET in props$
ORA-13281: failure in execution of SQL statement to retrieve WKT
IMP-00014: option "string" is needed, but not present in database
Oracle Errors 
