TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter
from SID_DESC
- 1 Answers
- 2949 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-13861: Statistics aggregation for client identifier string is already enabled
ORA-15043: ASM disk "string" is not a diskgroup member
ORA-00126: connection refused; invalid duplicity
EXP-00055: %s.string is marked not exportable
IMG-00548: invalid interleave specified
NID-00137: All datafiles that are not dropped should be readable
ORA-06401: NETCMN: invalid driver designator
SQL-02139: Unable to get the OCI handles
DRG-11605: URL store: document specified by string not found
ORA-03288: both FREELIST GROUP and INSTANCE parameters may not be specified
ORA-39726: unsupported add/drop column operation on compressed tables
ORA-24762: server failed due to unspecified error
Oracle Errors 
