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

Oracle Text Error on 12c DB: Missing Default Lexer

Avatar photoCustomer November 22, 2021 at 6:28 pm

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?

Viewing 2 reply threads
  • Author
    Replies
    • Support November 23, 2021 at 2:20 pm  

      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 November 25, 2021 at 2:31 pm  

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

    • Support November 27, 2021 at 4:04 am  

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

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: