My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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 ...



The XDB tablespace was dropped.


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

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