Problem
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)
Thursday, November 26, 2015
Sunday, November 22, 2015
Oracle EBS R12 JSP Compilation Issue Resolution
Subscribe to:
Posts (Atom)