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’;
[edsanimate_start entry_animation_type= “fadeIn” entry_delay= “0.5” entry_duration= “0.5” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]
Reference : Can Not Validate CTXSYS.DRIACC Package (Doc ID 1906873.1)
[edsanimate_end]