Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

adgrants.sql location to fix error with 6241631

edited Feb 27, 2013 3:03AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 5 commentsAnswered

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

https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=332782018610032&type=DOCUMENT&id=1308058.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=4ewbb8bpn_194

Solution


As indicated in the Header of file ademusr.sql adgrants.sql must be run before running this script

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center