TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or
POOL_SIZE parameter from PRESPAWN_DESC
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-38408: The ADT "string" does not exist in the current schema.
LRM-00119: unable to obtain a valid value for 'string'
DRG-10823: invalid query name
NCR-02004: NCRF: Invalid format interpreter type context
ORA-37070: You may not execute OLAP DML programs in a parallel query session.
ORA-00472: PMON process terminated with error
NNL-00298: No cache dump currently scheduled
ORA-19754: error reading from change tracking file
ORA-10656: Table is unusable due to incomplete operation
ORA-19038: Invalid opertions on query context
ORA-16017: cannot use LOG_ARCHIVE_DUPLEX_DEST without a primary archive destination
TNS-04234: Trace Assistant WARNING: won't decode TTC