My Oracle Support Banner

Checklist for Errors in WebCenter Content that Reference Object in the CTXSYS Schema (Doc ID 1403120.1)

Last updated on MARCH 05, 2024

Applies to:

Oracle WebCenter Content - Version 10.0 and later
Information in this document applies to any platform.

Goal

When errors appear in WebCenter Content during a collection rebuild and SearchIndexerEngineName is set to DATABASE.FULLTEXT or OracleTextSearch, the errors may contain a reference to objects in the CTXSYS schema. If this occurs, a checklist on the CTXSYS schema should be performed to verify that the Oracle Text part of the database is in working order. 

The following steps must be performed by a database administrator, not as the WebCenter Content user.  

Solution

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution
 Check that the CTXSYS user exists and is unlocked.
 Check for invalid objects in the CTXSYS schema:
 Check the contentserver_role for proper assignments.


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.