TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or
POOL_SIZE parameter from PRESPAWN_DESC
- 1 Answers
- 2233 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-02360: fatal error during data export/import initialization
TNS-00525: Insufficient privilege for operation
ORA-06319: IPA: Remote maximum number of users exceeded
RMAN-06031: could not translate database keyword
ORA-22816: unsupported feature with RETURNING clause
ORA-13240: specified dimensionality greater than that of the query mbr
ORA-01725: USERENV('COMMITSCN') not allowed here
ORA-39058: current object skipped: string of type string
DRG-10310: servers were shutdown before processing request
DRG-12602: index owner does not have access to user datastore procedure: string
ORA-06430: ssaio: Seals do not match
NID-00404: DBNEWID - Completed succesfully.
Oracle Errors 
