TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter
from SID_DESC



TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter from SID_DESC..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-29307: datafile string error, string

1 Answers  


RMAN-03003: command not implemented yet: string

1 Answers  


ORA-27020: named devices not supported

1 Answers  


ORA-13212: failed to compare tile with the window object

1 Answers  


ORA-02827: Invalid file number

1 Answers  






ORA-14626: values being added already exist in DEFAULT subpartition

1 Answers  


DRG-50942: errors: stringstring

1 Answers  


ORA-06033: NETDNT: connect failed, partner rejected connection

1 Answers  


KUP-04030: invalid numeric data

1 Answers  


PROT-00009: Failed to open the specified import file

1 Answers  


ORA-15110: no diskgroups mounted

1 Answers  


RMAN-05515: Duplicate for standby does not allow the use of SET UNTIL

1 Answers  


Categories