Home / APPS DBA / R12 : Autoconfig failed on jtfictx.sh INSTE8_PRF 1 – ORA-29874

R12 : Autoconfig failed on jtfictx.sh INSTE8_PRF 1 – ORA-29874

ERROR

R12 : Autoconfig failed on jtfictx.sh INSTE8_PRF 1 – ORA-29874: warning in the execution of ODCIINDEXALTER routine

Autoconfig completed with errors.

 =============

DECLARE
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11422: linguistic initialization failed
DRG-11446: supplied knowledge base file
/u01/apps/VIS/db/tech_st/11.2.0/ctx/data/enlx/droldUS.dat not installed
ORA-06512: at “CTXSYS.DRUE”, line 160
ORA-06512: at “CTXSYS.TEXTINDEXMETHODS”, line 366
ORA-06512: at “SYS.DBMS_SQL”, line 1199
ORA-06512: at line 37

 ============= 

SOLUTION

1.Login to the database as ctxsys user and run

Conn  ctxsys/ctxsys
exec ctx_ddl.set_attribute(‘DEFAULT_LEXER’,’INDEX_THEMES’,’no’);

2. Drop and rebuild indexes

$ cd $JTF_TOP/patch/115/sql/

$ sqlplus apps/apps @jtfiimt.sql JTF JTF NULL NULL

 “jtfiaibu.sql” script is used to drop and recreate the “JTF_AMV_ITEMS_URL_CTX”  Intermediate Text index.

$ cd $JTF_TOP/patch/115/sql/
$ sqlplus apps/apps @jtfiaibu.sql JTF JTF APPS

References:

“Jtfictx.sh” Failed During Autoconfig On Application Tier, ORA-29874, DRG-10595 (Doc ID 1271186.1)
Oracle Text may not include Theme Functionality after Installation (Doc ID 262701.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