Home › Discussions › Questions & Answers › Oracle Text Error on 12c DB: Missing Default Lexer

Oracle Text Error on 12c DB: Missing Default Lexer

Avatar photoCustomer Questions & Answers 3 replies

Our installation log shows ORA-29855 and DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER. We are running a 12c multitenant database. Is this a common issue in this environment?

3 replies

  • Support Enginatics

    Yes, this error is specific to certain 12c multitenant database configurations where the default lexer preference is missing. To resolve this, you need to follow the instructions provided in Oracle note 1994919.1 to create that missing default lexer preference.

  • Avatar photoCustomer

    And after creating the preference, do I simply continue the installation?

  • Support Enginatics

    You must rerun the entire Blitz Report installation script after creating the missing default lexer preference to ensure index creation and template loading succeed.

  • You must be logged in to reply to this post.