TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or
POOL_SIZE parameter from PRESPAWN_DESC
- 1 Answers
- 2098 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-13200: internal error [string] in spatial indexing.
PLS-00994: Cursor Variables cannot be declared as part of a package
ORA-33086: (XSAGINIT01) AGGMAP workspace object cannot be dimensioned by a conjoint dimension.
QSM-02008: non-join filter condition in WHERE or HAVING clause
ORA-24059: invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string
ORA-27458: A program of type PLSQL_BLOCK cannot have any arguments.
ORA-07221: slspool: exec error, unable to start spooler program.
NNL-00412: Number of requests: number
PLS-00417: unable to resolve "string" as a column
ORA-25218: enqueue failed, delay must be zero for queue string.string
SQL*Loader-00260: TERMINATED BY EOF option available only with LOBFILE option
TNS-01410: Service "string" has number instances.
Oracle Errors 
