TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAX

TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAX
Cause: The minimum value for PRESPAWN_MAX should be the sum of the POOL_SIZEs.
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))(PRESPAWN_DESC=(PROTOCOL=ipc)(POOL_SIZE=5)(TIMEOUT=15)))) Add or correct these parameters in the LISTENER.ORA file

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:00

TNS-01174：每个PRESPAWN_DESC的POOL_SIZE的总和大于PRESPAWN_MAX,
.原因： PRESPAWN_MAX的最小值应为POOL_SIZE的总和。,
.操作：确保在每个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）） PRESPAWN_DESC =（PROTOCOL = ipc）（POOL_SIZE = 5）（TIMEOUT = 15））））在LISTENER.ORA文件中添加或更正这些参数,
.

aiaiDBA

13718043309

010-86462881

TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAX

1 个回答

相似问题