ORA-08103 Object No Longer Exists

刘泽宇

数据库出现报错：
ORA-08103: object no longer exists on AQ TABLES
或者也出现：
kwqitremb: Error 8103 in Queue Table
kwqicaclcur: Error 8103
kwqitmmit kwqitptm


参考官方文档ID：1465978.1

这个报错可能是由于Bug 12697552导致的

This]Bug 17480600 : ORA-600 [KTSFBFMT:OBJDCHK_KCBNEW_3] ON INSERT

See document for additional details - Doc ID 17480600.8

同时，官方文档上也给出了一个变通办法：

As a workaround, set the parameter _aq_tm_scanlimit = 0 to disable automatic coalesce of AQ IOTs.

1) --Disable auto coalesce by setting _aq_tm_scanlimit to 0

ALTER SYSTEM SET "_aq_tm_scanlimit"=0 SCOPE=BOTH SID='*';

2) Run flush, twice:
alter system flush buffer_cache;
alter system flush buffer_cache;

3) Stop and restart qmon
ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;

-- wait until no rows are returned that show QMNC or Q00x
select PID , spid, pname from v$process where pname like 'Q%';

--Then set to 1
ALTER SYSTEM SET aq_tm_processes=1 SCOPE=MEMORY;