R12 E-Business Suite Patch Install Fails on Script admonusr.sql With Error 'ORA-04021: timeout occurred while waiting to lock object' Executing a Grant SQL Statement

(Doc ID 2171740.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.1.3 Applications DBA, Patch Application Issues

 




Patch installation fails with the below error:

 

ERROR
-----------------------
Start time for statement below is: Mon Aug 01 2016 05:00:00

GRANT select on gv$instance to ad_patch_monitor_role

AD Worker error:
The following ORACLE error:

ORA-04021: timeout occurred while waiting to lock object

occurred while executing the SQL statement:

GRANT select on gv$instance to ad_patch_monitor_role

Error occurred in file
/../applmgr/..../apps/apps_st/appl/ad/12.0.0/patch/115/sql/admonusr.sql
with arguments '&systempwd &un_ad &pw_ad'.

Time when worker failed: Mon Aug 01 2016 06:00:00



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms