TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter
from SID_DESC
- 1 Answers
- 3286 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: PRESPAWN_MAX 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=15)(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-28552: pass-through SQL: call flow error
ORA-13030: Invalid dimension for the SDO_GEOMETRY object
TNS-04010: Command cannot be issued before the ADMINISTER command.
ORA-22915: cannot ALTER a nested table's storage table to ADD/MODIFY columns
ORA-36962: (XSRELTBL08) string is not a valid qualified data reference for dimension workspace object.
ORA-06000: NETASY: port open failure
ORA-13015: the window definition is not valid
EXP-00065: Error writing lob to the dump file.
PCB-00242: A host variable or exact numeric constant is required here
QSM-00758: the specified parameter string is not valid for workload string
PCC-00009: Invalid host variable at column number in line number of file string
ORA-29827: keyword USING is missing
Oracle Errors 
