While Applying Patch on Customer environment, adpatch failed with error
Worker log has the below error.
=====================
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
/test12/applmgr/1200/ad/12.0.0/patch/115/sql/ademusr.sql
with arguments ‘&systempwd &un_fnd &pw_fnd &un_apps &pw_apps’.
==============
Worker log has the below error.
=====================
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
/test12/applmgr/1200/ad/12.0.0/patch/115/sql/ademusr.sql
with arguments ‘&systempwd &un_fnd &pw_fnd &un_apps &pw_apps’.
==============
Solution
=========
1.Login to oracle database server as oracle user
2. Connect to sqlplus as sysdba and run the failed sql statement
sqlplus / as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> GRANT select on DBA_USERS_WITH_DEFPWD to em_oam_monitor_role
2 ;
Grant succeeded.
SQL>
3. Use adctrl to skip the failed worker (Option 8) and continue with Patching
I’m often to blogging and i really appreciate your content. The article has actually peaks my interest. I’m going to bookmark your web site and maintain checking for brand spanking new information.
I am truly thankful to the owner of this web site who has shared this fantastic piece of writing at at this place.
For the reason that the admin of this site is working, no uncertainty very quickly it will be renowned, due to its quality contents.
Nice post. I learn something totally new and challenging on websites
Hi there to all, for the reason that I am genuinely keen of reading this website’s post to be updated on a regular basis. It carries pleasant stuff.