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=lamp;lt;lamp;nbsp;sidlamp;gt;)(PRESPAWN_MAX=15)(ORACLE_HOME=lamp;lt;lamp;nbsp;oracle_ homelamp;gt;)(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
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=lamp;lt;lamp;nbsp;sidlamp;gt;)(PRESPAWN_MAX=15)(ORACLE_HOME=lamp;lt;lamp;nbsp;oracle_ homelamp;gt;)(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
No comments:
Post a Comment