问题描述
ORA-00600 6749错误,错误发生的SQL是:
DELETE FROM MGMT_METRICS_RAW WHERE ROWID = :B1
详细信息大致如下:
ORA-00600: 内部错误代码, 参数: [6749], [6], [12589877], [145], [], [], [], [] ORA-00600: 内部错误代码, 参数: [6749], [6], [12589877], [152], [], [], [], [] 打开对应的trc文件能找到以下信息: ksedmp: internal or fatal error ORA-00600: 内部错误代码, 参数: [6749], [6], [12589877], [145], [], [], [], [] Current SQL statement for this session: DELETE FROM MGMT_METRICS_RAW WHERE ROWID = :B1 ----- PL/SQL Call Stack ----- object line object handle number name 4078005C 344 package body SYSMAN.EMD_LOADER 4078005C 84 package body SYSMAN.EMD_LOADER 5092EC08 907 package body SYSMAN.EMD_MAINTENANCE 509F3E68 1 anonymous block ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- _ksedst+38 CALLrel _ksedst1+0 0 1 _ksedmp+898 CALLrel _ksedst+0 0 _ksfdmp+14 CALLrel _ksedmp+0 3 _kgeriv+146 CALLreg 00000000 B0FA298 3 _kgesiv+85 CALLrel _kgeriv+0 B0FA298 AD70020 1A5D 3 C0FAE80 _ksesic3+59 CALLrel _kgesiv+0 B0FA298 AD70020 1A5D 3 C0FAE80 1A5D 3 C0FAE80 __VInfreq__kdddgb+2 CALLrel _ksesic3+0 1A5D 0 6 0 0 C01B35 0 0 98 0 061 C0FAEFC C0FAEF8 C0FAEF4 1 B 0 2 0 0 0 0 0 0 __VInfreq__kdddel+3 CALLrel _kdddgb+0 B56E5BC 1 2F8 70 _kaudel+206 CALLrel _kdddel+0 C0FBC90 B56E5BC 0 _delrow+1813 CALLrel _kaudel+0 C0FBC8C 436DBAF8 B56E5BC 436CD620 5 28EA 0 _qerdlFetch+511 CALLrel _delrow+0 436CDDF0 7FFF _delexe+758 CALL??? 00000000 436DBDC4 0 436DBCE4 7FFF _opiexe+11211 CALLrel _delexe+0 436CDDF0 _opipls+1291 CALLrel _opiexe+0 4 5 C0FCB40 _opiodr+1099 CALLreg 00000000 66 6 C0FD478 _rpidrus+178 CALLrel _opiodr+0 66 6 C0FD478 26 _rpidru+88 CALLrel _rpidrus+0 C0FCF4C _rpiswu2+426 CALLreg 00000000 C0FD314 _rpidrv+1461 CALLrel _rpiswu2+0 5136B174 1B C0FD2E8 2 C0FD308 1B C0FD2E8 0 84DF58 84E018 C0FD314 38 _psddr0+449 CALLrel _rpidrv+0 26 66 C0FD478 38 _psdnal+283 CALLrel _psddr0+0 _pevm_EXECC+293 CALLreg 00000000 _pfrinstr_EXECC+58 CALLrel _pevm_EXECC+0 B5698E4 AD75ECC 20 _pfrrun_no_tool+56 CALL??? 00000000 B5698E4 42C24CD4 B569920 _pfrrun+781 CALLrel _pfrrun_no_tool+0 B5698E4 457E8CEA B569920 _plsql_run+738 CALLrel _pfrrun+0 B5698E4 _peicnt+247 CALLrel _plsql_run+0 B5698E4 1 0 _kkxexe+413 CALLrel _peicnt+0 _opiexe+5544 CALLrel _kkxexe+0 B56A144 _opiodr+1099 CALLreg 00000000 4 4 C0FE768 _rpidrus+178 CALLrel _opiodr+0 4 4 C0FE768 5 _rpidru+88 CALLrel _rpidrus+0 C0FE2F4 _rpiswu2+426 CALLreg 00000000 C0FE6BC _rpidrv+1461 CALLrel _rpiswu2+0 5136B174 1B C0FE690 2 C0FE6B0 1B C0FE690 0 84DF58 84E018 C0FE6BC A _rpiexe+70 CALLrel _rpidrv+0 5 4 C0FE768 A _kkjex1e+6492 CALLrel _rpiexe+0 5 _kkjsexe+341 CALLrel _kkjex1e+0 C0FEC74 1 0 C0FEC58 _kkjrdp+890 CALLrel _kkjsexe+0 _opirip+1163 CALLrel _kkjrdp+0 _opidrv+857 CALLrel _opirip+0 32 4 C0FFEC0 _sou2o+45 CALLrel _opidrv+0 32 4 C0FFEC0 _opimai_real+227 CALLrel _sou2o+0 C0FFEB4 32 4 C0FFEC0 _opimai+92 CALLrel _opimai_real+0 3 C0FFEEC _BackgroundThreadSt CALLrel _opimai+0 art@4+422 7C82481C CALLreg 00000000
专家解答
这类的错误其实可以自己尝试删除跟踪一下,应该很容易定位和处理。
如果搜索MOS,则可以很容易发现一则BUG与此相关:Bug 6127434.
Oracle提供如下临时解决方案:
1. Ensure you have a good backup before proceeding. 2. Create a copy of the SYSMAN.MGMT_METRICS_RAW table: SQL> create table SYSMAN.MGMT_METRICS_RAW_COPY as select * from SYSMAN.MGMT_METRICS_RAW; 3. Truncate the table: SQL> truncate table SYSMAN.MGMT_METRICS_RAW; May need to disable trigger: "sysman.raw_metrics_after_insert" before proceeding. Re-enable after the insert. 4. Re-insert the rows: SQL> insert into SYSMAN.MGMT_METRICS_RAW select * from SYSMAN.MGMT_METRICS_RAW_COPY; SQL> commit; 5. Drop the copy table: SQL> drop table SYSMAN.MGMT_METRICS_RAW_COPY;
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。