Interested to Buy Any Domain ? << Click Here >> for more details...
TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or
POOL_SIZE parameter from PRESPAWN_DESC
- 1 Answers
- 2896 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-10007: error closing cursor
ORA-29553: class in use: string.string
IMP-00037: Character set marker unknown
ORA-26059: Data is too large for column string
NNO-00809: Unknown OCI error: number
ORA-38718: Invalid thread number specified in the DUMP FLASHBACK command.
LPX-00257: invalid children specification in element declaration
PLS-00386: type mismatch found at 'string' between FETCH cursor and INTO variables
ORA-02164: DATAFILE clause specified more than once
QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs
ORA-36712: (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.
ORA-28152: proxy user 'string' may not specify initial role 'string' on behalf of client 'string'
Oracle Errors 
