aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter from SID_DESC

TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter from SID_DESC
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=)(PRESPAWN_MAX=15)(ORACLE_HOME=)(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=10)(TIMEOUT=30)))) Add or correct these parameters in the LISTENER.ORA file

请先 登录 后评论

1 个回答

小智
TNS-01173:SID_DESC缺少或不适当的PRESPAWN_MAX参数,
.原因:每个SID_DESC中的PRESPAWN_MAX没有必填字段。,
.操作:确保在每个SID_DESC中指定了PRESPAWN_DESC所需的参数。例如,SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = )(PRESPAWN_MAX = 15)(ORACLE_HOME = ))(PRESPAWN_DESC =(PROTOCOL = tcp)(POOL_SIZE = 10)(TIMEOUT = 30))) )在LISTENER.ORA文件中添加或更正这些参数,
.
请先 登录 后评论