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-01608: cannot bring rollback segment 'string' online, its status is (string)
IMG-02014: 2202D Data exception - Null image value
ORA-16621: Database name for ADD DATABASE must be unique.
PCC-02385: CHAR_MAP disallowed when using NLS_CHAR and NLS_LOCAL=TRUE
PLW-05005: function string returns without value at line string
NNO-00313: server password length string exceeds maximum of string
ORA-14280: all rows in table do not qualify for specified subpartition
ORA-38758: cannot flashback data file string; restored since last recovery
UDE-00002: invalid username or password
NZE-28814: Cannot convert a number in Oracle format to native format.
ORA-36690: (NTEXTCNV01) Error during conversion from NTEXT to TEXT.
NNL-00982: Not forwarded, no servers found: number