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
- 3006 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-28117: integrity constraint violated - parent record not found
PLS-00119: Duplicate having-clause in table expression
ORA-22931: MOVE of nested table to a different tablespace not supported
ORA-32144: Cannot perform operation on a null interval
NZE-29010: Export key length does not meet export restrictions.
LPX-00228: entity reference "~S" refers to itself
ORA-23540: Redefinition not defined or initiated
ORA-19566: exceeded limit of string corrupt blocks for file string
NZE-29136: The allocated buffer is too small.
ORA-04930: open sequence number failed or initial state is valid
ORA-01873: the leading precision of the interval is too small
ORA-30037: Cannot perform parallel DML after a prior DML on the object
Oracle Errors 
