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
- 2922 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-12232: TNS:No path available to destination
QSM-01060: illegal subquery in the HAVING clause
RMAN-06230: List of Stored Scripts in Recovery Catalog
EXP-00049: %s option is not compatible with Point-in-time Recovery or Transportable Tablespace Export
ORA-08209: scngrs: SCN not yet initialized
DGM-17002: Primary database can not be removed.
EXP-00068: tablespace string is offline
ORA-23350: maximum number of recursive calls exceeded
ORA-01937: missing or invalid role name
TNS-00548: value specified for client authentication parameter is not boolean
LPX-00249: invalid external ID declaration
ORA-30194: reserved for future use
Oracle Errors 
