12 Replies Latest reply: Mar 7, 2013 11:19 AM by DazaSoft RSS

    Oracle Text invalid after upgrade to 11.2.0.3

    Martin1
      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