eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« Oracle Database 12c (Cloud)华丽来袭 | Blog首页 | 万水千山走过 有你陪伴真好 »

ORA-600 [6749] ON SYSMAN.MGMT_METRICS_RAW

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

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; 

供参考。



历史上的今天...
    >> 2011-02-14文章:
    >> 2008-02-14文章:
           Be A Oracle ACE Director
    >> 2007-02-14文章:
           新年 新婚
    >> 2006-02-14文章:
           情人节的玫瑰

无觅

By eygle on 2012-02-14 11:48 | Comments (1) | Case | 2954 |

1 Comment

eygle,在备份SYSMAN.MGMT_METRICS_RAW时出错,ORA-00600:[kdsgrp1], [], [], [], [], [], [], []
*** SESSION ID:(147.14) 2012-02-16 13:14:30.421
row 00000000.ffffffff continuation at
file# 3 block# 6965 slot 155 not found
============
Plan Table
============
-----------------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-----------------------------------------------------+-----------------------------------+
| 0 | CREATE TABLE STATEMENT | | | | 2081 | |
| 1 | LOAD AS SELECT | | | | | |
| 2 | INDEX FAST FULL SCAN | MGMT_METRICS_RAW_PK| 35K | 2107K | 2012 | 00:00:25 |
-----------------------------------------------------+-----------------------------------+
很奇怪,根据file#、block#得到的结果不是索引MGMT_METRICS_RAW_PK,而是溢出表SYS_IOT_OVER_10474
TABLESPACE_NAME SEGMENT_TYPE OWNER BLOCK_ID SEGMENT_NAME
1 SYSAUX TABLE SYSMAN 6961 SYS_IOT_OVER_10474
2 SYSAUX INDEX SYSMAN 6969 MGMT_METRICS_RAW_PK


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com