Re: ORA-00600 URGENT

From: David Sisk <davesisk_at_ipass.net>
Date: Tue, 13 Jul 1999 22:39:41 -0400
Message-ID: <eDSi3.157$w3.286@news.ipass.net>

Hello:

Is the datafile larger than 4Gb? If so, below is the bug report from Oracle. You will have to get Oracle Support to fix this for you, if it's even possible in your case.

Good luck!

Article-ID:         <Note:67421.1>
Circulation:        PUBLISHED (EXTERNAL)
Folder:             platform.NT
Topic:              1.  Alerts
Platform:           NT  NT Generic issue
Subject:            ALERT: Do NOT use files >= 4Gb on NT in Oracle8
Author:             RPOWELL.UK/DRUSSELL.UK
Creation-Date:      22-DEC-1998 10:51:28
Modified-Date:      05-MAR-1999 19:05:44
Document-Type:      ALERT
Impact:             HIGH
Skill-Level:        CASUAL
Component:          RDBMS  Server 08.00 - 08.01
Content-Type:       TEXT/PLAIN
Attachments:        NONE

Bug:711563 Problems with Datafiles >= 4Gb on Oracle8 on NT Platforms

Versions Affected

The problems described here can affect all releases of Oracle8 on NT only. A fix is now available in 8.0.4.3.5 and 8.0.5.1.0a

Platforms Affected

The problems affect Oracle8 releases on all NT platforms (ie: Both Intel and Alpha NT platforms are affected)

Description

Releases of Oracle8 on NT platforms can exhibit serious problems when using files larger than 4Gb in size. Some versions of Oracle8 will not allow such files to be created whilst others can give problems if a file is resized beyond 4Gb.

Likelihood of Occurrence

It is highly likely that problems will be encountered if an attempt is made to create or resize a datafile to larger than 4Gb. One should also avoid migrating an Oracle7 database to Oracle8 if it contains files which are 4Gb or larger.
NOTE: Resizing includes AUTOEXTEND of a file beyond 4Gb.

Possible Symptoms

There are several possible symptoms from this problem including:

ORA-1200: database file n failed verification check ORA-1110: data file n: '......' ORA-1200: actual file size of n is smaller than correct size
ORA-1237 cannot extend datafile %s ORA-1110 data file n: '......'
If a file is resized above 4Gb it is possible for the file to be truncated to a much smaller size such that data could be lost from the file.

Workaround

  The only safe workaround at present is to ensure that no file is created   which is >= 4Gb in size. This is best achieved by making sure all datafiles
  are 4095Mb or less and additionally setting MAXSIZE to 4095Mb for files   that are configured to AUTOEXTEND.
  NOTE: Attempting to create a file of EXACTLY 4Gb can cause problems.

It is advisable to read the article below which describes potential issues using files of 2Gb or larger in size as this may influence the maximum datafile size you choose to use.

Patches

No patches are currently available.
A fix is expected to be available with Oracle 8.0.5.2. This alert will be if any additional patches are made available.

References

  2Gb or not 2Gb - File limits in Oracle        <Note:62427.1>
  Base bug reporting this problem               <Bug:711563>

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

Fredrick Rustum wrote in message ...

>After resizing a datfile on NT Oracle 8.0.4.0 I a fileheader seams to have
>disappeared, all scans towards tables in that file are impossible. I'm
>afraid a restore on the file would make the database corrupt since the
>filesize has been changed since last backup.
>Should I or should I not restore the datafile? The tablespace consists of

>files and is 60 Gb!!
>It is also impossible to rename or desc those tables, probably drop them
>too.
>
>Please help,
>Fredrick
>
>
>
>Trying to read beyon End of file
>Error
>Errors in file C:\ORANT\rdbms80\trace\ORA00094.TRC:
>ORA-00600: internal error code, arguments: [2846], [4], [91522], [1],
>[52992], [], [], []
>
>
>
>
>
>

Received on Tue Jul 13 1999 - 21:39:41 CDT