ORA-8103 / ORA-600 [KTSFBFMT:OBJDCHK_KCBNEW_3] with Single Consumer Queue Table

(Doc ID 2351184.1)

Last updated on JANUARY 25, 2018

Applies to:

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

Symptoms

The following error(s) is reported in the alert log:

ORA-8103: object no longer exists

and / or

ORA-600 [ktspfmdb:objdchk_kcbnew_3]

On review of a trace generated at the time of the error, the section 'Current SQL Statement for this session' references a single consumer queue table.

Changes

 Either:

- underlying AQ object index(es) of the queue table were modified/altered in some way such as an ALTER INDEX on AQ$_<queue table>_I.  Operations before the ALTER succeeded, but after the ALTER they fail.

or

- queue table was purged recently

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