Re: 4GB file limit in Oracle8 ???

From: Mustapha Nuvvercrap <hashman_at_bigpond.net.au>
Date: Thu, 15 Feb 2001 10:24:11 GMT
Message-ID: <f7Oi6.26044$o85.126350@news-server.bigpond.net.au>

Oh well, remembered that wrongly then, how about a bug per chance ???

            Doc ID:  Note:67421.1
            Subject:  ALERT: Do NOT use files >= 4Gb on NT in Oracle8
            Type:  ALERT
            Status:  PUBLISHED
     Content Type:  TEXT/PLAIN
            Creation Date:  22-DEC-1998
            Last Revision Date:  23-APR-2000
            Language:  USAENG

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.

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

A fix is now available in 8.0.4.3.5 and 8.0.5.1.0a

References

  2Gb or not 2Gb - File limits in Oracle	[NOTE:62427.1]
  Base bug reporting this problem		[BUG:711563]

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:96g8ej$s1d$1_at_soap.pipex.net...

> There is no 4GB file size limit in NT when using NTFS this I know for sure
> because we once had a 5.5GB temp tablespace datafile (oops). If the disk
> were a FAT partition is could only reach 4GB. I cannot speak for Oracle
> 8.0.5 (not running it), but 8i certainly will handle files larger than 4
> gig. So I suspect that the autoextend clause is  autoextend on maxsize

4GB.

> This can be checked for in OEM (or DBA studio or whatever graphical tool
> comes with 8.0.5).
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Mustapha Nuvvercrap" <hashman_at_bigpond.net.au> wrote in message
> news:2_Li6.25675$o85.123745_at_news-server.bigpond.net.au...
> > I believe the limit may lie within NT  and the cluster size of the NTFS
> > partition. I believe the 4GB limit may be imposed by the 512 byte

cluster

> > size of the partition.
> >
> > At least AFAICR...
> >
> > "Jaroslaw Lubczynski" <eljot_at_elkomtech.com.pl> wrote in message
> > news:96g10l$ps7$1_at_news.tpi.pl...
> > > Is there any 4GB file limit in Oracle8 ???
> > >
> > > Situation:
> > > Oracle 8.0.5 Workgroup Edition on Win NT 4.0 (Intel, RAID V

controller),
> > > Service Pack 6, NTFS. Tablespace USER consists of one large 4 GB file with
> > > Auto Extend flag enabled. When tablespace was fulfilled and INSERTs > > > coutinued, Oracle would try to extend file over 4GB size I suppose. Then
> > > database crashed. error ORA-00600 occured (internal error) and datafile
of
> > > tablespace USER was truncated to about 8 MB in size. Of course I had to
> > > restore database from tape.When I restarted application which made several

> > > INSERTs into database, Oracle crashed again when tablespace USER got
> > > fulfilled.
> > >
> > > Now the tablespace USER has been divided into several smaller ( <=

2GB )

> > > files and works perfectly, so questions are:
> > > 1. Is there a 4 GB datbase file limit in Oracle8 (or Win NT?????), or
> > > 2. Is any known bug in Oracle8 which can cause crash after trying to
> > > increase  database file over 4GB?
> > >
> > > I have found no word about it in my CD docs.
> > >
> > > I hope there is no reachable limit in tablespace size (I will be

forced
to

> > > add 3rd 2GB datafile to largest tablespace very soon).
> > >
> > > thanks for any information,
> > >
> > > Jaroslaw ELJOT Lubczynski
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>

Received on Thu Feb 15 2001 - 04:24:11 CST