TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or
POOL_SIZE parameter from PRESPAWN_DESC
- 1 Answers
- 2507 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-06202: Deleted string EXPIRED objects
RMAN-06588: number of patterns (number) to DB_FILE_NAME_CONVERT should be even
ORA-24340: cannot support more than 255 columns
ORA-32156: Cannot perform operation on stream
RMAN-08182: channel string: validation complete, elapsed time: string
PCC-00022: Out of space - unable to allocate number bytes
ORA-12477: greatest lower bound resulted in an invalid OS label
ORA-02730: osnrnf: cannot find user logon directory
RMAN-10025: connection is already registered for events
TNS-00526: No caller (false async event)
ORA-27121: unable to determine size of shared memory segment
ORA-02876: smpini: Unable to attach to shared memory for PGA
Oracle Errors 
