5 Replies Latest reply on May 17, 2017 11:43 AM by V. A. Nagpure

    ADJRIINITPASSWD.sql + ora-01031 while applying patch 21314548

    V. A. Nagpure

      Hi,

      We are applying patch  21314548 in our EBS 12.1.3 instance which is running on RHEL 5.5. Database version is 11.1.0.7. We are encountering this error:

       

      sqlplus -s APPS/***** @/oracle/GSTDB/apps/apps_st/appl/ad/12.0.0/patch/115/sql/ADJRIINITPASSWD.sql

      Connected.

      begin

      *

      ERROR at line 1:

      ORA-01031: insufficient privileges

      ORA-06512: at "SYS.DBMS_SESSION", line 94

      ORA-06512: at "APPS.AD_JAR", line 44

      ORA-06512: at line 2

       

      I searched on the net and found this solution:

       

      Solution:-

      Connect to apps user and run the below sql.

       

      SQL> create or replace context AD_JAR using AD_JAR;

       

      Context created.

         Reference: ADJRIINITPASSWD.sql Fails With An ORA-01031 Error When Applying Patch 17191279 (Doc ID 1597168.1)

       

      But it is not working for us. Please suggest..

       

      regards,

      Vinod