Home / APPS DBA / EBS 12.2.4 application tier autoconfig fails with following error

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 Ali

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

OracleEBSerror

AC-50480: Internal error occurred

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora

Leave a Reply