Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

From: Matthew Zito <>
Date: Thu, 05 Jun 2003 05:53:39 -0700
Message-ID: <>

8i on linux, while functional, definitely had/has a whole boatload of problems.  9i is much better all around, and I'm not surprised that Oracle support is pushing it heavily.  We're getting a lot of customers that are trying to get off 8i because of problems like this one, plus that 8.1.7 is the terminal release for 8i and they're tired of getting flack from Oracle support. 
<FONT face=Arial color=#0000ff

<FONT face=Arial color=#0000ff

<FONT face=Arial color=#0000ff

--Matthew ZitoGridApp SystemsEmail:
[EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359

style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">   

  face=Tahoma size=2>-----Original Message-----From: [EMAIL PROTECTED]   [mailto:[EMAIL PROTECTED] On Behalf Of April WellsSent:   Wednesday, June 04, 2003 2:30 PMTo: Multiple recipients of list   ORACLE-LSubject: RE: ??? Linux/Oracle 8.1.7 2GB file size limit   ???
  Upgrading was number 2?
  NO way!?!  I am (genuinely) surprised that it wasn't   number 1 suggestion...
  April Wells Oracle DBA/Oracle Apps
  DBA Corporate Systems Amarillo
  You will recognize your own path when you come upon it,   because you will suddenly have all the energy and imagination you will ever   need.
  ~ Jerry Gillies ~
  -----Original Message----- From: Orr,   Steve [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, June 04, 2003 2:05 PM <FONT   size=2>To: Multiple recipients of list ORACLE-L <FONT   size=2>Subject: RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???   

  Well... datafiles > 2GB seem to work okay but since Oracle   is being a weenie about supporting them altogether I'm choosing not to. One of   the first hoops OWS had me jump thru in the wild goose chase was to manually   extend datafiles via maxsize without using "unlimited." Eventually the only   workarounds suggested by Oracle were: 1) turn off autoextend and manually add   datafiles; 2) upgrade to 9i.
  -----Original Message----- Sent:
  Wednesday, June 04, 2003 12:10 PM To: Multiple   recipients of list ORACLE-L
  Steve - are you saying that there is a workaround by   increasing the size of the file manually to something   larger than 4G?
  Tom Mercadante Oracle Certified
  -----Original Message----- Sent:
  Wednesday, June 04, 2003 1:25 PM To: Multiple   recipients of list ORACLE-L
  See my note: "There is no such O/S file size limit."   

  We have datafiles > 2GB which work just fine. The problem   is with autoextending datafiles that extend from   <2GB to >2GB. It's not a Linux limitation but a   limitation imposed by Oracle's implementation on Linux. <FONT   size=2>Oracle 9i on Linux doesn't have this problem. And my peeve is that it   took OWS 4 days to "discover" this "limit."   

  Still peeved,  :-) Steve   

  -----Original Message----- Sent:
  Wednesday, June 04, 2003 10:55 AM To: Multiple   recipients of list ORACLE-L
  I think it is the limitation of Linux, not Oracle.   Use LVM and don't worry about file size limit. :-)

  JP ----- Original Message -----
  To: "Multiple recipients of list ORACLE-L"   <[EMAIL PROTECTED]> Sent: Wednesday, June 04,   2003 5:40 PM
  > I've just been informed that there is a 2GB datafile size   limit with Oracle 8.1.7 on Linux... PERIOD. This   despite the fact that we've had files in excess of   this for some time and they work just fine. The problem occurs   when the autoextend "feature" reaches the 2GB threshhold. Of   course, Oracle didn't tell me this until after about 4   days of back and forth testing for them. (There is no   such O/S file size limit.) I've reviewed the Linux <FONT   size=2>release notes, the Linux install guide, the Linux admin guide and   the contents of $ORACLE_HOME/relnotes and I don't find   any such limitation in the documentation. Did I miss   it? Can anyone find any such published limitation in   the docs? Is this a secret? > <FONT
  size=2>> > Peeved at Oracle... AGAIN,   > Steve Orr > --
  > Please see the official ORACLE-L FAQ: <A   href="" target=_blank>   > -- > Author: Orr,
  > > Fat City Network
  Services    -- 858-538-5051 <A href=""   target=_blank> > San   Diego, California        -- Mailing list   and web hosting services >

  > To REMOVE yourself from this mailing list, send an   E-Mail message > to: [EMAIL PROTECTED] (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). >

      The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.  

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. Received on Thu Jun 05 2003 - 07:53:39 CDT

Original text of this message