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

Last updated on APRIL 01, 2020

Applies to:

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

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