Error 8103 in Queue Table SYSMAN.MGMT_TASK_QTABLE
(Doc ID 1984585.1)
Last updated on DECEMBER 31, 2019
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
All objects associated with Queue Table SYSMAN.MGMT_TASK_QTABLE are Valid. Still getting below error.
ORA-08103: object no longer exists Error 8103 in Queue Table SYSMAN.MGMT_TASK_QTABLE.
select owner,object_name,object_type,status from dba_objects where object_name like '%MGMT_TASK_Q%' order by 3,2
SQL> /
OWNER OBJECT_NAME OBJECT_TYPE STATUS
------- ------------------------------ ------------ ------
SYSMAN AQ$_MGMT_TASK_QTABLE_I INDEX VALID
SYSMAN AQ$_MGMT_TASK_QTABLE_T INDEX VALID
SYSMAN MGMT_TASK_QTABLE_IDX01 INDEX VALID
SYSMAN MGMT_TASK_QTABLE_IDX02 INDEX VALID
SYSMAN AQ$_MGMT_TASK_QTABLE_E QUEUE VALID
SYSMAN MGMT_TASK_Q QUEUE VALID
SYSMAN MGMT_TASK_QTABLE TABLE VALID
SYSMAN AQ$MGMT_TASK_QTABLE VIEW VALID
SYSMAN AQ$_MGMT_TASK_QTABLE_F VIEW VALID
9 rows selected.
Changes
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 |