Chinaunix

标题: ora-00600 oracle致命错误 [打印本页]
作者: jdsnhan    时间: 2006-09-26 15:10
标题: ora-00600 oracle致命错误
Errors in file /opt/oracle/admin/dbjdgz/bdump/dbjdgz_smon_274.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
ORACLE Instance dbjdgz (pid = 6) - Error 600 encountered while recovering transaction (1, 3).

trace 文件如下:
Dump file /opt/oracle/admin/dbjdgz/bdump/dbjdgz_smon_871.trc
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
ORACLE_HOME = /opt/oracle/product/8.1.5
System name:        SunOS
Node name:        jdsn480
Release:        5.9
Version:        Generic_112233-05
Machine:        sun4u
Instance name: dbjdgz
Redo thread mounted by this instance: 1
Oracle process number: 6
Unix process pid: 871, image: oracle@jdsn480 (SMON)

*** SESSION ID5.1) 2006.09.26.12.07.24.000
UNDO SEG (BEFORE RECOVERY): usn = 0  Extent Control Header
  -----------------------------------------------------------------
  Extent Header:: spare1: 0      space2: 0      #extents: 12     #blocks: 299   
                  last map  0x00000000  #maps: 0      offset: 1056  
      Highwater::  0x00400bb1  ext#: 11     blk#: 18     ext size: 25   
  #blocks in seg. hdr's freelists: 0     
  #blocks below: 0     
  mapblk  0x00000000  offset: 11   
                   Unlocked
     Map Header:: next  0x00000000  #extents: 12   obj#: 0      flag: 0x40000000
  Extent Map
  -----------------------------------------------------------------
   0x00400003  length: 24   
   0x0040001b  length: 25   
   0x00400183  length: 25   
   0x0040019c  length: 25   
   0x004001b5  length: 25   
   0x004001ce  length: 25   
   0x004001e7  length: 25   
   0x00400200  length: 25   
   0x00400b6d  length: 25   
   0x00400b86  length: 25   
   0x004009ec  length: 25   
   0x00400b9f  length: 25   
  
  TRN CTL:: seq: 0x01e7 chd: 0x0011 ctl: 0x0014 inc: 0x00000000 nfb: 0x0000
            mgc: 0x8002 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
            uba: 0x00400bb1.01e7.08 scn: 0x0000.28a95b79
Version: 0x01
  FREE BLOCK POOL::
    uba: 0x00000000.01e7.07 ext: 0xb  spc: 0x1d0   
    uba: 0x00000000.01e5.0a ext: 0x9  spc: 0x38a   
    uba: 0x00000000.01b0.01 ext: 0x4  spc: 0x724   
    uba: 0x00000000.0066.07 ext: 0xa  spc: 0x514   
    uba: 0x00000000.0000.00 ext: 0x0  spc: 0x0     
  TRN TBL::

  index  state cflags  wrap#    uel         scn            dba            parent-xid    nub
  ------------------------------------------------------------------------------------------------
   0x00    9    0x00  0x03c4  0x000c  0x0000.28a95b7b  0x00400baf  0x0000.000.00000000  0x00000001   0x0000
   0x01    9    0x00  0x03c3  0x000a  0x0000.28a95b9f  0x00400bb0  0x0000.000.00000000  0x00000001   0x0000
   0x02    9    0x00  0x03c4  0x0014  0x0000.28a95ba7  0x00400bb1  0x0000.000.00000000  0x00000001   0x0000
   0x03    9    0x00  0x03c4  0x0013  0x0000.28a95b9c  0x00400bb0  0x0000.000.00000000  0x00000001   0x0000
   0x04    9    0x00  0x03c3  0x000e  0x0000.28a95b81  0x00400baf  0x0000.000.00000000  0x00000001   0x0000
   0x05    9    0x00  0x03c4  0x0006  0x0000.28a95ba2  0x00400bb1  0x0000.000.00000000  0x00000001   0x0000
   0x06    9    0x00  0x03c5  0x0008  0x0000.28a95ba4  0x00400bb1  0x0000.000.00000000  0x00000001   0x0000
   0x07    9    0x00  0x03c7  0x0004  0x0000.28a95b7f  0x00400baf  0x0000.000.00000000  0x00000001   0x0000
   0x08    9    0x00  0x03c0  0x0010  0x0000.28a95ba5  0x00400bb1  0x0000.000.00000000  0x00000001   0x0000
   0x09    9    0x00  0x03ba  0x000b  0x0000.28a95b95  0x00400bb0  0x0000.000.00000000  0x00000002   0x0000
   0x0a    9    0x00  0x03c3  0x000d  0x0000.28a95ba0  0x00400bb1  0x0000.000.00000000  0x00000001   0x0000
   0x0b    9    0x00  0x03c7  0x0003  0x0000.28a95b9a  0x00400bb0  0x0000.000.00000000  0x00000001   0x0000
   0x0c    9    0x00  0x03c5  0x0012  0x0000.28a95b7d  0x00400baf  0x0000.000.00000000  0x00000001   0x0000
   0x0d    9    0x00  0x03c4  0x0005  0x0000.28a95ba1  0x00400bb1  0x0000.000.00000000  0x00000001   0x0000
   0x0e    9    0x00  0x03c5  0x0009  0x0000.28a95b83  0x00400baf  0x0000.000.00000000  0x00000001   0x0000
   0x0f    9    0x00  0x03c5  0x0001  0x0000.28a95b9e  0x00400bb0  0x0000.000.00000000  0x00000001   0x0000
   0x10    9    0x00  0x03c7  0x0002  0x0000.28a95ba6  0x00400bb1  0x0000.000.00000000  0x00000001   0x0000
   0x11    9    0x00  0x03c4  0x0000  0x0000.28a95b7a  0x00400baf  0x0000.000.00000000  0x00000001   0x0000
   0x12    9    0x00  0x03c5  0x0007  0x0000.28a95b7e  0x00400baf  0x0000.000.00000000  0x00000001   0x0000
   0x13    9    0x00  0x03c1  0x000f  0x0000.28a95b9d  0x00400bb0  0x0000.000.00000000  0x00000001   0x0000
   0x14    9    0x00  0x03c2  0xffff  0x0000.28a95ba8  0x00400bb1  0x0000.000.00000000  0x00000001   0x0000
