| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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 ???
Oracle
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
size=2>
<FONT face=Arial color=#0000ff
size=2>Thanks,
<FONT face=Arial color=#0000ff
size=2>Matt
--Matthew ZitoGridApp SystemsEmail:
[EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<FONT
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
Texas
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
Professional
-----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="http://www.orafaq.net" target=_blank>http://www.orafaq.net
> -- > Author: Orr,
Steve > INET: [EMAIL PROTECTED]
> > Fat City Network
Services -- 858-538-5051 <A href="http://www.fatcity.com"
target=_blank>http://www.fatcity.com > San
Diego, California -- Mailing list
and web hosting services >
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
 |
 |