9 Replies Latest reply: Feb 16, 2010 6:14 AM by 750097 RSS

    Repeated get - ORA-28112: failed to execute policy function

    smitt
      Clicking various functions in OEM Grid Control 10.2.0.5 generates :

      ORA-28112: failed to execute policy function

      Various functions like - Clicking the main target tab, clicking on a target, logging into a database (target)

      2009-06-23 13:10:48,028 [EMUI_13_10_48_/console/home] ERROR home.ConsoleHome initConsoleHomeData.803 - ORA-28112: failed to execute policy function
      ORA-06512: at "SYSMAN.EMD_MNTR", line 4484
      ORA-06512: at "SYSMAN.EMD_MNTR", line 4243
      ORA-06512: at line 1

      or

      2009-06-23 12:59:59,170 [EMUI_12_59_59_/console/database/instance/sitemap] ERROR db.bsln isSatisified.2433 - ORA-28112: failed to execute policy function


      This happens repeatedly, but not every time. (945 times since 5:00 PM yesterday)

      Anyone else see these errors or provide some ideas?

      I've :
      Shutdown and restarted both OMS and Repository database
      Flushed shared pool
      Increased OPEN_CURSORS to 2000

      nothing has helped.

      thanks -
        • 1. Re: Repeated get - ORA-28112: failed to execute policy function
          19426
          Any errors in emoms.trc? Most common reason is OPEN_CURSORS value, but there may be others.

          Werner
          • 2. Re: Repeated get - ORA-28112: failed to execute policy function
            smitt
            Here's the error messages in emoms.trc - There are 979 or so similar to this since 9:00 AM on 6/23.

            2009-06-23 14:40:28,468 [EMUI_14_40_28_/console/targets] ERROR pref.SubtabPref getFolders.789 - ORA-28112: failed to execute policy function
            ORA-06512: at "SYSMAN.EMD_PREF", line 52
            ORA-06512: at line 1

            java.sql.SQLException: ORA-28112: failed to execute policy function
            ORA-06512: at "SYSMAN.EMD_PREF", line 52
            ORA-06512: at line 1

            at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
            at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)
            at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:183)
            at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:872)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3000)
            at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3092)
            at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4285)
            at oracle.sysman.util.jdbc.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:175)
            at oracle.sysman.util.jdbc.CallableStatementWrapper.execute(CallableStatementWrapper.java:135)
            at oracle.sysman.eml.pref.SubtabPref.getFolders(SubtabPref.java:684)
            at oracle.sysman.eml.mntr.target.TargetData.doNull(TargetData.java:537)
            at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
            <snip>
            • 3. Re: Repeated get - ORA-28112: failed to execute policy function
              smitt
              Also - found these errors in user dump area in file "omsdb_ora_26649.trc" :

              ----------------------------------------------------------
              Policy function execution error:
              Logon user : SYSMAN
              Table/View : SYSMAN.MGMT_TARGETS
              Policy name : TARGET
              Policy function: SYSMAN.EM_USER_MODEL.EM_POLICY_FUNC
              ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters
              ORA-06512: at "SYSMAN.EM_USER_MODEL", line 1332
              ORA-06512: at "SYSMAN.EM_USER_MODEL", line 953
              ORA-06512: at line 1
              *** ACTION NAME:(/targets) 2009-06-23 14:40:28.467
              *** MODULE NAME:(OEM.DefaultPool) 2009-06-23 14:40:28.467
              *** CLIENT ID:(xxxxxxx@10.11.11.xxxx@Mozilla/4.0 (compatible; MSIE 6.0; Windows) 2009-06-23 14:40:28.467
              *** 2009-06-23 14:40:28.467
              • 4. Re: Repeated get - ORA-28112: failed to execute policy function
                19426
                I think you should open a SR on metalink, the only hint about this error deals with OPEN_CURSORS, but you already increased the number and there's nothing like 'maximum exceeded' in emoms.trc.

                Werner
                • 5. Re: Repeated get - ORA-28112: failed to execute policy function
                  smitt
                  Opened up an SR on metalink - I'll post the findings as I get them.

                  Note that the repository db and OMS run on a single Linux server. Rebooting the Linux Server (and, of course restarting the repository db, OMS, & local agent), seems to alleviate the problem until something "tickles" it again.
                  • 6. Re: Repeatedly get - ORA-28112: failed to execute policy function
                    smitt
                    We believe that this was caused by RDBMS bug 5890966. We upgraded the repository database to RDBMS version 10.2.0.4 - and this apparently has fixed the problem. We have not received the same errors in the OMS emoms.trc or database user dump traces.

                    Here's some info from support in the SR -
                    RESEARCH
                    =========
                    Note 828524.1 ORA-28112 Failed To Execute Policy Function At SYSMAN.EM_GROUPS_UI

                    Cause

                    Database Bug 5890966 : INTERMITTENT ORA-6502 DURING PEAK LOADING

                    The issue is intermittently because occurs only during peak loads.
                    Solution
                    Apply Database Patch 5890966 to repository database or upgrade the repository database to 10.2.0.4

                    Thanks for your replies.
                    • 7. Re: Repeatedly get - ORA-28112: failed to execute policy function
                      19426
                      Thanks for the update, will help others.

                      Werner
                      • 8. Re: Repeatedly get - ORA-28112: failed to execute policy function
                        750097
                        Thanks for information
                        • 9. Re: Repeatedly get - ORA-28112: failed to execute policy function
                          750097
                          I had the exact same problem, tried everything, but did not work.

                          I have now upgraded the rep database to 10.2.0.4 and all problems are gone.