Database Software

Upgrading 8.1.7.2 to 9.2.0.1.0 on Linux.

After executing both sets of scripts (s0900010.sql, s0902000.sql, u0900010.sql & u0902000.sql) as the appropriate users & recompiling all objects, the CTXSYS.CONEXT indextype remained in an invalid state.

Attempts to compile it returned:
alter indextype ctxsys.context compile
*
ERROR at line 1:
ORA-29836: failed to validate referenced operators

So I went off to compile the referenced operators.

SQL> select owner, operator_name from dba_operators where owner='CTXSYS';

OWNER OPERATOR_NAME
------------------------------ ------------------------------
CTXSYS CATSEARCH
CTXSYS CONTAINS
CTXSYS MATCHES
CTXSYS SCORE
CTXSYS XPCONTAINS

SQL> alter operator ctxsys.catsearch compile;

Operator altered.

1* alter operator ctxsys.contains compile
SQL> /

Operator altered.

1* alter operator ctxsys.matches compile
SQL> /

Operator altered.

1* alter operator ctxsys.score compile
SQL> /

Operator altered.

SQL> alter operator ctxsys.xpcontains compile;

Operator altered.

But compiling ctxsys.context continues to fail with the same error.

What am I missing?

Thanks,
Chris