7 Replies Latest reply on Dec 3, 2017 6:19 AM by Robeen

    Oracle E-Business Suite Applications DBA Readme, Release 12.1.3+ (R12.AD.B.Delta.4, Patch 17884289) (Doc ID 1640482.1)

    Robeen

      EBS R12.1.3

      Oracle Database 11.1.0.7

       

      Hi,

      I have to apply patch 17884289. Grateful if you can guide me through the steps. Patch is failing with adworker01 error

      Oracle E-Business Suite Applications DBA Readme, Release 12.1.3+ (R12.AD.B.Delta.4, Patch 17884289) (Doc ID 1640482.1)

      I cannot find ad_run_adgrants.xml in the patch.

      .....

      GRANT select on V$VERSION to em_oam_monitor_role

       

       

       

       

      Start time for statement below is: Fri Dec 01 2017 15:09:55

       

       

      GRANT select on DBA_DATA_FILES to em_oam_monitor_role

       

       

       

       

      Start time for statement below is: Fri Dec 01 2017 15:09:55

       

       

      GRANT select on DBA_OBJECTS to em_oam_monitor_role

       

       

       

       

      Start time for statement below is: Fri Dec 01 2017 15:09:55

       

       

      GRANT select on DBA_PROCEDURES to em_oam_monitor_role

       

       

       

       

      Start time for statement below is: Fri Dec 01 2017 15:09:55

       

       

      GRANT select on DBA_SOURCE to em_oam_monitor_role

       

       

       

       

      Start time for statement below is: Fri Dec 01 2017 15:09:55

       

       

      GRANT select on DBA_TEMP_FILES to em_oam_monitor_role

       

       

       

       

      Start time for statement below is: Fri Dec 01 2017 15:09:55

       

       

      GRANT select on DBA_USERS to em_oam_monitor_role

       

       

       

       

      Start time for statement below is: Fri Dec 01 2017 15:09:55

       

       

      GRANT select on DBA_USERS_WITH_DEFPWD to em_oam_monitor_role

       

       

      AD Worker error:

      The following ORACLE error:

       

       

      ORA-01031: insufficient privileges

       

       

       

       

      occurred while executing the SQL statement:

       

       

      GRANT select on DBA_USERS_WITH_DEFPWD to em_oam_monitor_role

       

       

      Error occurred in file

       

       

      /appl/PMTG/apps/apps_st/appl/ad/12.0.0/patch/115/sql/ademusr.sql

       

       

      with arguments '&systempwd &un_fnd &pw_fnd &un_apps &pw_apps'.

       

       

       

       

      Time when worker failed: Fri Dec 01 2017 15:09:55

       

      ...

       

      Regards,

       

      Joe