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;
ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [
来源:这里教程网
时间:2026-03-03 17:15:21
作者:
编辑推荐:
- ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [03-03
- PSD文件误删了怎么恢复?教你三招03-03
- 删除的PSD文件在哪可以恢复?一定要看看03-03
- PDF不小心删掉了怎么恢复?三步专业恢复03-03
- 【SCRIPT】Oracle巡检报告html格式样例,带趋势图03-03
- impdp导入报ORA-00001 ORA-04088错误03-03
- [20211126]完善tpt pr.sql脚本.txt03-03
- 几种主要的oracle数据库问题发生后数据恢复的成功概率分析03-03
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- PSD文件误删了怎么恢复?教你三招
PSD文件误删了怎么恢复?教你三招
26-03-03 - 删除的PSD文件在哪可以恢复?一定要看看
删除的PSD文件在哪可以恢复?一定要看看
26-03-03 - PDF不小心删掉了怎么恢复?三步专业恢复
PDF不小心删掉了怎么恢复?三步专业恢复
26-03-03 - 【SCRIPT】Oracle巡检报告html格式样例,带趋势图
【SCRIPT】Oracle巡检报告html格式样例,带趋势图
26-03-03 - 几种主要的oracle数据库问题发生后数据恢复的成功概率分析
几种主要的oracle数据库问题发生后数据恢复的成功概率分析
26-03-03 - ORACLE 11.2.0.4 for solaris更换硬件后主机时间改变导致一节点集群服务无法启动
- oracle打补丁回顾
oracle打补丁回顾
26-03-03 - 2021 DFA亚洲最具影响力设计奖作品
2021 DFA亚洲最具影响力设计奖作品
26-03-03 - 被格式化的硬盘文件能恢复吗,三步恢复格式化硬盘
被格式化的硬盘文件能恢复吗,三步恢复格式化硬盘
26-03-03 - 【ASK_ORACLE】Oracle Data Guard(一)DG架构
【ASK_ORACLE】Oracle Data Guard(一)DG架构
26-03-03
