ORA-600 [6749] ON SYSMAN.MGMT_METRICS_RAW

原创 eygle 2012-02-14

601

昨天收到的一封邮件，提到如下错误。

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;