5 Replies Latest reply: Mar 25, 2013 5:12 PM by Hussein Sawwan-Oracle RSS

    ORA-1031 When running merged patch (6678700)

    kirkladb
      All:
      I am running the merged patch for the upgrade patch driver and my patching dies when I attempt to run a sql statement (xlainqgn.sql). The error message is

      ORA-01031: insufficient privileges

      GRANT EXECUTE ON DBMS_AQADM TO APPS WITH GRANT OPTION

      It is attempting to execute this as system user. I have explicitly granted the permissions to system with the grant option. No luck. I created a private synonym for sys.dbms_aqadm in the system account, no luck. Am I missing something? Any assistance is greatly appreciated
        • 1. Re: ORA-1031 When running merged patch (6678700)
          Hussein Sawwan-Oracle
          kirkladb wrote:
          All:
          I am running the merged patch for the upgrade patch driver and my patching dies when I attempt to run a sql statement (xlainqgn.sql). The error message is

          ORA-01031: insufficient privileges

          GRANT EXECUTE ON DBMS_AQADM TO APPS WITH GRANT OPTION

          It is attempting to execute this as system user. I have explicitly granted the permissions to system with the grant option. No luck. I created a private synonym for sys.dbms_aqadm in the system account, no luck. Am I missing something? Any assistance is greatly appreciated
          Run "GRANT EXECUTE ON DBMS_AQADM TO APPS WITH GRANT OPTION" as sysdba and check then.

          $ sqlplus / as sysdba

          SQL> GRANT EXECUTE ON DBMS_AQADM TO APPS WITH GRANT OPTION;

          Thanks,
          Hussein
          • 2. Re: ORA-1031 When running merged patch (6678700)
            kirkladb
            That didn't work unfortunatly. It still says ORA-01031: insufficient privileges occurring while execuing the SQL statement

            GRANT EXECUTE ON DBMS_AQADM TO APPS WITH GRANT OPTION

            even though I explicitly granted APPS the permissions as sys as sysdba. The script is definitely trying to do this as SYSTEM

            Should I:
            (a) skip the job
            (b) Go to $XLA_TOP/patch/115/sql/xlaimqgn.sql and modify the grant statement somehow?

            Thanks Hussein
            • 3. Re: ORA-1031 When running merged patch (6678700)
              Hussein Sawwan-Oracle
              kirkladb wrote:
              That didn't work unfortunatly. It still says ORA-01031: insufficient privileges occurring while execuing the SQL statement

              GRANT EXECUTE ON DBMS_AQADM TO APPS WITH GRANT OPTION

              even though I explicitly granted APPS the permissions as sys as sysdba. The script is definitely trying to do this as SYSTEM

              Should I:
              (a) skip the job
              (b) Go to $XLA_TOP/patch/115/sql/xlaimqgn.sql and modify the grant statement somehow?

              Thanks Hussein
              It does work for me!
              SQL> show user
              USER is "SYS"
              
              SQL> GRANT EXECUTE ON DBMS_AQADM TO APPS WITH GRANT OPTION;
              
              Grant succeeded.
              Once you run the command successfully you can skip the failed worker.

              Thanks,
              Hussein
              • 4. Re: ORA-1031 When running merged patch (6678700)
                kirkladb
                Hussein:
                I got the issue resolved...it was a bug

                Granting the Execute Privilege on SYS Owned Packages Fails with ORA-01031 On 11.2.0.3.0 (DocID: 1393228.1)
                • 5. Re: ORA-1031 When running merged patch (6678700)
                  Hussein Sawwan-Oracle
                  kirkladb wrote:
                  Hussein:
                  I got the issue resolved...it was a bug

                  Granting the Execute Privilege on SYS Owned Packages Fails with ORA-01031 On 11.2.0.3.0 (DocID: 1393228.1)
                  Thanks for the update and for sharing the solution!

                  Regards,
                  Hussein