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-12315: database link type is invalid for the ALTER DATABASE statement
ORA-31104: Cannot find lock with token "string" on "string" for unlock
ORA-31404: all input parameters are null
ORA-06518: PL/SQL: Probe version string incompatible with version string
KUP-03017: length specified for VARIABLE records must be greater than 0
ORA-39140: dump file "string" belongs to job string
KUP-04061: directory object string specified for LOBFILE column string is not valid
PLS-00302: component 'string' must be declared
ORA-01193: file string is not the same file seen at start of recovery
NNL-00295: Controller's local trace level is currently number
ORA-02750: osnfsmmap: cannot open shared memory file ?/dbs/ftt_<pid>.dbf
SQL*Loader-00250: Work data sets are not used by SQL*Loader