ORA-600 [qctchr : bfl] and Invalid XDB Objects (Doc ID 1983727.1)

Last updated on MARCH 30, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Many XDB Objects are invalid and cannot be compiled, e.g.:

SQL> alter view DBA_XML_SCHEMAS compile;
alter view DBA_XML_SCHEMAS compile
  *
FEHLER in Zeile 1:
ORA-00600: Interner Fehlercode, Argumente: [qctchr : bfl], [120], [30], [1],
[31], [1], [0], [], [], [], [], []


Also, an error like below may be reported:

ORA-04098: trigger <schema>.<trigger_name> is invalid and failed revalidation.


The trace file for the ORA-600 shows a call stack with functions like:

... qctchr qctfrc qctsto2c qctsvcti qctcopn qctcopn qctclog qctclog qctclog qctcpqb qctcpqb qctcpqb qctcpqbl qctcstmt qcsdrv qcitrans qcisem ph2csql_analyze ph2stm ph2sms ph2blo ph2obl ph2sbo ph2itm ph2its ph2blo ph2obl ph2uni ph2dr2 ph2drv phpsem phpcmp pcicmp0 kkxcmp0 rpiswu2 kkxcmp kkpalt opiexe opiosq0 opiosq opiodr rpidrus skgmstack ...

 

Changes

The XDB tablespace was dropped.
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms