On some client side, today a developer got the errorORA-28112: failed to execute policy function, while running the few Oracle forms.
Reason:
On Oracle 11gR2, you will find the trace file in the folder like below.
D:\app\inam\diag\rdbms\homedb\homedb\trace
Find the trace file and review for details (I found homedb_ora_6364.trc)
Policy function execution error:
Logon user : HOME_SHAWISH
Table/View : HOME.FIN_REQ_DTL
Policy name : CMP_REQ_DTL
Policy function: HOME.CMP_POLICY_FNC
ORA-01000: maximum open cursors exceeded
The reason for this particular incident was due to the open_cursors value which was increased to resolve.
Reason:
ORA-28112: failed to execute policy function occurs when the policy function encounters some run time errors, typically unhanded exceptions. Fortunately, the error will produce a trace file in the user_dump_dest directory that can be examined and the error can be corrected.You need to see the trace file for additional details on the ORA-2812 error.
On Oracle 11gR2, you will find the trace file in the folder like below.
D:\app\inam\diag\rdbms\homedb\homedb\trace
Find the trace file and review for details (I found homedb_ora_6364.trc)
Policy function execution error:
Logon user : HOME_SHAWISH
Table/View : HOME.FIN_REQ_DTL
Policy name : CMP_REQ_DTL
Policy function: HOME.CMP_POLICY_FNC
ORA-01000: maximum open cursors exceeded
The reason for this particular incident was due to the open_cursors value which was increased to resolve.
1 comment:
A very practical and informative troubleshooting guide for ORA-28112. I particularly appreciate the focus on reviewing the trace file to identify the actual underlying error rather than treating the policy failure as the root cause. The example involving ORA-01000 and the open cursor limit clearly demonstrates how detailed diagnostics can lead to an effective resolution. A valuable reference for Oracle DBAs and developers dealing with policy function issues.
fire nozzle supplier Saudi Arabia
Post a Comment