Oracle-L: ORA-600 Error [Possible Data Loss]

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Wed, 17 Sep 2003 16:04:44 -0800
Message-ID: <F001.005D0426.20030917160444@fatcity.com>

This is not my week ...

Has anyone seen anything like this

select value from chanarch_nlc.old_archive_wave_i partition (SEP1603) where pv_id =

ERROR at line 1:
ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [], [], [], [], []

I have Oracle support working on the problem. They say they have never seen such an error before. Oracle though often tells me that. The table looks like

Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
PV_ID                                              NUMBER(38)
TIMESTAMP                                          DATE
NANOSECS                                           NUMBER(9)
STAT                                               NUMBER(8)
SEVR                                               NUMBER(8)
OSTAT                                              NUMBER(16)
VALUE                                              CHANARCH_NLC.INT_VALUES

The last column is a varray. I can retrieve any of the other columns from that partition. I can also retrieve the value column from any partition before September 11, 2003. Any partition after that fails with the 0ra-600 error when the value column is selected.

DBV at first gave errors along the lines of

BV-00102: File I/O error on FILE
(/u9/oradata/NLCO/chanarch_nlc_active_data01.dbf) during end read op eration (-1)

The file is 2018 MB in size. But resizing the files downwards and back up again fixed That problem. The files are allowed to autoextend with 2018 being the maximum size.

This is not the same database which had the RAID problem.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Sep 17 2003 - 19:04:44 CDT