ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [

哎呀我的天吶 發表於 2021-11-25

expdp匯出報錯!! 打完補丁記著要開啟


ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [65969], [433], [85888], [1], [], [], [], [], [], [], []
----------

I confirmed there are two bugs to match this issue now.
ORA-00600 [qosdExpStatRead: expcnt mismatch] will happen even after applied both patch 28681153 and patch 31143146,
if you don't try the workaround of MOS 
Note 28681153.8  at both CDB and PDB.

 - ORA-600: [qosdexpstatread: expcnt mismatch] ( 
Doc ID 28681153.8  )
 - ORA-600: [qosdexpstatread: expcnt mismatch] even after applying 28681153 ( 
Doc ID 31143146.8  )

Please follow these steps to check if the issue resolves.

1. Try workaround of MOS 
Note 28681153.8  at both CDB and PDB.

With b as (
select count(*) cnt,objn,snapshot_id from sys.exp_stat$ es group by
objn,snapshot_id)
select * from sys.exp_obj$ a, b where a.objn=b.objn and
a.snapshot_id=b.snapshot_id
and a.EXP_CNT<>b.CNT;


delete from sys.exp_stat$ b
where b.snapshot_id = <snapshot_id> and b.objn = <objn> ;

update sys.exp_obj$ a
set a.EXP_CNT=0
where a.SNAPSHOT_ID= <snapshot_id>
and a.objn = <objn>;

commit;

2. Run below SQL again to check the query result. "no rows return" is expected.

With b as (
select count(*) cnt,objn,snapshot_id from sys.exp_stat$ es group by
objn,snapshot_id)
select * from sys.exp_obj$ a, b where a.objn=b.objn and
a.snapshot_id=b.snapshot_id
and a.EXP_CNT<>b.CNT;

3. Turn on the fix control of patch 31143146 as following:
alter system set "_fix_control"='31143146:on' scope=both;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29990276/viewspace-2844085/,如需轉載,請註明出處,否則將追究法律責任。