UNDO SEG (AFTER RECOVERY): usn = 0  Extent Control Header
  -----------------------------------------------------------------
  Extent Header:: spare1: 0      space2: 0      #extents: 12     #blocks: 299   
                  last map  0x00000000  #maps: 0      offset: 1056  
      Highwater::  0x00400bb1  ext#: 11     blk#: 18     ext size: 25   
  #blocks in seg. hdr's freelists: 0     
  #blocks below: 0     
  mapblk  0x00000000  offset: 11   
                   Unlocked
     Map Header:: next  0x00000000  #extents: 12   obj#: 0      flag: 0x40000000
  Extent Map
  -----------------------------------------------------------------
   0x00400003  length: 24   
   0x0040001b  length: 25   
   0x00400183  length: 25   
   0x0040019c  length: 25   
   0x004001b5  length: 25   
   0x004001ce  length: 25   
   0x004001e7  length: 25   
   0x00400200  length: 25   
   0x00400b6d  length: 25   
   0x00400b86  length: 25   
   0x004009ec  length: 25   
   0x00400b9f  length: 25   
  
  TRN CTL:: seq: 0x01e7 chd: 0x0011 ctl: 0x0014 inc: 0x00000000 nfb: 0x0000
            mgc: 0x8002 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
            uba: 0x00400bb1.01e7.08 scn: 0x0000.28a95b79
Version: 0x01
  FREE BLOCK POOL::
    uba: 0x00000000.01e7.07 ext: 0xb  spc: 0x1d0   
    uba: 0x00000000.01e5.0a ext: 0x9  spc: 0x38a   
    uba: 0x00000000.01b0.01 ext: 0x4  spc: 0x724   
    uba: 0x00000000.0066.07 ext: 0xa  spc: 0x514   
    uba: 0x00000000.0000.00 ext: 0x0  spc: 0x0     
  TRN TBL:

请大家帮忙分析一下。
作者: numenhuang    时间: 2006-09-26 22:34
原帖由 jdsnhan 于 2006-9-26 15:10 发表
Errors in file /opt/oracle/admin/dbjdgz/bdump/dbjdgz_smon_274.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
ORACLE Instance dbjdgz (pid = 6) - Error 600 encou ...


贴出alert_xxx.log，可能是undo tablespace或者rollback segment有corrupted blocks.
作者: zhang_yong88    时间: 2006-09-27 11:04
壇子上有一個這樣的案例﹐bitao 發過的。你找一下..

[ 本帖最后由 zhang_yong88 于 2006-9-27 11:12 编辑 ]
作者: 1017of    时间: 2006-09-27 14:38
关注
作者: rollingpig    时间: 2006-09-27 18:26
Problem Description:
-------------------

You are running transactions and begin to get ORA-600[4137] errors
in your alert log and users cannot connect to the server.  The instance
may even terminate with an ORA-7445 error.  

ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []                                                                           
ORACLE Instance odsd (pid = 6) - Error 600 encountered while recovering      
transaction (6, 106  


Solution Description:
---------------------

Check the value for the number of extents associated with the rollback segment
by running the following query:

SVRMGR> select max(extents) from v$rollstat;

If the value returned is 32767 or higher then you have encountered Bug 671491.
Please contact your local support centre for advice. You should specify a
value for maxextents that is less than 32767 for your rollback segments and
DO NOT use the unlimited specifier.

Explanation:
------------

You may have encountered Bug 671491. There is an undocumented limitation
on the maxextents you can have on a rollback segment.  When you use the
unlimited qualifier in your rollback segment it may exceed the limit and
cause the ORA-600[4137].
作者: jdsnhan    时间: 2006-09-28 09:35
原帖由 numenhuang 于 2006-9-26 22:34 发表


贴出alert_xxx.log，可能是undo tablespace或者rollback segment有corrupted blocks.

前面的内容就是log文件啊
Errors in file /opt/oracle/admin/dbjdgz/bdump/dbjdgz_smon_1541.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
ORACLE Instance dbjdgz (pid = 6) - Error 600 encountered while recovering transaction (1, 3).
Thu Sep 28 06:48:48 2006
Errors in file /opt/oracle/admin/dbjdgz/bdump/dbjdgz_smon_1541.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
Thu Sep 28 06:53:56 2006
Errors in file /opt/oracle/admin/dbjdgz/bdump/dbjdgz_smon_1541.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
ORACLE Instance dbjdgz (pid = 6) - Error 600 encountered while recovering transaction (1, 3).
每天都是同一个错误。
作者: jdsnhan    时间: 2006-09-28 09:36
to  rollingpig版主,那个bug我这里不存在。
作者: numenhuang    时间: 2006-09-28 10:10
现在数据库处于什么状态，mount/open?

sqlplus / as sysdba
select status from dba_rollback_segs 结果？



欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2