My Oracle Support Banner

Text (Ctxsys Schema) Component Failed To Upgrade From 9.2.0.6.0 To 10.2.0.2.0 (Doc ID 559963.1)

Last updated on MARCH 31, 2020

Applies to:

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

Symptoms

We did the 10.2.0.2 upgrade on 9.2.0.6 32-bit database, the upgrade went well
except for the Oracle-text component (CONTEXT), which was not upgrade
successful.
We would like to know what has caused the upgrade of the Oracle Text component
to fail (i am sending you the upgrade log). We don't want the same issue to
occur on the same upgrade which will be done next month on our production
database becuase we don't want to de-install and re-install oracle text which
will make all oracle text indexes become invalid (there're 700 schemas x 6 text
indexes = 4300 indexes the same number of triggers to be rebuilt and this is
not an option for us).

CONTEXT
Oracle Text
10.2.0.2.0 LOADED 16-MAR-2008 10:47:42
SERVER SYS
CTXSYS
VALIDATE_CONTEXT

upgrade.log:
Warning: Procedure created with compilation errors.

Errors for PROCEDURE DRI_MOVE_CTXSYS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
47/12 PL/SQL: SQL Statement ignored
50/40 PL/SQL: ORA-00942: table or view does not exist
62/5 PL/SQL: Statement ignored
62/25 PLS-00364: loop index variable 'C1' use is invalid
63/5 PL/SQL: Statement ignored

-- Steps To Reproduce:
Upgrade from 9.2.0.6.0 to 10.2.0.2.0


Cause

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
Symptoms
Cause
Solution

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