ORA-00600: internal error code, arguments: [qctVCO:csform] ORA-64131 ORA-01403 Errors After Upgrade From 11.2.0.1 To 11.2.0.3 (Doc ID 1394206.1) when database is running in the Chinese language

Solution

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 or 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 24-Jul-2013***

SYMPTOMS

After upgrading the database from 11.2.0.1.0 to 11.2.0.2 or 11.2.0.3.0, XDB upgraded successfully but now there are XDB errors of:

Tue Jan 10 13:22:01 2012
XDB installed.
XDB initialized.
..
ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [1], [2], [213], [], [], [], []
ORA-64131: XMLIndex Metadata: failure during the looking up of the dictionary
ORA-01403: no data found

And the following object(s) are invalid in the database:

SYS ALL_XSC_SECURITY_CLASS_DEP VIEW
SYS ALL_XSC_SECURITY_CLASS VIEW
SYS ALL_XSC_PRIVILEGE VIEW
SYS ALL_XSC_AGGREGATE_PRIVILEGE VIEW
SYS ALL_XSC_SECURITY_CLASS_STATUS VIEW

Attempts to recompile these objects also fail with the above errors.

CAUSE

This issue was caused due to objects in the XDB schema recycle bin that were not purged out.


Since these objects were in the recycle bin of XDB, we could not drop the indexes that were at fault here that would allow us to rebuild the views.

SOLUTION

To resolve this issue, first purge the XDB recycle bin;

conn xdb/password
purge recyclebin;

Then, connect as SYS and drop the following indexes:

drop index xdb.sc_xidx force;
drop index xdb.prin_xidx force;
drop index xdb.xdb$acl_spidx;
drop index xdb.xdb$acl_xidx force;

Then attempt to recompile the views manually:

alter view <viewname> compile;

The indexes dropped here are no longer necessary for XDB in 11.2.0.3.0, so they do not need to be rebuilt.
To rebuild indexes in 11.2.0.2 reload XDB as in note 1292089.1

SQL> spool xdbreload.log
SQL> connect / as sysdba
SQL> set echo on;
SQL> shutdown immediate;
SQL> startup upgrade;
SQL> @?/rdbms/admin/xdbrelod.sql
SQL> shutdown immediate;
SQL> startup;
SQL> @?/rdbms/admin/utlrp.sql
SQL> spool off