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 |
PLS-00624: USING clause must be used with either aggregate or pipelined functions
ORA-13240: specified dimensionality greater than that of the query mbr
TNS-01016: change_password [<listener_name>]: changes the password of the listener
ORA-36930: Cannot start a recursive call to Oracle OLAP because a ROLLBACK past an UPDATE to an attached analytic workspace has been performed.
ORA-23607: invalid column "string"
ORA-06538: statement violates string RESTRICT_REFERENCES pragma
ORA-40208: duplicate or multiple algorithm settings for function string
ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context
PLS-00127: Pragma string is not a supported pragma
RMAN-06070: DBWR could not identify datafile string
DRG-50701: error in listener.get_cmd()
ORA-00910: specified length too long for its datatype