TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or
POOL_SIZE parameter from PRESPAWN_DESC
- 1 Answers
- 2081 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 |
RMAN-10008: could not create channel context
DRG-52107: ctxkbtc internal error
ORA-39140: dump file "string" belongs to job string
PCC-00040: Unable to open listing file "string"
ORA-00231: snapshot controlfile has not been named
ORA-32695: HTI: Not enough memory
ORA-32841: invalid value for property string
PCB-00629: Host variable is not of Internal LOB type
ORA-02725: osnpbr: cannot send break signal
PLS-00582: attribute declarations are not allowed in opaque types
LSX-00164: no content specified in "~S"
PCC-02339: host variables cannot be of union types
Oracle Errors 
