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

 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


Screenshot
--------------






appsdbahelp

17+ years of experience in Oracle Database, Oracle Cloud Infrastructure(OCI), Oracle EBS on Cloud, Oracle E-Business Suite, DevOps tools, Oracle WebLogic, Oracle Application Server, Oracle Access Manager and various Operating System flavors including Redhat Linux, UNIX (Solaris, HP-UX) and Windows. Expert in Oracle9i/10g/11g/12c/19c database administration, upgrade, configuration and tuning. Experience in Oracle E-Business Suite technological stack, including architecture, installation, configuration, maintenance, tuning, cloning and patching procedures. Expert in Oracle Cloud Infrastructure(OCI), Oracle EBS On Cloud and Oracle EBS Cloud Manager Experience with Oracle Cloud Solution and Expert of Oracle ERP/Oracle HCM Cloud deployment Experience in Terraform, JSON and chef cloud infrastructure automation framework Knowledge of ASM, Data Guard, Real Application Cluster, Exadata and Exalogic Knowledge of Oracle Enterprise Manager(OEM) Grid Control, Oracle WebLogic, Oracle Internet Directory, Oracle Access Manager and Apache Ability to analyze problem, develops solutions and bring program/project execution to completion.

2 Comments

  1. Thank you so much.. i was struggling for 3hrs on this

    ReplyDelete
  2. may i know the verision of DB and EBS you had while running this

    ReplyDelete
Previous Post Next Post