This discussion is archived
5 Replies Latest reply: Mar 25, 2013 3:12 PM by Hussein Sawwan-Oracle RSS

ORA-1031 When running merged patch (6678700)

kirkladb Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points