My Oracle Support Banner

How to Verify all WebCenter Content (WCC) OracleTextSearch (OTS) Database Objects Exist and are Valid (Doc ID 1226733.1)

Last updated on MAY 22, 2020

Applies to:

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


The goal of this note is to provide some SQL queries that can be run against a database to verify if all database objects required by the OracleTextSearch component exist, and are valid.


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
 1. Verify that the Content Server user has the required roles granted:
 2. Verify that the CONTENTSERVER_ROLE has been correctly created:
 2.a. System privileges granted to CONTENTSERVER_ROLE:
 2.b. Role privileges granted to CONTENTSERVER_ROLE:
 2.c. Object privileges granted to CONTENTSERVER_ROLE:
 3. Verify that the PL/SQL packages and types exist:
 4. Verify that all indexes and tables exist:

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