When setting up Web portal on Oracle database, getting error:
DBUTL_E0001 Database exception occurred: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366
[Thread-5] 2018-01-26 09:56:57 DBUTL_E0001 Database exception occured: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366
solution:
Create a user MM and a database MM with the following privileges:
sqlplus.exe SYS@<DB-NAME> as SYSDBA
-- Delete previous user and database if needed
-- DROP USER MM CASCADE;
CREATE USER MM IDENTIFIED BY MM123!;
GRANT CONNECT TO MM;
GRANT CTXAPP TO MM;
GRANT CREATE TABLE TO MM;
GRANT CREATE VIEW TO MM;
GRANT CREATE SEQUENCE TO MM;
GRANT CREATE TRIGGER TO MM;
GRANT CREATE PROCEDURE TO MM;
GRANT CREATE TYPE TO MM;
GRANT EXECUTE ON CTXSYS.CTX_DDL TO MM;
GRANT EXECUTE ON DBMS_LOB TO MM;
GRANT EXECUTE ON SYS.DBMS_LOCK TO MM;
-- If you get the error "Database exception occurred: ORA-01950: no privileges on tablespace 'USERS'"
-- ALTER USER MM QUOTA UNLIMITED ON USERS;
If Oracle is on Unix/Linux box,
the locale is not properly configured. In which case, DBA should run one the scripts found under <ORACLE_HOME>/ctx/admin/defaults. The one for American English is named drdefus.sql.
This will create the necessary objects.
One more tip is from
https://community.oracle.com/message/12691120#12691120
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center