Oracle Text Shows As Invalid But All Objects Are Valid (Doc ID 1621511.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 11.2.0.4 and later
Information in this document applies to any platform.

Goal

How can Oracle Text be validated?

all objects are valid but it appears as INVALID in DBA_REGISTRY


**********************************************************************
Database Components:
**********************************************************************
--> OLAP Catalog 11.2.0.4.0 VALID
--> Oracle Application Express 3.2.1.00.1 VALID
--> OLAP Analytic Workspace 11.2.0.4.0 VALID
--> Oracle Database Catalog Views 11.2.0.4.0 VALID
--> Oracle Database Java Packages 11.2.0.4.0 VALID
--> Oracle Database Packages and Types 11.2.0.4.0 VALID
--> Oracle Text 11.2.0.4.0 INVALID
--> Oracle Database Vault 11.2.0.4.0 VALID
--> Oracle Enterprise Manager 11.2.0.4.0 VALID
--> JServer JAVA Virtual Machine 11.2.0.4.0 VALID
--> Oracle Label Security 11.2.0.4.0 VALID
--> Oracle Multimedia 11.2.0.4.0 VALID
--> OWB 11.2.0.4.0 VALID
--> Oracle Workspace Manager 11.2.0.4.0 VALID
--> Oracle Real Application Clusters 11.2.0.4.0 VALID
--> Spatial 11.2.0.4.0 VALID
--> Oracle XML Database 11.2.0.4.0 VALID
--> Oracle XDK 11.2.0.4.0 VALID
--> Oracle OLAP API 11.2.0.4.0 VALID

**********************************************************************
Invalid Objects in CTXSYS Schema:
**********************************************************************
There are no invalid objects in the CTXSYS schema
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms