While Applying Patch 21314548:R12.AD.B.DELTA.7 using adpatch, Patch worker failed at running the script ademusr.sql.
To begin troubleshooting the issue,First check the worker id which was running the failed script.
We can get this information from Patch logfile[adpatch.log or u21314548.log] or console output while applying the patch.
Check the worker logfile[adworkxxx.log] for the failed worker
Errors in workerlog
===================
ORA-01031 occurs while Granting SELECT on DBA_USERS_WITH_DEFPWD to em_oam_monitor_role For Patch 20395533 (Doc ID 2093641.1)
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
/test1/applmgr/1213/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 Mar 04 2016 09:48:00
The error occurred because worker is running the scripts as apps user, and APPS user does not have enough privileges to grant DBA_USERS_WITH_DEFPWD
Solution
========
1.Run the below sql statements to grant the role as system user.
SQL> show user
USER is “SYS”
SQL> GRANT select on DBA_USERS_WITH_DEFPWD to SYSTEM with grant option;
Grant succeeded.
SQL> show user
USER is “SYSTEM”
SQL> GRANT select on DBA_USERS_WITH_DEFPWD to em_oam_monitor_role;
Grant succeeded.
2. Restart the failed worker using adctrl.
3. Monitor Patching until completion.