AD delta 11 upgrade Patch 26834480 or AD delta 12 upgrade Patch 30628681 is failing failed: file ademusr.sql on worker 1 with ORA-01031: insufficient privileges
issue:
sqlplus -s APPS/***** @/erp_appl/apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/erp_appl/apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/ademusr.sql &systempwd &un_fnd &pw_fnd &un_apps &pw_apps'
Connected.
PL/SQL procedure successfully completed.
Connected.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Grant succeeded.
Grant succeeded.
PL/SQL procedure successfully completed.
Connected.
declare
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at line 168
ORA-06512: at line 256
Solution:
Connect as applsys and grant below privilege to APPS.
GRANT select on applsys.WF_DEFERRED_TABLE_M to APPS with grant option;
GRANT select on applsys.WF_ERROR to APPS with grant option;
adop phase=apply patches=30628681 abandon=yes
Thank you so much.. i was struggling for 3hrs on this
ReplyDeletemay i know the verision of DB and EBS you had while running this
ReplyDelete