Amviccd.sql Amviccn.sql Fail With DRG-12504: stoplist ctxsys.default_stoplist does not exist

(Doc ID 2273161.1)

Last updated on JUNE 02, 2017

Applies to:

Oracle Text - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.4 version, Creating/Maintaining context indexes

amviccd.sql amviccn.sql fail with ORA-29855: error occurred in the execution of ODCINDEXCREATE rout

sqlplus -s APPS/***** @/disk96/navris/R12/apps/apps_st/appl/amv/12.0.0/patch/115/sql/amviccd.sql &un_amv &pw_amv
Connected.
DECLARE
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-12504: stoplist ctxsys.default_stoplist does not exist
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 56
 

ERROR
-----------------------
ORA-29855,ORA-20000,DRG-12504,ORA-06512

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms