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

ORA-00600 errors are strictly report to Oracle before mucking about too much, but:

1. You have a block corrupted in some way that Oracle has not anticipated.
2. The block appears to be file 21 block 90, a segment header block
3. select * from dba_segments where header_file = 21 and header_block = 90 This tell you about the thing that has gone bad.

I would hazard a guess that something has gone wrong with the handling of the segment's extent list (you seem to have maxextents unlimited on this one).

You may find that you have to drop the object to keep the database alive, but - see note at top - Don't do anything until you talk to Oracle support.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

alan_abbo_at_my-deja.com wrote in message <7uls7m$4v2$1_at_nnrp1.deja.com>...
>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.
Received on Thu Oct 21 1999 - 06:17:02 CDT