Re: ORA-00600: internal error code, arguments: [kcbbzo_2]

Hi,

Possible (?) problems based on

 HEADER - UNLIMITED ,i.e. unlimited extents use.

Vladimir

In article <7uls7m$4v2$1_at_nnrp1.deja.com>,   alan_abbo_at_my-deja.com wrote:
> Has anybody seen the following problem before and can shed some light
> into what happened.
>
> The instance was running fine and then shut itself down. I was able to
> restart it without any problems but the entries in the alert files
don't
> tell me anything. Details of H/W and S/w are in the second trace file.
>
> Alert log:
> Thu Oct 21 11:16:44 1999
> Thread 1 advanced to log sequence 19921
> Current log# 6 seq# 19921 mem# 0: /u6/oradata/ORA1/redoORA106b.log
> Current log# 6 seq# 19921 mem# 1: /u7/oradata/ORA1/redoORA106a.log
> Thu Oct 21 11:17:23 1999
> Errors in file /u3/app/oracle/admin/ORA1/bdump/dbw0_28756.trc:
> ORA-00600: internal error code, arguments: [kcbbzo_2], [3], [23018],
[],
> [], [],
> [], []
> Thu Oct 21 11:17:26 1999
> DBW0: terminating instance due to error 600
> Instance terminated by DBW0, pid = 28756
>
> dbw0_28756.trc:
> Dump file /u3/app/oracle/admin/ORA1/bdump/dbw0_28756.trc
> Oracle8 Enterprise Edition Release 8.0.5.2.2 - Production
> With the Partitioning and Objects options
> PL/SQL Release 8.0.5.2.1 - Production
> ORACLE_HOME = /u3/app/oracle/product/8.0.5
> System name: HP-UX
> Node name: allstar
> Release: B.10.20
> Version: U
> Machine: 9000/879
> Instance name: ORA1
> Redo thread mounted by this instance: 1
> Oracle process number: 3
> Unix process pid: 28756, image: ora_dbw0_ORA1
>
> *** 1999.10.21.11.17.22.998
> *** SESSION ID:(2.1) 1999.10.21.11.17.22.918
> BH #1969 (0xc7367840) file#: 21 rdba: 0x0540005a (21/90) class 4 ba:
> 0xcb710000
> hash: [c73712ac,c7355bec], lru: [c7302508,c73287f0]
> ckptq: [c737891c,c736371c] Fileq: [c7303304,c7303304]
> use: [c72ebd58,c72ebd58], wait: [NULL]
> st: XCURRENT, md: EXCL, rsop: 0x0, temp: 320648
> cr:[[scn: 0xffff.ffffffff],[xid: 0x0000.000.00000000],[uba:
> 0x00000000.0000.00
> ], sfl: 0x0]
> flags: buffer_dirty gotten_in_current_mode flushed redo_since_read
> L:[0x4dd1.45.68] H:[0x4dd1.45.98] R:[0x4dd1.45.98]
> buffer tsn: 21 rdba: 0x0540005a (21/90)
> scn:0x0000.00338708 seq:0x01 flg:0x00 tail:0x87081001
> frmt:0x02 chkval:0x0000 type:0x10=DATA SEGMENT HEADER -
UNLIMITED
>
> Extent Control Header
> -----------------------------------------------------------------
> Extent Header:: spare1: 0 tsn: 21 #extents: 1 #blocks:
9
> last map rdba: 0x00000000 #maps: 0 offset:
2080
> Highwater:: rdba: 0x0540005c ext#: 0 blk#: 1 ext
size:
> 9
> #blocks in seg. hdr's freelists: 0
> #blocks below: 1
> mapblk rdba: 0x00000000 offset: 0
> Unlocked
> Map Header:: next rdba: 0x00000000 #extents: 1 obj#: 23018
> flag: 0x400
> 00000
> Extent Map
> -----------------------------------------------------------------
> rdba: 0x0540005b length: 9
>
> nfl = 1, nfb = 1 typ = 2 nxf = 0
> SEG LST:: flg: UNUSED lhd: 0x00000000 ltl: 0x00000000
> Current RBA:[0x4dd1.4d.10]
> *** 1999.10.21.11.17.23.078
> ksedmp: internal or fatal error
> ORA-00600: internal error code, arguments: [kcbbzo_2], [3], [23018],
[],
> [], [],
> [], []
> ... plus more
>
> Cheers,
>
> Alan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 21 1999 - 02:58:23 CDT