Interested to Buy Any Domain ? << Click Here >> for more details...
TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter
from SID_DESC
- 1 Answers
- 3711 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 |
EXP-00105: parameter string is not supported for this user
NZE-29154: deterministic RNG self-test failure
NNL-00343: Log file name is now string
ORA-16601: site contains required resources that are disabled
ORA-23409: could not find an unused refresh group number
SQL*Loader-00500: Unable to open file (string)
ORA-26040: Data block was loaded using the NOLOGGING option
ORA-23460: missing value for column string in resolution method "string" for "string"."string"."string"
NNL-00353: Not allowed
ORA-27510: IPC error waiting for a request to complete
RMAN-06748: no or more than one tertiary storage channel found
ORA-01624: log string needed for crash recovery of instance string (thread string)
Oracle Errors 
