My Oracle Support Banner

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

Last updated on DECEMBER 06, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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
  *
ERROR in line 1:
ORA-00600: Internal error code, arguments: [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

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
Changes
Cause
Solution
References


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