ORA-8103 / ORA-600 [KTSFBFMT:OBJDCHK_KCBNEW_3] with Single Consumer Queue Table
(Doc ID 2351184.1)
Last updated on JUNE 15, 2022
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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
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 |