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.  

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: mzito_at_gridapp.com
Cell: 646-220-3551
Phone: 212-358-8211 x 359 

-----Original Message-----
Wells
Sent: Wednesday, June 04, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L



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----- 
Sent: Wednesday, June 04, 2003 2:05 PM 
To: Multiple recipients of list ORACLE-L 


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.

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" <ORACLE-L_at_fatcity.com> 
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 
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? 


> 

> 

> Peeved at Oracle... AGAIN, 

> Steve Orr 

> -- 

> Please see the official ORACLE-L FAQ: http://www.orafaq.net 

> -- 

> Author: Orr, Steve 

>   INET: sorr_at_rightnow.com 

> 

> 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: Jan Pruner 
  INET: jan_at_pruner.cz 

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: Orr, Steve 
  INET: sorr_at_rightnow.com 

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: Mercadante, Thomas F 
  INET: NDATFM_at_labor.state.ny.us 

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: Orr, Steve 
  INET: sorr_at_rightnow.com 

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


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.





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Matthew Zito
  INET: mzito_at_gridapp.com

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