adgrants.sql location to fix error with 6241631
Hi,
While running the patch 6241631 we got the below error.
AD Worker error:
The following ORACLE error:
ORA-01031: insufficient privileges
occurred while executing the SQL statement:
GRANT select on DBA_PROCEDURES to em_oam_monitor_role
Error occurred in file
/opt/appl/devlappl/ad/11.5.0/patch/115/sql/ademusr.sql
with arguments '&systempwd &un_fnd &pw_fnd &un_apps &pw_apps'.
We got the solution as well from a metalink document which is given below
Solution
As indicated in the Header of file ademusr.sql adgrants.sql must be run before running this script