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/CRP/fs1/inst/apps/CRP_oracle/admin/install
jtfictx.sh INSTE8_PRF 1
AutoConfig is exiting with status 1
Cause
DECLARE
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drixmd.GetIndexRec
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 948
ORA-06512: at "CTXSYS.AD_CTX_DDL", line 336
ORA-06512: at line 96
Solution
connect /as sysdba
ALTER SESSION SET CURRENT_SCHEMA=SYS;
grant select on SYS.DBA_PROCEDURES to ctxsys;
ALTER SESSION SET CURRENT_SCHEMA=CTXSYS;
SET PAGESIZE 0
SELECT 'Calling ctx/admin/driacc.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10
@@?/ctx/admin/driacc.plb;
@$ORACLE_HOME/rdbms/admin/utlrp.sql
set serveroutput on
execute sys.validate_context;
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)
Thanks
Srini
This detailed post on the Oracle EBS 12.2.4 application tier offers exceptional insights into managing a complex system environment. The step-by-step breakdown and clear explanations help demystify the intricacies of configuring and maintaining the application tier, making it an invaluable resource for IT professionals and database administrators. Your guide not only simplifies challenging processes but also provides practical tips that enhance system performance and reliability. Additionally, for those interested in enhancing multimedia presentations or technical tutorials, consider checking out adobe after effects editing service for professional video editing solutions.
ReplyDelete