EBS 12.2.4 application tier autoconfig fails with following error

ERROR

Oracle EBS 12.2.4 application tier autoconfig fails with following error.

WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts: 
    Directory: /u01/apps/fs1/inst/apps/apps_oracle/admin/install
      jtfictx.sh              INSTE8_PRF         1 

AutoConfig is exiting with status 1

SOLUTION

$connect /as sysdba 

SQL>ALTER SESSION SET CURRENT_SCHEMA=SYS; 

SQL>grant select on SYS.DBA_PROCEDURES to ctxsys; 

SQL>ALTER SESSION SET CURRENT_SCHEMA=CTXSYS; 
SQL>SET PAGESIZE 0 
SQL>SELECT ‘Calling ctx/admin/driacc.plb on ‘ || SYSTIMESTAMP FROM dual; 
SQL>SET PAGESIZE 10 

SQL>@?/ctx/admin/driacc.plb; 

SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql 

SQL>set serveroutput on 
SQL>execute sys.validate_context; 

SQL>select comp_name, status, substr(version,1,10) as version from dba_registry where comp_id = ‘CONTEXT’;

Reference :  Can Not Validate CTXSYS.DRIACC Package (Doc ID 1906873.1)

 

About Syed Saad

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

Oracle Database Archive Log Generation Details

Oracle Database Archive Log Generation Details   The Blog presents a script designed to query …

Leave a Reply