This discussion is archived
12 Replies Latest reply: Mar 7, 2013 9:19 AM by dazasoft RSS

Oracle Text invalid after upgrade to 11.2.0.3

Martin1 Newbie
Currently Being Moderated
Hi,
i upgraded a database on Win64 from 11.2.0.1 to 11.2.0.3 Patch 10.

Now the object CTXSYS.DRIOPT is invalid and can not be validated by compilation.

Here the output of DBA_REGISTRY:
COMP_NAME VERSION STATUS
--------------------------------------------------------------------
JServer JAVA Virtual Machine 11.2.0.3.0 VALID
OLAP Analytic Workspace 11.2.0.1.0 OPTION OFF
OLAP Catalog 11.2.0.1.0 OPTION OFF
Oracle Application Express 4.1.0.00.32 VALID
Oracle Database Catalog Views 11.2.0.3.0 VALID
Oracle Database Java Packages 11.2.0.3.0 VALID
Oracle Database Packages and Types 11.2.0.3.0 VALID
Oracle Enterprise Manager 11.2.0.3.0 VALID
Oracle Expression Filter 11.2.0.3.0 VALID
Oracle Multimedia 11.2.0.3.0 VALID
Oracle OLAP API 11.2.0.1.0 OPTION OFF
Oracle Rules Manager 11.2.0.3.0 VALID
Oracle Text 11.2.0.3.0 INVALID
Oracle Workspace Manager 11.2.0.3.0 VALID
Oracle XDK 11.2.0.3.0 VALID
Oracle XML Database 11.2.0.3.0 VALID
OWB 11.2.0.1.0 VALID
Spatial 11.2.0.1.0 OPTION OFF

Many thanks in advance.

Regards,
Martin

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points