Interested to Buy Any Domain ? << Click Here >> for more details...
TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or
POOL_SIZE parameter from PRESPAWN_DESC
- 1 Answers
- 2991 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: PRESPAWN_DESC 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=5)(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-12051: ON COMMIT attribute is incompatible with other options
PLS-00598: comparison of object with NULL using "string" is not allowed
QSM-02016: clustered table in FROM list
NNF-01006: Attribute string not available
ORA-24503: codepoint length overflows for piecewise operation
TNS-01081: Started with pid=string
ORA-01124: cannot recover data file string - file is in use or recovery
PCB-00225: Undeclared SQL identifier "string"
RMAN-08181: media recovery complete, elapsed time: string
ORA-29259: end-of-input reached
ORA-14298: LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
DRG-10599: column is not indexed
Oracle Errors 
