RE: ORA-600 Error [Possible Data Loss]

The varray data is stored in a LOB. So I expect direct export will not work. But I'll give it a try.

Ian

-----Original Message-----
Sent: Thursday, September 18, 2003 1:35 PM To: Multiple recipients of list ORACLE-L

Ian,

I was going to recommend to try exporting your problematic partition with direct=y, that way normal SQL query processing layer is bypassed in Oracle kernel & all data belonging to segment is read directly (thus hopefully avoiding the koxsisz1 crash) ... but I'm not sure whether varrays don't turn exp to conventional as is the case with objects and LOBs...

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, September 18, 2003 8:29 PM

> The error was first discovered when we tried to move a partition. (
> alter

table archive_wave_i move partition SEP1103 tablespace CHANARCH_NLC_2003_09_DATA). The table was renamed to OLD_archive_wave_i once it was determined that no new varray data was accessible. My theory is that this is logical corruption of the data dictionary, but I have not worked out the particulars.
>
> Selecting via an index or FTS does not matter. What type of error do
> you

believe koxsisz1 to be?
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> ian_at_SLAC.Stanford.edu
>
>
>
> -----Original Message-----
> Sent: Thursday, September 18, 2003 4:13 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
>
> If even Oracle hasn't seen this error, then probably we can't help
> much

here either. Just a wild guess, try to move this partition to another location and select from it then (although koxsisz1 isn't a data layer error as far as I understand). Try to read using index if available, then using full hint etc..
>
> Tanel.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, September 18, 2003 3:04 AM
>
>
> > 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).
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tanel Poder
> INET: tanel.poder.003_at_mail.ee
>
> 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).
> --
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).
-- 
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).