Re: linux
I would probably go to the http://www.realtimelinuxfoundation.org and see what's there. The next thing would be to start looking into other RT Unix systems and when all of the needed information is compiled, I would post an article with the solution on this list. On 2004.01.19 09:54, [EMAIL PROTECTED] wrote: Hello list, sorry for the off topic question , but I thought that a question on unix would not ruffle too many feathers. what all changes will you make to convert linux to a Real time operating system ? Can anyone please help me with an answer and explanation ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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).
RE: linux
Having never done it, I'll just refer you here: http://www.tldp.org/HOWTO/RTLinux-HOWTO.html Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Monday, January 19, 2004 9:54 AM To: Multiple recipients of list ORACLE-L Hello list, sorry for the off topic question , but I thought that a question on unix would not ruffle too many feathers. what all changes will you make to convert linux to a Real time operating system ? Can anyone please help me with an answer and explanation ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] 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: [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).
Re: Linux
On Sat, Dec 20, 2003 at 02:34:26PM -0800, Paul Drake wrote: --- Seema Singh [EMAIL PROTECTED] wrote: Hi Does anyone know good Linux administration book? Can you guyes suggest any good linux user group? thx -Seema Matt Welsh's Running Linux is now out in 4th Edition. Just make sure that you find a recent edition, as there are still plenty of RedHat 6.0 books out there on the shelves. Linux System Administration Handbook Prentice Hall PTR; ISBN: 0130084662 cheers, Mihalis. -- 14:00:56 up 6 days, 22:33, 2 users, load average: 0.03, 0.03, 0.00 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mihalis I. Tsoukalos INET: [EMAIL PROTECTED] 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: [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).
Re: Linux
--- Seema Singh [EMAIL PROTECTED] wrote: Hi Does anyone know good Linux administration book? Can you guyes suggest any good linux user group? thx -Seema Matt Welsh's Running Linux is now out in 4th Edition. Just make sure that you find a recent edition, as there are still plenty of RedHat 6.0 books out there on the shelves. where might you be located? If you're in the New York Metropolitan area, LinuxWorldExpo will be held Jan 21-24 at Javitts. They typically have a .org pavillion where the LUGs have booths. The NYLUG website has a good list of area Linux User Groups - http://www.nylug.org I haven't been attending NYLUG for awhile, but its one of my new year's resolutions to start doing so. They used to have some pretty good speakers, such as lead developers for Apache, Eric Raymond. Beers afterwards at Typhoon Brewery. hth. Pd __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] 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: [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).
Re: Linux install for Oracle - Details reqd
On 12/16/2003 03:29:25 PM, quriyat wrote: Hello all I am planning to install Linux; the idea is to install Oracle RAC. I have two questions: Q1. Which Linux is best suited for it(RH?/SUSE?/Mandrake?). I know i can get Oracle download from OTN but it should be installable on the particular flavor of Linux. Also, i would like to know which Linux will have comparitively lesser efforts to go thru the install and get me started at the earliest. RH AS 3.0 Q2. Has anyone tried Oracle RAC on any of the above. If so what are the experience/problems encountered. return (sub { www.puschitz.com; }) TIA Quriyat DBA ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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).
Re: Linux VPN and routing HOWTO
Title: OT: Linux VPN and routing HOWTO Is IP forwarding enabled? cat /proc/sys/net/ipv4/ip_forward ? If its a zero, set it to a 1 (echo 1 /proc/sys/net/ipv4/ip_forward) Beyond that, use a packet sniffer like tcpdump to see what is appearing on the wire on both interfaces. Thanks, Matt - Original Message - From: Jack van Zanen To: Multiple recipients of list ORACLE-L Sent: Friday, September 26, 2003 9:44 AM Subject: OT: Linux VPN and routing HOWTO Hi I'm Sorry to put this way OT subject here, but you guys usually come up with the answer anyway. I'm trying to setup my linux at home so that I can VPN into it. Now I can connect already but can't ping or connect any of the machines in my network. I huess I have to setup some sort of routing now, but I can't find any a-z documentation on this topic. I used the PPtP VPN sever that came with United linux Once again sorry. Jack
RE: LINUX instance startup problem
What version of Red Hat? --Walt -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: LINUX instance startup problem Hi, I'm having problem during startup of instance on LINUX.I have oracle 8.1.7 on red hat. When I start instance it try to come upto this below lines background_dump_dest = user_dump_dest = core_dump_dest = after that I'm getting following message SVRMGR connect internal; Connected. SVRMGR startup; ORA-03113: end-of-file on communication channel SVRMGR connect internal; Password: ORA-03113: end-of-file on communication channel SVRMGR When I see semaphore and shared memory.Its locked.I'm unable to get into server manager without killing all shared mem process. Let me know how to fix this problem pl thx -seema _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: [EMAIL PROTECTED] 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: [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).
Re: LINUX instance startup problem
Most modern versions of linux have shared memory/semaphore parameters set high enough that oracle can start (unless, of course, you have an exceptionally large SGA). (Note 187397.1) If this is a fresh install (in particular a download from OTN) of 8.1.7, locate the glibc-2.1.3-stubs.tar.gz patch from Oracle. (http://otn.oracle.com/software/products/oracle8i/htdocs/linuxsoft.html). There is also a good document entitled: Oracle RDBMS OTN Downloads: Files, Sizes and Directions (Note 209555.1) -- James Seema Singh wrote: Hi, I'm having problem during startup of instance on LINUX.I have oracle 8.1.7 on red hat. When I start instance it try to come upto this below lines background_dump_dest = user_dump_dest = core_dump_dest = after that I'm getting following message SVRMGR connect internal; Connected. SVRMGR startup; ORA-03113: end-of-file on communication channel SVRMGR connect internal; Password: ORA-03113: end-of-file on communication channel SVRMGR When I see semaphore and shared memory.Its locked.I'm unable to get into server manager without killing all shared mem process. Let me know how to fix this problem pl thx -seema _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James J. Morrow INET: [EMAIL PROTECTED] 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: [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).
Re: linux and windows2000 memory allocation
Hi! Linux doesn't split memory that way (although some memory is still allocated to kernel of course) Max SGA I have allocated on 32bit server w. 8GB mem running RHAS 2.1 is 2.4G. The max is 2.7GB I believe, but you have to relocate SGA for that. Check metalink note 211424.1. In addition, you can use extended buffer cache, but for that you need PAE (page address extension) capable hardware and need to create memory file systems etc.. Metalink note above covers the topic. Tanel. - Original Message - My question is: How does Red Hat Advanced Server handle memory? If you have a 4G Dell server, how much of that memory can be made available to the Oracle software? Regards, Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] 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: [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).
Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
DO NOT USE AUTOEXTEND on these datafiles. There is a bug when datafile autoextend into 2GB or 4GB (I do not remember exactly now) on NT. We had a database down permanently because of this. We do not work with any X OS here so I am talking about NT only. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 09, 2003 7:34 PM FWIW, we use 2048m here. --Walt (who feels obligated to make some posts since Steve's off today) Weaver Bozeman, Montana -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Sunday, June 08, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ??? Just curious how you arrived at the 1900 meg number. Why not use 2000m? Oracle defines gigabytes in binary, not decimal as drive mfg's do, so 2000m would be fine. Not a criticism, just wondering. Jared On Sunday 08 June 2003 09:29, Yechiel Adar wrote: We have been hit by a bug in autoextend that corrupted a database (8.1.6) on NT. It seems that the bug was exported to Linux as well. We now use all datafiles with autoextend up to 1900 MB. We also define a second datafile with 200MB initial and autoextend to 1900 MB. Whenever the last datafile starts to grow we define a new one with 200MB etc. Seems to work so far. Yechiel Adar Mehish - 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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
FWIW, we use 2048m here. --Walt (who feels obligated to make some posts since Steve's off today) Weaver Bozeman, Montana -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Sunday, June 08, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ??? Just curious how you arrived at the 1900 meg number. Why not use 2000m? Oracle defines gigabytes in binary, not decimal as drive mfg's do, so 2000m would be fine. Not a criticism, just wondering. Jared On Sunday 08 June 2003 09:29, Yechiel Adar wrote: We have been hit by a bug in autoextend that corrupted a database (8.1.6) on NT. It seems that the bug was exported to Linux as well. We now use all datafiles with autoextend up to 1900 MB. We also define a second datafile with 200MB initial and autoextend to 1900 MB. Whenever the last datafile starts to grow we define a new one with 200MB etc. Seems to work so far. Yechiel Adar Mehish - 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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: [EMAIL PROTECTED] 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: [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).
Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
We have been hit by a bug in autoextend that corrupted a database (8.1.6) on NT. It seems that the bug was exported to Linux as well. We now use all datafiles with autoextend up to 1900 MB. We also define a second datafile with 200MB initial and autoextend to 1900 MB. Whenever the last datafile starts to grow we define a new one with 200MB etc. Seems to work so far. Yechiel Adar Mehish - 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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] 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: [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).
Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Just curious how you arrived at the 1900 meg number. Why not use 2000m? Oracle defines gigabytes in binary, not decimal as drive mfg's do, so 2000m would be fine. Not a criticism, just wondering. Jared On Sunday 08 June 2003 09:29, Yechiel Adar wrote: We have been hit by a bug in autoextend that corrupted a database (8.1.6) on NT. It seems that the bug was exported to Linux as well. We now use all datafiles with autoextend up to 1900 MB. We also define a second datafile with 200MB initial and autoextend to 1900 MB. Whenever the last datafile starts to grow we define a new one with 200MB etc. Seems to work so far. Yechiel Adar Mehish - 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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [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).
Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
The critical boundary on 32-bit filesystems was 2048M. The problem was (and still is) in the lseek function, which accepts int off_t lseek(int fildes, off_t offset, int whence); In order to move through the files larger then 2GB (1 bit is for the sign), OS needs routines named lseek64 and tell64 which accept 64 bit values. That doesn't necessarily mean that the OS itself is 64-bit. That can be determined by finding sizeof(char *). If the returned number is 8, you are on a 64 system. There are some operating systems which have eliminated the sign and extended that boundary to 4GB, but that causes other problems, most notably with NFS because the other systems, which adhere to the POSIX specification don't know what to do with a 4GB file. One of such OSes was Dynix, may it rest in peace. On 2003.06.08 12:59 Jared Still wrote: Just curious how you arrived at the 1900 meg number. Why not use 2000m? Oracle defines gigabytes in binary, not decimal as drive mfg's do, so 2000m would be fine. Not a criticism, just wondering. Jared On Sunday 08 June 2003 09:29, Yechiel Adar wrote: We have been hit by a bug in autoextend that corrupted a database (8.1.6) on NT. It seems that the bug was exported to Linux as well. We now use all datafiles with autoextend up to 1900 MB. We also define a second datafile with 200MB initial and autoextend to 1900 MB. Whenever the last datafile starts to grow we define a new one with 200MB etc. Seems to work so far. Yechiel Adar Mehish - 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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
That could be quite a LARGE update.. ;) -Original Message- Carmichael Sent: 05 June 2003 01:49 To: Multiple recipients of list ORACLE-L geez, back to the very very first presentation Marlene Theriault and I did together, about version 6, called All the Things THEY Didn't Tell You you mean I hafta update it AGAIN? :) --- Orr, Steve [EMAIL PROTECTED] wrote: And thanks for the note recommendation Dennis... There's too many of these bullets flying around. Need a short list called: Things you should know that Oracle doesn't tell you straight out. Of course there's the bug list but who has time for that and can remember it all? Sigh... Steve -Original Message- Sent: Wednesday, June 04, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Steve Personally I am VERY glad you mentioned this today. Since I run 64-bit Unix, I didn't think this applied to me, but after reading the note, I ran their formula and found a file on one of my databases that was very close to the limit. Plenty happy to dodge that bullet. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 4:15 PM To: Multiple recipients of list ORACLE-L We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a couple of years and let other customers QA this Oracle feature until they get it right. Steve -Original Message- Sent: Wednesday, June 04, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Ahem . . . according to Note 112011.1, these problems can affect all platforms except OS/390 which does NOT support datafile resizing (fiendishly clever those mainframe types). It looks like 8.1.7.4 and above is not affected. I would highly recommend that all Oracle DBAs take a look at this note. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 3:00 PM To: Multiple recipients of list ORACLE-L It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir dij` vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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:
Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
I'd say file size limit/autoextend feature has been Oracle's dirty little secret for quite a while. For a very long period of time there was similar 4GB 'magic' barrier on Windows, that was allegedly fixed. Workaround for the problem was to create datafile 1 MB larger than the 'magic' number, and ether resize it using this trick or add another datafile to tablespace when the time comes (whenever MagicNumber or N x MagicNumber is close). Despite rumours (of having fixed autoextend feature on Windows) I recently witnessed failed imports into Oracle 9.2.0.1.0 caused by too small tablespaces that just wouldn't autoextend. Interestingly, import died beautifully cuz silently in the middle of job without _any_ errors, traces etc. Just gone. There is also interesting myth here at the place where I work that systems tablespace autoextend feature ain't to be trusted as it is known to have caused intermittent data dictionary corruptions while code recompilation takes place under space crunch conditions... On slightly cynical side note: autoextend that doesn't - maps nicely into job safety ;-) Branimir -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED] Sent: June 4, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Subject: ??? Linux/Oracle 8.1.7 2GB file size limit ??? 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: Branimir Petrovic INET: [EMAIL PROTECTED] 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: [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).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
NICE! Thanks. -Original Message- Sent: Wednesday, June 04, 2003 11:57 AM To: Multiple recipients of list ORACLE-L It's a combo problem between oracle and linux. When Linux first implemented largefile support, many of the traditional linux apps were not aware of the concept of 2GB files and were using 32-bit offsets for file pointer storage. So, as a workaround, 32- and 64-bit versions of the various file operation calls were made to specify whether a 32-bit or 64-bit offset should be returned, as well as specifying a flag O_LARGEFILE that could be sent to the traditional open() that indicated the application was largefile aware. When an application is compiled, you can specify to the compiler that you want it to be 64-bit aware and the 64-bit versions of things like open and seek will be used, or the code can use the O_LARGEFILE flag in open(). The end result of this is that while linux is 2GB aware, oracle 8.1.7 is not quite entirely. I bet that the chunk of code that opens a datafile for traditional access in 8.1.7 is 64-bit aware, while the code that grows the file is not. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Pruner Sent: Wednesday, June 04, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ??? 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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
It's a combo problem between oracle and linux. When Linux first implemented largefile support, many of the traditional linux apps were not aware of the concept of 2GB files and were using 32-bit offsets for file pointer storage. So, as a workaround, 32- and 64-bit versions of the various file operation calls were made to specify whether a 32-bit or 64-bit offset should be returned, as well as specifying a flag O_LARGEFILE that could be sent to the traditional open() that indicated the application was largefile aware. When an application is compiled, you can specify to the compiler that you want it to be 64-bit aware and the 64-bit versions of things like open and seek will be used, or the code can use the O_LARGEFILE flag in open(). The end result of this is that while linux is 2GB aware, oracle 8.1.7 is not quite entirely. I bet that the chunk of code that opens a datafile for traditional access in 8.1.7 is 64-bit aware, while the code that grows the file is not. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Pruner Sent: Wednesday, June 04, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ??? 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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] 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: [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).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Thanks Branimir for confirming my right to be peeved. :-) I never liked the autoextend feature but we use it because: 1) We have this nifty end user driven feature where they can clone their data via a nice web GUI interface. (This is for web site upgrades scheduled by the end user.) 2) We don't want the user to decide how much disk storage to allocate so we let the datafiles autoextend. 3) As the DBA/DUHveloper (Python/CGI) who bequeathed certain DBA functions to the GUI interface, I depended on autoextend working and was too lazy to algorithm-ize the number of datafiles based on current storage needs. 4) Upon self-chastizement I'm undoing the autoextend feature and am now going to dba_segments to develop a capacity planning algorithm. Developing DBA automation tools driven via events and end user input is a fun and wild ride on the margin of DBA fiefdom. Commiserating with my DBA buddy Walt, Help... we're losing control and we hate giving up 'power.' :-) Staring out the window at the mountains in Big Sky Country, Steve -Original Message- Sent: Wednesday, June 04, 2003 11:25 AM To: Multiple recipients of list ORACLE-L I'd say file size limit/autoextend feature has been Oracle's dirty little secret for quite a while. For a very long period of time there was similar 4GB 'magic' barrier on Windows, that was allegedly fixed. Workaround for the problem was to create datafile 1 MB larger than the 'magic' number, and ether resize it using this trick or add another datafile to tablespace when the time comes (whenever MagicNumber or N x MagicNumber is close). Despite rumours (of having fixed autoextend feature on Windows) I recently witnessed failed imports into Oracle 9.2.0.1.0 caused by too small tablespaces that just wouldn't autoextend. Interestingly, import died beautifully cuz silently in the middle of job without _any_ errors, traces etc. Just gone. There is also interesting myth here at the place where I work that systems tablespace autoextend feature ain't to be trusted as it is known to have caused intermittent data dictionary corruptions while code recompilation takes place under space crunch conditions... On slightly cynical side note: autoextend that doesn't - maps nicely into job safety ;-) Branimir -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED] Sent: June 4, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Subject: ??? Linux/Oracle 8.1.7 2GB file size limit ??? 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: Branimir Petrovic INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To
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. 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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET:
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Steve - Is there a Metalink note on this? What would a person search for? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 12: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
nice. either way, you're screwed into doing more work than you had planned. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Yeah, now I call it the outta-extend feature. :-) -Original Message- Sent: Wednesday, June 04, 2003 12:28 PM To: '[EMAIL PROTECTED]' Cc: Orr, Steve nice. either way, you're screwed into doing more work than you had planned. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Nevermind, a search on 2gb yielded Note 112011.1, which seems to explain it all. Oh well, one more item for my to do list. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Steve - Is there a Metalink note on this? What would a person search for? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 12: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Title: 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 To: Multiple recipients of list ORACLE-L 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. 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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
As per Branimer's previous post, try searching under dirty little secrets. :-) -Original Message- Sent: Wednesday, June 04, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Steve - Is there a Metalink note on this? What would a person search for? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 12: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Title: Message 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 ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359 -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 To: Multiple recipients of list ORACLE-L 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. 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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in th
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Ahem . . . according to Note 112011.1, these problems can affect all platforms except OS/390 which does NOT support datafile resizing (fiendishly clever those mainframe types). It looks like 8.1.7.4 and above is not affected. I would highly recommend that all Oracle DBAs take a look at this note. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 3:00 PM To: Multiple recipients of list ORACLE-L It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a couple of years and let other customers QA this Oracle feature until they get it right. Steve -Original Message- Sent: Wednesday, June 04, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Ahem . . . according to Note 112011.1, these problems can affect all platforms except OS/390 which does NOT support datafile resizing (fiendishly clever those mainframe types). It looks like 8.1.7.4 and above is not affected. I would highly recommend that all Oracle DBAs take a look at this note. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 3:00 PM To: Multiple recipients of list ORACLE-L It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Dennis, Thanks a lot, the diamond of the day from the list. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, June 04, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Ahem . . . according to Note 112011.1, these problems can affect all platforms except OS/390 which does NOT support datafile resizing (fiendishly clever those mainframe types). It looks like 8.1.7.4 and above is not affected. I would highly recommend that all Oracle DBAs take a look at this note. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 3:00 PM To: Multiple recipients of list ORACLE-L It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Steve Personally I am VERY glad you mentioned this today. Since I run 64-bit Unix, I didn't think this applied to me, but after reading the note, I ran their formula and found a file on one of my databases that was very close to the limit. Plenty happy to dodge that bullet. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 4:15 PM To: Multiple recipients of list ORACLE-L We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a couple of years and let other customers QA this Oracle feature until they get it right. Steve -Original Message- Sent: Wednesday, June 04, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Ahem . . . according to Note 112011.1, these problems can affect all platforms except OS/390 which does NOT support datafile resizing (fiendishly clever those mainframe types). It looks like 8.1.7.4 and above is not affected. I would highly recommend that all Oracle DBAs take a look at this note. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 3:00 PM To: Multiple recipients of list ORACLE-L It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ:
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
And thanks for the note recommendation Dennis... There's too many of these bullets flying around. Need a short list called: Things you should know that Oracle doesn't tell you straight out. Of course there's the bug list but who has time for that and can remember it all? Sigh... Steve -Original Message- Sent: Wednesday, June 04, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Steve Personally I am VERY glad you mentioned this today. Since I run 64-bit Unix, I didn't think this applied to me, but after reading the note, I ran their formula and found a file on one of my databases that was very close to the limit. Plenty happy to dodge that bullet. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 4:15 PM To: Multiple recipients of list ORACLE-L We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a couple of years and let other customers QA this Oracle feature until they get it right. Steve -Original Message- Sent: Wednesday, June 04, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Ahem . . . according to Note 112011.1, these problems can affect all platforms except OS/390 which does NOT support datafile resizing (fiendishly clever those mainframe types). It looks like 8.1.7.4 and above is not affected. I would highly recommend that all Oracle DBAs take a look at this note. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 3:00 PM To: Multiple recipients of list ORACLE-L It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
geez, back to the very very first presentation Marlene Theriault and I did together, about version 6, called All the Things THEY Didn't Tell You you mean I hafta update it AGAIN? :) --- Orr, Steve [EMAIL PROTECTED] wrote: And thanks for the note recommendation Dennis... There's too many of these bullets flying around. Need a short list called: Things you should know that Oracle doesn't tell you straight out. Of course there's the bug list but who has time for that and can remember it all? Sigh... Steve -Original Message- Sent: Wednesday, June 04, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Steve Personally I am VERY glad you mentioned this today. Since I run 64-bit Unix, I didn't think this applied to me, but after reading the note, I ran their formula and found a file on one of my databases that was very close to the limit. Plenty happy to dodge that bullet. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 4:15 PM To: Multiple recipients of list ORACLE-L We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a couple of years and let other customers QA this Oracle feature until they get it right. Steve -Original Message- Sent: Wednesday, June 04, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Ahem . . . according to Note 112011.1, these problems can affect all platforms except OS/390 which does NOT support datafile resizing (fiendishly clever those mainframe types). It looks like 8.1.7.4 and above is not affected. I would highly recommend that all Oracle DBAs take a look at this note. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 3:00 PM To: Multiple recipients of list ORACLE-L It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Woohoo!! Us OS/390ers have it made ! actually in 9i they started allowing files to autoextend but I am not sure how they do it... On OS/390 you still cannot shrink a datafile. - Babette -Original Message- WILLIAMS Sent: Wednesday, June 04, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Ahem . . . according to Note 112011.1, these problems can affect all platforms except OS/390 which does NOT support datafile resizing (fiendishly clever those mainframe types). It looks like 8.1.7.4 and above is not affected. I would highly recommend that all Oracle DBAs take a look at this note. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 3:00 PM To: Multiple recipients of list ORACLE-L It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3: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 [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 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a
Re: linux intel support matrix
On Thu, Apr 03, 2003 at 06:33:53PM -0800, Ray Stell wrote: I went to look at the matrix today and found it dramatically changed. I found only 9.2.0 and Redhat AS. All the other free linux versions are gone as well as all 8i versions. Do you find the same, maybe the webmeister is messing we me? Stupid, fat Hobbitses! My bad. I chose Linux Intel Itanium thinking they had changed it to mean Intel + Itanium. They changed it from Linux Intel to Linux IA32. The free stuff is still there. Nice Hobbitses! === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [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).
RE: linux intel support matrix
What you see is correct. 9.2.0 is only supported on PAY versions of linux. 8.1.7 is still supported on various free versions. (funny how open only includes We just went through hoops trying to find a combination of free Linux and Oracle that we could run OEM OMS and names on... We settled on 7.1, 8.1.7.4.0 and OEM 2.2.0...after some fun installing, patching and relinking all seems well... Brad O. -Original Message- Sent: Thursday, April 03, 2003 8:34 PM To: Multiple recipients of list ORACLE-L I went to look at the matrix today and found it dramatically changed. I found only 9.2.0 and Redhat AS. All the other free linux versions are gone as well as all 8i versions. Do you find the same, maybe the webmeister is messing we me? Stupid, fat Hobbitses! === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] 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: [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).
RE: linux intel support matrix
I seriously advise against the Intel Itanic machines. If you need 64 bits you can either wait for the Clawhammer or switch to something else that already supports 64 bits. One little HP superdome would be a nice decoration in my living room. Intel Itanic has hit an iceberg. -Original Message- Sent: Friday, April 04, 2003 8:29 AM To: Multiple recipients of list ORACLE-L On Thu, Apr 03, 2003 at 06:33:53PM -0800, Ray Stell wrote: I went to look at the matrix today and found it dramatically changed. I found only 9.2.0 and Redhat AS. All the other free linux versions are gone as well as all 8i versions. Do you find the same, maybe the webmeister is messing we me? Stupid, fat Hobbitses! My bad. I chose Linux Intel Itanium thinking they had changed it to mean Intel + Itanium. They changed it from Linux Intel to Linux IA32. The free stuff is still there. Nice Hobbitses! === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [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).
Re: linux intel support matrix
[EMAIL PROTECTED] wrote: I seriously advise against the Intel Itanic machines. If you need 64 bits you can either wait for the Clawhammer or switch to something else that already supports 64 bits. One little HP superdome would be a nice decoration in my living room. Intel Itanic has hit an iceberg. now don't hold back, let us know how you really feel.;-) me i'd settle for a nice alpha. i could even deal with VMS.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] Om mani padme hum. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bill thater INET: [EMAIL PROTECTED] 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: [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).
Re: linux intel support matrix
Bill, Welcome back!!! I haven't read you in a long time. Hope all is well. Ron [EMAIL PROTECTED] 04/04/03 12:29PM [EMAIL PROTECTED] wrote: I seriously advise against the Intel Itanic machines. If you need 64 bits you can either wait for the Clawhammer or switch to something else that already supports 64 bits. One little HP superdome would be a nice decoration in my living room. Intel Itanic has hit an iceberg. now don't hold back, let us know how you really feel.;-) me i'd settle for a nice alpha. i could even deal with VMS.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] Om mani padme hum. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bill thater INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [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).
Re: linux intel support matrix
[EMAIL PROTECTED] wrote: Bill, Welcome back!!! I haven't read you in a long time. Hope all is well. Ron just got a 3 month contract after being out of work since the end of june. guess that's the end of my afternoon naps, and my afternoon beer, for a while.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] Om mani padme hum. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bill thater INET: [EMAIL PROTECTED] 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: [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).
RE: linux intel support matrix
They make you work in the afternoon --Walt Weaver Bozeman, Montana -Original Message- From: bill thater [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: linux intel support matrix [EMAIL PROTECTED] wrote: Bill, Welcome back!!! I haven't read you in a long time. Hope all is well. Ron just got a 3 month contract after being out of work since the end of june. guess that's the end of my afternoon naps, and my afternoon beer, for a while.;-) -- -- Bill Shrek Thater ORACLE DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: [EMAIL PROTECTED] 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: [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).
RE: linux intel support matrix
From: Weaver, Walt [EMAIL PROTECTED] They make you work in the afternoon --Walt Weaver Bozeman, Montana You mean sometimes you aren't at work? Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry INET: [EMAIL PROTECTED] 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: [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).
RE: Linux and Oracle Cluster File System
Jos, Yes, you are right that if you use OCFS then you can just have one mount point and create all data files under it, because OCFS is a file system. It makes it a lot easier to manage space and you can use commands like: cp, mv, rm etc which you can't do to a raw partition. Backup on OCFS is also easier than using raw. Richard Ji -Original Message-From: Jos [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 8:49 AMTo: Multiple recipients of list ORACLE-LSubject: OT: Linux and Oracle Cluster File SystemList,I am a newbie on Linux and Clustering technology, I need to setup a RAC system and have been reading somedocumentation on how to do it. I am a bit confuse about the difference between setting the disk up with Linux raw partition and Oracle cluster file system, I hope someone on the list can give me some hints oruseful reference for reading. The document said for Lunix raw partition I need to setup a partition pertablespace, this is quit a lot considering for Oracle Apps there is about 200 tablespaces. I am wonderingif I am using Oracle Clustering file system (OCFS), can I define one big partition for OCFS and mount it on /u01 and create all the files under this one mount point or the one raw partition per tablespace rule stillapplies.Jos Yahoo! Greetings- Send your seasons greetings online this year!
RE: Linux and Oracle Cluster File System
Thanks for the clarification, a lot more to read. Richard Ji [EMAIL PROTECTED] wrote: Jos, Yes, you are right that if you use OCFS then you can just have one mount point and create all data files under it, because OCFS is a file system. It makes it a lot easier to manage space and you can use commands like: cp, mv, rm etc which you can't do to a raw partition. Backup on OCFS is also easier than using raw. Richard Ji -Original Message-From: Jos [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 8:49 AMTo: Multiple recipients of list ORACLE-LSubject: OT: Linux and Oracle Cluster File SystemList,I am a newbie on Linux and Clustering technology, I need to setup a RAC system and have been reading somedocumentation on how to do it. I am a bit confuse about the difference between setting the disk up with Linux raw partition and Oracle cluster file system, I hope someone on the list can give me some hints oruseful reference for reading. The document said for Lunix raw partition I need to setup a partition pertablespace, this is quit a lot considering for Oracle Apps there is about 200 tablespaces. I am wonderingif I am using Oracle Clustering file system (OCFS), can I define one big partition for OCFS and mount it! on /u01 and create all the files under this one mount point or the one raw partition per tablespace rule stillapplies.Jos Yahoo! Greetings- Send your seasons greetings online this year! Yahoo! Greetings - Send your seasons greetings online this year!
Re: Linux
Run it on Linux like you would run it on Windows. You do need some Unix skills for any OS level work though. Otherwise, Oracle is the same (mostly) on both platforms. Download Oracle for Linux., It's free for evaluation, education and development use from http://www.oracle.com -- Lyndon Tiu Quoting Turner, Christine [EMAIL PROTECTED]: Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] 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: [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).
RE: linux
It run beautifully. i've been running oracle(not so much production but up thru testing/QA) on linux platform since 8.0. I love it. You know that the datafiles format is not compatible, so the only choice to migrate to linux is exp/imp. It runs on linux like it runs on any other *nix(except for solaris, now where do they keep that oratab file, oh yea /var/opt/oracle, instead of /etc) :) Any questions don't hesitate to ask. Joe Turner, Christine wrote: Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [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).
RE: Linux
We have Oracle 8.1.7 and 9.2.0 running on Red Hat Linux 7.2 - and love it. It is not a production box though. We are still in test mode. Jim Hawkins Oracle Database Administrator St. Louis, MO Turner, Christine [EMAIL PROTECTED] wrote: Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] 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: [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). -- Jim Hawkins Oracle© / MS SQL*Server© Database Administration St. Louis, MO 63167 __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] 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: [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).
Re: Linux
See http://otn.oracle.com/tech/linux/content.html It runs very well. Moving a database from NT to Linux is as easy as export/import. Other methods exist too. --- Turner, Christine [EMAIL PROTECTED] wrote: Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] 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: [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).
Re: Linux
Define Linux. Check the support matrix. I liked running on Redhat, but Oracle seemed to drop support for the free versions after 7.1 or so. Anyway, you may want support and so you may want to purchase some of the enterprise releases of linux, such as from RedHat or SuSE that are included in the support matrix. For an inexpensive test environment I moved to Mandrake 9.0 and Oracle 9.2.0 which went together like a glove. It does require .5GB or ram, however and is not supported. I don't care about that for this particular effort. Free at last! On Wed, Oct 23, 2002 at 08:43:51AM -0800, [EMAIL PROTECTED] wrote: Christine, Runs fine, but you'll have to use the export/import conversion route. OH, and get use to a different OS. Dick Goulet Reply Separator Author: Turner; Christine [EMAIL PROTECTED] Date: 10/23/2002 8:14 AM Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [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).
RE: linux
What distribution/version of Linux would you recommend (RedHat, Suse, etc.)? Thanks Phil Wilson ([EMAIL PROTECTED]) DBA, Operations Group SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w) 506.447.0334(c) -Original Message- Sent: Wednesday, October 23, 2002 1:50 PM To: Multiple recipients of list ORACLE-L It run beautifully. i've been running oracle(not so much production but up thru testing/QA) on linux platform since 8.0. I love it. You know that the datafiles format is not compatible, so the only choice to migrate to linux is exp/imp. It runs on linux like it runs on any other *nix(except for solaris, now where do they keep that oratab file, oh yea /var/opt/oracle, instead of /etc) :) Any questions don't hesitate to ask. Joe Turner, Christine wrote: Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Phil Wilson (DBA) INET: [EMAIL PROTECTED] 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: [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).
RE: Linux
Kewlness! Thanks everyone for your input. Totally off the dba subject...does anyone know of any C++ developers that have information regarding converting to UNIX. My developers are going stir crazy trying to find any steps to follow when converting C++ applications for Linux. If not, that's cool, but thought I would ask. Thanks, C- -Original Message- Sent: Wednesday, October 23, 2002 10:15 AM To: Multiple recipients of list ORACLE-L See http://otn.oracle.com/tech/linux/content.html It runs very well. Moving a database from NT to Linux is as easy as export/import. Other methods exist too. --- Turner, Christine [EMAIL PROTECTED] wrote: Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] 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: [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).
Re: linux
Well technically, only the advanced version of RH( are supported, i think most if not all(some please clarify) of Suse are supported. go here: http://www.redhat.com/oracle_cert/ for the scoop of versions of oracle on which versions of RH are certified. Joe Phil Wilson (DBA) wrote: What distribution/version of Linux would you recommend (RedHat, Suse, etc.)? Thanks Phil Wilson ([EMAIL PROTECTED]) DBA, Operations Group SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w) 506.447.0334(c) -Original Message- Sent: Wednesday, October 23, 2002 1:50 PM To: Multiple recipients of list ORACLE-L It run beautifully. i've been running oracle(not so much production but up thru testing/QA) on linux platform since 8.0. I love it. You know that the datafiles format is not compatible, so the only choice to migrate to linux is exp/imp. It runs on linux like it runs on any other *nix(except for solaris, now where do they keep that oratab file, oh yea /var/opt/oracle, instead of /etc) :) Any questions don't hesitate to ask. Joe Turner, Christine wrote: Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [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).
Re: Linux
Christine, I found it easier ( because I had the OS disks) to load the PC with RedHat6.2 and then install Oracle 8.1.7. That eliminated the glib and java problems encountered with the RedHat 7.0 and 7.1 versions. Then I upgraded the OS to 7.0 and finally 7.1 after I found things ran perfectly. There are white papers available on the OTN site for installing Oracle on RedHat versions. I would suggest you read them and get the required patched on hand if you decide to use RedHat. The pc is a 850 MH cpu with 512 M memory and a total of 200 GB disk across 4 IDE disks with a SCSI 4mm Tape drive and SCSI Cdrom. Compaired to the currrent production DELL 6500 server with 1- 450 Mh cpu and 1 G mem with 72 GIG SCSI Raid 5 disk, The Linux box is about 3 times faster than the Dell box running Novell 5 OS and twice as fast as an Alpha class server with 600 Mh cpu and 1 G Mem. and 72 GIG Raid 5 disks. I use the Linux box as a test and play familiarity box to get use to the new options available for Oracle and to gain confidence for my OCP tests. ROn ROR mª¿ªm [EMAIL PROTECTED] 10/23/02 12:14PM Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [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).
RE: Linux
We have experience numerous problems with high transaction load databases. The i/o drivers and memory drivers have proven to be unstable. The largest problem seems to occur with the memory drivers. Try running a linux database with and SGA over 1GB. We have been able to duplicate these experiences on Redhat 7.1 - 7.3, running Oracle 8.1.7.3 EE. We have better success running the 2.2 kernel. We plan on testing Redhat AS 2.1.Otherwise we may stop recommending linux boxes as oracle database servers. A particularly bad experience was running a 200+ GB data mart on a linux box. If you are running a large production db on oracle/linux, I would really like to hear about the configuration. Thanks, -Daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Harron INET: [EMAIL PROTECTED] 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: [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).
RE: linux
I'll be able to tell you more about 9.2.0.2 on RH 8.0 after this weekend. I don't expect any trouble. -Original Message- From: Joe Testa [mailto:jtesta;dmc-it.com] Sent: Wednesday, October 23, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: linux Well technically, only the advanced version of RH( are supported, i think most if not all(some please clarify) of Suse are supported. go here: http://www.redhat.com/oracle_cert/ for the scoop of versions of oracle on which versions of RH are certified. Joe Phil Wilson (DBA) wrote: What distribution/version of Linux would you recommend (RedHat, Suse, etc.)? Thanks Phil Wilson ([EMAIL PROTECTED]) DBA, Operations Group SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w) 506.447.0334(c) -Original Message- Sent: Wednesday, October 23, 2002 1:50 PM To: Multiple recipients of list ORACLE-L It run beautifully. i've been running oracle(not so much production but up thru testing/QA) on linux platform since 8.0. I love it. You know that the datafiles format is not compatible, so the only choice to migrate to linux is exp/imp. It runs on linux like it runs on any other *nix(except for solaris, now where do they keep that oratab file, oh yea /var/opt/oracle, instead of /etc) :) Any questions don't hesitate to ask. Joe Turner, Christine wrote: Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [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).
RE: Linux
There are tons of IDE software like Anjuta, CodeWarrior, CodeCrusader, Grasp and alike which can ease up transition. The following URL is, however, worth looking if you have to deal with hard core Micros*t guys: http://www.bristol.com/windu/index.html -Original Message- From: Turner, Christine [mailto:christine.turner;ips-sendero.com] Sent: Wednesday, October 23, 2002 2:11 PM To: Multiple recipients of list ORACLE-L Subject: RE: Linux Kewlness! Thanks everyone for your input. Totally off the dba subject...does anyone know of any C++ developers that have information regarding converting to UNIX. My developers are going stir crazy trying to find any steps to follow when converting C++ applications for Linux. If not, that's cool, but thought I would ask. Thanks, C- -Original Message- Sent: Wednesday, October 23, 2002 10:15 AM To: Multiple recipients of list ORACLE-L See http://otn.oracle.com/tech/linux/content.html It runs very well. Moving a database from NT to Linux is as easy as export/import. Other methods exist too. --- Turner, Christine [EMAIL PROTECTED] wrote: Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [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).
Re: linux and Oracle Apps jinit
Hi Ron, Has anyone found a way to use linux as a client to Oracle Applications? The self service stuff runs just fine but the Oracle Forms requires that damnable jinit. This is the only problem left before I can give MS the big Heave Ho. I am also in the process of trying to find if I can get Linux to be a client for Oracle Apps and the only lead I had was that there was once a Solaris version that can be still made to work and I am trying to find out if I can get that. Other than that, I have heard Windows is the only platform that jinit runs on :-( Regards, Madhavan http://www.dpapps.com -- Madhavan Amruthur DecisionPoint Applications -- http://fastmail.fm/ - Consolidate POP email and Hotmail in one place -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhavan Amruthur INET: [EMAIL PROTECTED] 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: [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).
Re: Re: LINUX and Oracle Corp.
ltiu£¬ hi, i have the same experience with Jread, Dell does outperform sun, i have Dell 2550 with 2 1.4G P3CPU/2G memory, with Sun 220 2Gmemory/2CPU, Dell is better than sun with regard to oracle responce time and os cpu idle time. My application is cpu entensive and memory intensive, not much Disk IO. While the Dell server is only about 4000$, Sun costs about 20K$. 2002-08-02 19:38:00 You wrote: RH 2.7 with Oracle 8 and 9 wow!!! where did you get these beasts to work together? How come Dell Intels outperform Suns. I don't get it? ltiu On Friday 02 August 2002 20:03, you wrote: Mladen and all, I have a Dell 2500 with 2 1GHZ Pentium III's, 2 Gig of RAM and 3 30 Gig RAID1 disk on SCSI. It performs rather well, and will run circles around a lightly loaded 2 CPU Sun 220R we use in production. This is my own personal little DBA playground, running RH 2.7, Oracle 8.1.7 and 9.2. :) Jared On Thursday 01 August 2002 09:03, Gogala, Mladen wrote: Yes and no. If you put in a decent new Adaptec (AHA) SCSI III adapter, it will be capable of working with a 133MHZ or better motherboard and IO will be fast, even faster then on an expensive SUN 4xx servers. Of course, we must be aware that people are putting sound, webcams, game ports and TV cards into their PCs ant that is never a good idea for a database server. Personally, I think that a big SMP PC with a few gigs of RAM and decent SCSI or FC/AL disk farm can easily service 2 or 3 hundred users. One would still need approximately $10,000 to assemble a piece like that, but before that, the prices used to have more zeroes. Of course, there is that little added cost of Oracle RDBMS which will be 2 times as expensive as the HW it's running on and that is really what people don't like. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Subject: RE: LINUX and Oracle Corp. -- Cabansay, Yoyong [EMAIL PROTECTED] on 08/01/02 02:19:10 -0800 regarding the above topic but on a different note, anyone here on the list that is on an Oracle/HP-UX OS platform for backend and 9iAS/Linux on the middle tier? problems encountered? gotchas? stories to tell. we are looking at this configuration right now for our Oracle Apps 11i. Main issue w/ most linux boxes is hardware: PC's stink at I/O due to the Intel motherboard design. The net result tends to be a transfer bottleneck. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chaos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: LINUX and Oracle Corp.
On Friday 02 August 2002 20:38, ltiu wrote: RH 2.7 with Oracle 8 and 9 wow!!! where did you get these beasts to work together? 8.1.7 required a bit of work... 9iR1 never did work 9iR2 was fairly simple The Dell is a fast machine with some nice ultra wide SCSI ports. The Sun is a low end server. Dell doesn't have anything that will keep up with Sun's more offerings. Jared How come Dell Intels outperform Suns. I don't get it? ltiu On Friday 02 August 2002 20:03, you wrote: Mladen and all, I have a Dell 2500 with 2 1GHZ Pentium III's, 2 Gig of RAM and 3 30 Gig RAID1 disk on SCSI. It performs rather well, and will run circles around a lightly loaded 2 CPU Sun 220R we use in production. This is my own personal little DBA playground, running RH 2.7, Oracle 8.1.7 and 9.2. :) Jared On Thursday 01 August 2002 09:03, Gogala, Mladen wrote: Yes and no. If you put in a decent new Adaptec (AHA) SCSI III adapter, it will be capable of working with a 133MHZ or better motherboard and IO will be fast, even faster then on an expensive SUN 4xx servers. Of course, we must be aware that people are putting sound, webcams, game ports and TV cards into their PCs ant that is never a good idea for a database server. Personally, I think that a big SMP PC with a few gigs of RAM and decent SCSI or FC/AL disk farm can easily service 2 or 3 hundred users. One would still need approximately $10,000 to assemble a piece like that, but before that, the prices used to have more zeroes. Of course, there is that little added cost of Oracle RDBMS which will be 2 times as expensive as the HW it's running on and that is really what people don't like. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Subject: RE: LINUX and Oracle Corp. -- Cabansay, Yoyong [EMAIL PROTECTED] on 08/01/02 02:19:10 -0800 regarding the above topic but on a different note, anyone here on the list that is on an Oracle/HP-UX OS platform for backend and 9iAS/Linux on the middle tier? problems encountered? gotchas? stories to tell. we are looking at this configuration right now for our Oracle Apps 11i. Main issue w/ most linux boxes is hardware: PC's stink at I/O due to the Intel motherboard design. The net result tends to be a transfer bottleneck. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: LINUX and Oracle Corp.
OK. I should try Linux with Oracle then. Cheap(er) alternative. Cheapest would be Linux with Postgresql/MySQL but functionality is not there yet. Price-wise, is the performace of Dell better than Sun? Dollar/performance ? How much (cost) is the Dell and how much is the Sun? ltiu On Saturday 03 August 2002 10:08, Jared Still wrote: On Friday 02 August 2002 20:38, ltiu wrote: RH 2.7 with Oracle 8 and 9 wow!!! where did you get these beasts to work together? 8.1.7 required a bit of work... 9iR1 never did work 9iR2 was fairly simple The Dell is a fast machine with some nice ultra wide SCSI ports. The Sun is a low end server. Dell doesn't have anything that will keep up with Sun's more offerings. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Re: LINUX and Oracle Corp.
Dunno what you got for 4k, mine was 12k. Still significantly less than the Sun, which is why I asked for it. Jared On Saturday 03 August 2002 01:23, chaos wrote: ltiu£¬ hi, i have the same experience with Jread, Dell does outperform sun, i have Dell 2550 with 2 1.4G P3CPU/2G memory, with Sun 220 2Gmemory/2CPU, Dell is better than sun with regard to oracle responce time and os cpu idle time. My application is cpu entensive and memory intensive, not much Disk IO. While the Dell server is only about 4000$, Sun costs about 20K$. 2002-08-02 19:38:00 You wrote: RH 2.7 with Oracle 8 and 9 wow!!! where did you get these beasts to work together? How come Dell Intels outperform Suns. I don't get it? ltiu On Friday 02 August 2002 20:03, you wrote: Mladen and all, I have a Dell 2500 with 2 1GHZ Pentium III's, 2 Gig of RAM and 3 30 Gig RAID1 disk on SCSI. It performs rather well, and will run circles around a lightly loaded 2 CPU Sun 220R we use in production. This is my own personal little DBA playground, running RH 2.7, Oracle 8.1.7 and 9.2. :) Jared On Thursday 01 August 2002 09:03, Gogala, Mladen wrote: Yes and no. If you put in a decent new Adaptec (AHA) SCSI III adapter, it will be capable of working with a 133MHZ or better motherboard and IO will be fast, even faster then on an expensive SUN 4xx servers. Of course, we must be aware that people are putting sound, webcams, game ports and TV cards into their PCs ant that is never a good idea for a database server. Personally, I think that a big SMP PC with a few gigs of RAM and decent SCSI or FC/AL disk farm can easily service 2 or 3 hundred users. One would still need approximately $10,000 to assemble a piece like that, but before that, the prices used to have more zeroes. Of course, there is that little added cost of Oracle RDBMS which will be 2 times as expensive as the HW it's running on and that is really what people don't like. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Subject: RE: LINUX and Oracle Corp. -- Cabansay, Yoyong [EMAIL PROTECTED] on 08/01/02 02:19:10 -0800 regarding the above topic but on a different note, anyone here on the list that is on an Oracle/HP-UX OS platform for backend and 9iAS/Linux on the middle tier? problems encountered? gotchas? stories to tell. we are looking at this configuration right now for our Oracle Apps 11i. Main issue w/ most linux boxes is hardware: PC's stink at I/O due to the Intel motherboard design. The net result tends to be a transfer bottleneck. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
Re: LINUX and Oracle Corp.
Mladen and all, I have a Dell 2500 with 2 1GHZ Pentium III's, 2 Gig of RAM and 3 30 Gig RAID1 disk on SCSI. It performs rather well, and will run circles around a lightly loaded 2 CPU Sun 220R we use in production. This is my own personal little DBA playground, running RH 2.7, Oracle 8.1.7 and 9.2. :) Jared On Thursday 01 August 2002 09:03, Gogala, Mladen wrote: Yes and no. If you put in a decent new Adaptec (AHA) SCSI III adapter, it will be capable of working with a 133MHZ or better motherboard and IO will be fast, even faster then on an expensive SUN 4xx servers. Of course, we must be aware that people are putting sound, webcams, game ports and TV cards into their PCs ant that is never a good idea for a database server. Personally, I think that a big SMP PC with a few gigs of RAM and decent SCSI or FC/AL disk farm can easily service 2 or 3 hundred users. One would still need approximately $10,000 to assemble a piece like that, but before that, the prices used to have more zeroes. Of course, there is that little added cost of Oracle RDBMS which will be 2 times as expensive as the HW it's running on and that is really what people don't like. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Subject: RE: LINUX and Oracle Corp. -- Cabansay, Yoyong [EMAIL PROTECTED] on 08/01/02 02:19:10 -0800 regarding the above topic but on a different note, anyone here on the list that is on an Oracle/HP-UX OS platform for backend and 9iAS/Linux on the middle tier? problems encountered? gotchas? stories to tell. we are looking at this configuration right now for our Oracle Apps 11i. Main issue w/ most linux boxes is hardware: PC's stink at I/O due to the Intel motherboard design. The net result tends to be a transfer bottleneck. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: LINUX and Oracle Corp.
RH 2.7 with Oracle 8 and 9 wow!!! where did you get these beasts to work together? How come Dell Intels outperform Suns. I don't get it? ltiu On Friday 02 August 2002 20:03, you wrote: Mladen and all, I have a Dell 2500 with 2 1GHZ Pentium III's, 2 Gig of RAM and 3 30 Gig RAID1 disk on SCSI. It performs rather well, and will run circles around a lightly loaded 2 CPU Sun 220R we use in production. This is my own personal little DBA playground, running RH 2.7, Oracle 8.1.7 and 9.2. :) Jared On Thursday 01 August 2002 09:03, Gogala, Mladen wrote: Yes and no. If you put in a decent new Adaptec (AHA) SCSI III adapter, it will be capable of working with a 133MHZ or better motherboard and IO will be fast, even faster then on an expensive SUN 4xx servers. Of course, we must be aware that people are putting sound, webcams, game ports and TV cards into their PCs ant that is never a good idea for a database server. Personally, I think that a big SMP PC with a few gigs of RAM and decent SCSI or FC/AL disk farm can easily service 2 or 3 hundred users. One would still need approximately $10,000 to assemble a piece like that, but before that, the prices used to have more zeroes. Of course, there is that little added cost of Oracle RDBMS which will be 2 times as expensive as the HW it's running on and that is really what people don't like. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Subject: RE: LINUX and Oracle Corp. -- Cabansay, Yoyong [EMAIL PROTECTED] on 08/01/02 02:19:10 -0800 regarding the above topic but on a different note, anyone here on the list that is on an Oracle/HP-UX OS platform for backend and 9iAS/Linux on the middle tier? problems encountered? gotchas? stories to tell. we are looking at this configuration right now for our Oracle Apps 11i. Main issue w/ most linux boxes is hardware: PC's stink at I/O due to the Intel motherboard design. The net result tends to be a transfer bottleneck. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: LINUX and Oracle Corp.
regarding the above topic but on a different note, anyone here on the list that is on an Oracle/HP-UX OS platform for backend and 9iAS/Linux on the middle tier? problems encountered? gotchas? stories to tell. we are looking at this configuration right now for our Oracle Apps 11i. thanks in advance Yoyong Cabansay email: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 31, 2002 10:54 PM To: Multiple recipients of list ORACLE-L Good luck. When I worked for Oracle in 1998/99 they consolidated all their e-mail servers at Corp. in Calif. What a mess. Something was wrong with the hard drives that continued to fail and we would go for days without e-mail. The primary communication media at Oracle is e-mail. This lasted about 2 months when they decided to replace all the HD's with a different model. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 7:38 AM How comprehensive is the switch at Oracle? I found this reference on the 'net: Oracle is even taking its own advice. By the end of this year the company expects it will have moved its 45,000 employees to a strictly Linux-based e-mail database system. http://siliconvalley.internet.com/news/article.php/1276851 This is an older article dating back to June 2002. I remember Larry Ellison declaring earlier that he was going to switch his corporation's Oracle Applications to LINUX as well. I haven't seen any comments / updates on that move on the 'net since. Are they moving their whole corporate infrastructure to LINUX? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cabansay, Yoyong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: LINUX and Oracle Corp.
-- Cabansay, Yoyong [EMAIL PROTECTED] on 08/01/02 02:19:10 -0800 regarding the above topic but on a different note, anyone here on the list that is on an Oracle/HP-UX OS platform for backend and 9iAS/Linux on the middle tier? problems encountered? gotchas? stories to tell. we are looking at this configuration right now for our Oracle Apps 11i. Main issue w/ most linux boxes is hardware: PC's stink at I/O due to the Intel motherboard design. The net result tends to be a transfer bottleneck. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: LINUX and Oracle Corp.
Yes and no. If you put in a decent new Adaptec (AHA) SCSI III adapter, it will be capable of working with a 133MHZ or better motherboard and IO will be fast, even faster then on an expensive SUN 4xx servers. Of course, we must be aware that people are putting sound, webcams, game ports and TV cards into their PCs ant that is never a good idea for a database server. Personally, I think that a big SMP PC with a few gigs of RAM and decent SCSI or FC/AL disk farm can easily service 2 or 3 hundred users. One would still need approximately $10,000 to assemble a piece like that, but before that, the prices used to have more zeroes. Of course, there is that little added cost of Oracle RDBMS which will be 2 times as expensive as the HW it's running on and that is really what people don't like. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Subject: RE: LINUX and Oracle Corp. -- Cabansay, Yoyong [EMAIL PROTECTED] on 08/01/02 02:19:10 -0800 regarding the above topic but on a different note, anyone here on the list that is on an Oracle/HP-UX OS platform for backend and 9iAS/Linux on the middle tier? problems encountered? gotchas? stories to tell. we are looking at this configuration right now for our Oracle Apps 11i. Main issue w/ most linux boxes is hardware: PC's stink at I/O due to the Intel motherboard design. The net result tends to be a transfer bottleneck. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: LINUX and Oracle Corp.
Good luck. When I worked for Oracle in 1998/99 they consolidated all their e-mail servers at Corp. in Calif. What a mess. Something was wrong with the hard drives that continued to fail and we would go for days without e-mail. The primary communication media at Oracle is e-mail. This lasted about 2 months when they decided to replace all the HD's with a different model. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 7:38 AM How comprehensive is the switch at Oracle? I found this reference on the 'net: Oracle is even taking its own advice. By the end of this year the company expects it will have moved its 45,000 employees to a strictly Linux-based e-mail database system. http://siliconvalley.internet.com/news/article.php/1276851 This is an older article dating back to June 2002. I remember Larry Ellison declaring earlier that he was going to switch his corporation's Oracle Applications to LINUX as well. I haven't seen any comments / updates on that move on the 'net since. Are they moving their whole corporate infrastructure to LINUX? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux SuSe question?
The download takes forever because you have to download each and every single file...unlike RH You can buy it for 30 bucks. I think the enterprise version is like 90 dollars. -Original Message- Sent: Wednesday, July 17, 2002 5:09 PM To: Multiple recipients of list ORACLE-L Is the downloadable version of SuSe Linux good to run Oracle or should I buy it from the store? This is for my own research. Thanks Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: linux vs any other os
Although not very scientific, this one is always fun to watch. http://srom.zgp.org/ Good Luck, Ed -Original Message- Sent: Monday, June 03, 2002 7:23 PM To: Multiple recipients of list ORACLE-L Hi All, Anyone have any sites where they are doing performance compares of linux vs solaris or any other OS. TiA, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: linux vs any other os
Ite misa est, Linux is the best! -Original Message- From: Sherman, Edward [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: linux vs any other os Although not very scientific, this one is always fun to watch. http://srom.zgp.org/ Good Luck, Ed -Original Message- Sent: Monday, June 03, 2002 7:23 PM To: Multiple recipients of list ORACLE-L Hi All, Anyone have any sites where they are doing performance compares of linux vs solaris or any other OS. TiA, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: RE: linux vs any other os
I thought they were calling it Windux... -Original Message- Sent: Tuesday, June 04, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Interesting, Windows sucks harder that Linux rules!! BTW: anyone here on the Lindows Beta test?? Dick Goulet Reply Separator Author: Gogala; Mladen [EMAIL PROTECTED] Date: 6/4/2002 10:09 AM Ite misa est, Linux is the best! -Original Message- From: Sherman, Edward [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: linux vs any other os Although not very scientific, this one is always fun to watch. http://srom.zgp.org/ Good Luck, Ed -Original Message- Sent: Monday, June 03, 2002 7:23 PM To: Multiple recipients of list ORACLE-L Hi All, Anyone have any sites where they are doing performance compares of linux vs solaris or any other OS. TiA, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kkennedy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux for Big(ish) Databases
Bill, In general terms, I would say that it is certainly suitable. That answer is based upon the information you provide below. The real answer could only be ascertained by evaluating other requirements: A) Availability B) Scalability C) 'Cost' of each user - what do the transactions look like Don't fall into the trap of treating the machine as a PC - many implementations of Linux/Oracle apply the cost-reduced approach all the way across the system. You save money on the server and OS, but you should still make sure your I/O requirements are well catered for. From a CPU standpoint, you are probably more than OK. A quad Xeon machine has more power than you need in all likelihood (again, APPLICATION DEPENDENT - a single user can suck down 4 Xeons if they want to...). Memory, no problem - 4GB should be more than enough, and Linux is pretty well proven up to this level. The big downsides are thus: A) PCI bus bandwidth. Unless you go for a system with multiple PCI buses (they are available, but I've not personally run Linux on one of these), you are limited to a maximum theoretical bandwidth of width*clock: 33MHz * 32-bit= ~132MB/s, 66MHz*64-bit= 528MB/s. B) Crash Dumps. If you hit an OS problem, who do you go to, and what do you give them? C) Memory bandwidth. RDRAM or at least DDR memory solutions should be used where possible. This is where the P4 is actually worth considering. Forget all the 'extensions' stuff, though - Oracle is pretty much a pure INTEGER compute load. The thing you get that's worth having with the P4 is 400MHz front side bus - Memory Bandwidth! I would recommend, in the complete absence of any real workload knowledge ( ;-) ) to go for a 2-way P4 system based upon the ServerWorks GC-HE chipset. Something like the Dell PowerEdge 4600. This will give you a) memory bandwidth more balanced against the CPU power, b) lots of PCI bandwidth. Hope that is of use. Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bill Buchan Sent: 04 March 2002 10:18 To: Multiple recipients of list ORACLE-L Subject: Linux for Big(ish) Databases We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Linux command to display total disk capacity
- Original Message - Does someone know what command can be used to display total capacity of disk drive? I can use command df -k but it breaks partitions apart so I have to add them up. I need command just display a total. for an IDE drive do: cat /proc/ide/xxx/capacity ...where xxx is the disk drive u're interested in (hda, hdb,...). The size returned is in 512b blocks for SCSI it's not that easy hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux command to display total disk capacity
Disk capacity is relevant to partition. Your df -k could show 10 partitions, this could be 10 1 drive, or 10. You might find what you need in fdisk, but use it with caution if you aren't a unix admin. -Original Message- Sent: Tuesday, March 05, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Does someone know what command can be used to display total capacity of disk drive? I can use command df -k but it breaks partitions apart so I have to add them up. I need command just display a total. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Linux command to display total disk capacity
pipe df -k to awk and sum the column you want On Tue, 5 Mar 2002, Nguyen, David M wrote: Does someone know what command can be used to display total capacity of disk drive? I can use command df -k but it breaks partitions apart so I have to add them up. I need command just display a total. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Linux for Big(ish) Databases
We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? No reason why not. Might also want to consider linux on a Sparc or Alpha. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux for Big(ish) Databases
The problem with Linux on Sparc or Alpha is that Oracle doesn't have binaries for them. I've requested Alpha binaries, but haven't had any response, despite the 1-2 business days response. sigh GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, March 04, 2002 9:53 AM To: Multiple recipients of list ORACLE-L We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? No reason why not. Might also want to consider linux on a Sparc or Alpha. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux for Big(ish) Databases
May be they'll release the source code and distribute it under the GPL license? -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 12:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: Linux for Big(ish) Databases The problem with Linux on Sparc or Alpha is that Oracle doesn't have binaries for them. I've requested Alpha binaries, but haven't had any response, despite the 1-2 business days response. sigh GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, March 04, 2002 9:53 AM To: Multiple recipients of list ORACLE-L We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? No reason why not. Might also want to consider linux on a Sparc or Alpha. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux for Big(ish) Databases
-- Jesse, Rich [EMAIL PROTECTED] on 03/04/02 09:03:28 -0800 The problem with Linux on Sparc or Alpha is that Oracle doesn't have binaries for them. I've requested Alpha binaries, but haven't had any response, despite the 1-2 business days response. sigh Remember: They're Oracle, you're not. Be glad they take their precious time to not answer your questions! The main problem with Intel boxes is a narrow I/O bus and latency issues with the chipsets. The VIA set tends to be faster so far as I've seen. Combined with good SCSI boards and LVM striping you can get decent throughput, but it'll never match something like a V-box or 6500 for full-bore speed. The real alpha motherboards (not NT compatable toys) use wide I/O channels to keep the chip fed. If you're considering linux look carefully at clusters. They can be an immense help dealing with large databases. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Linux Cluster
On Friday 22 February 2002 16:03, Henrik Ekenberg wrote: Who is your configuration ? Two nodes running in VMWare on an HP laptop 2- Which Linux version ? RH 7.1 + logical volume manager 3- Which Oracle version ? 9.0.1.2.0 4- Is is fun ? That depends. -- Bjørn Engsig, Miracle A/S http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux Cluster
I'm also running it on two Vmware machines running Linux on my laptop. I'm currently working on a 'real' cluster, using a mixture of SMP linux boxes on a shared SCSI array. Two nodes, no problem. Three nodes, big problem. I believe it still to be electrical on the SCSI bus, so watch this space. If you have a choice, use FC, preferably switched! Oracle version: 9.0.1.2 Is it fun? I always say - If you really want to learn about how Oracle instances work, run OPS. I don't say that anymore, because they changed the name to RAC. But that's the only change to the saying. I love it though, it's loads of fun, but very much in a masochistic way. In the particular case of Linux, if anyone worked on any big multi-node OPS configurations about ten years ago, you have a good idea of what it's like now on Linux Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Henrik Ekenberg [EMAIL PROTECTED] Sent: 22 February 2002 15:03 To: Multiple recipients of list ORACLE-L Subject: Linux Cluster Hi from the Swow storm from Sweden, We wants to try to run Oracle on a Linux Cluster. Is someone using Oracle on a Linux Cluster ? Who is your configuration ? 1- (DELL,HP,Compaq,..) 2- Which Linux version ? 3- Which Oracle version ? 4- Is is fun ? Best Regards, HEnrik -- -- - There's fun in being serious. -- Wynton Marsalis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Linux Cluster
I wish that I had some of that 10 year ago OPS experience ;-) Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 22, 2002 5:53 PM I'm also running it on two Vmware machines running Linux on my laptop. I'm currently working on a 'real' cluster, using a mixture of SMP linux boxes on a shared SCSI array. Two nodes, no problem. Three nodes, big problem. I believe it still to be electrical on the SCSI bus, so watch this space. If you have a choice, use FC, preferably switched! Oracle version: 9.0.1.2 Is it fun? I always say - If you really want to learn about how Oracle instances work, run OPS. I don't say that anymore, because they changed the name to RAC. But that's the only change to the saying. I love it though, it's loads of fun, but very much in a masochistic way. In the particular case of Linux, if anyone worked on any big multi-node OPS configurations about ten years ago, you have a good idea of what it's like now on Linux Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Henrik Ekenberg [EMAIL PROTECTED] Sent: 22 February 2002 15:03 To: Multiple recipients of list ORACLE-L Subject: Linux Cluster Hi from the Swow storm from Sweden, We wants to try to run Oracle on a Linux Cluster. Is someone using Oracle on a Linux Cluster ? Who is your configuration ? 1- (DELL,HP,Compaq,..) 2- Which Linux version ? 3- Which Oracle version ? 4- Is is fun ? Best Regards, HEnrik -- -- - There's fun in being serious. -- Wynton Marsalis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Linux taking over at Oracle
I am afraid we have seen too many 'flavour-of-the-month' fads already. I fear that Larry is about as clueless as I am about the immediate future of IT and Oracle's 'strategy' has more or less been a succession of more or less well inspired tactical moves. I have known Oracle when distribution of everything was all the rage. Concerning Jonathan's reference to the email servers, I remember having read some years ago in a plane in a non-IT paper (FT or Wall Street Journal, can't remember) a longish interview of Larry where he was bragging about his being an engineer, his conviction that it was doable and how he had imposed his will (big effort, when you know how slavish some may be at Oracle :-)), especially against Oracle Singapore, and, if I remember well, Oracle Canada. A few months later, electricians working in Redwood Shores to make electricity supplies redundant or something similar goofed (not the exclusivity of DBAs) and as a result THE WHOLE OF ORACLE, WORLDWIDE, HAD NO E-MAIL FOR TWO DAYS. Note that when it's deep night in California some people at Oracle do not seem to understand that in Asia everybody is working, and in Europe too. It must have been an enormous roar of laughter in Singapore and in Canada. The problem with centralised systems is that there is another company, which I do not understand why it is feared so much by Oracle if their systems really are as slow as the Oracle ads pretend, which has been doing it already for about 40 years, and it doing it rather well. Concerning the hardware, same story. Historically Oracle was first developed on PDPs, then moved to VAXes. In the mid 1980s development was supposed to be done on Sun boxes, however, strangely, the VMS port still was the first to be available. There has been a time when we heard a lot about N-Cube (remember?), of which Larry was a big shareholder, then about Sequent (ditto). Then it looked like honeymoon with Sun, till the climate deteriorated amongst accusations of unfairness (for what I have heard, Oracle was a bigger customer of Sun than the reverse). Oracle fell for HP. Given the current row about the Compaq takeover, I am not surprised that it has cooled. Larry must wait for Ms Fiorina's head to roll in the sand. It's terrible how much what is usually presented as 'vision', 'strategy' etc. is often hardly more than personal inimities (Bill Gates being to many CEOs what the Taleban were to Afghan warlords) and opportunistic alliances. My 0.02 euros. S Faroult Deshpande, Kirti wrote: Ah!! But 5 years down the road, Larry's Oracle database may not need any administration at all. You may just buy the pre-fabricated OraLintel gadget from him that runs your apps... :-)) Seriously, he me getting in position to fight the IBM Linux Mainframe running DB2(IBM announced the Linux MF not too long ago) and claim/prove(?) Oracle+Linux+Intel runs much faster than IBM's Linux mainframe.. - Kirti -Original Message- Sent: Thursday, January 31, 2002 8:35 PM To: Multiple recipients of list ORACLE-L Interesting news. Makes me wonder though. Remember when Oracle moved to support client-server computing? Now Larry derides client-server and distributed computing saying that it's cheaper to have just one big system. How many times have you heard Larry talk about how Oracle's consolidated their email servers? Makes me wonder whether five years down the road Larry will be telling us that it's silly to run a database on 50 cheap boxes because it's much easier to administer one big one. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Thursday, January 31, 2002, 2:36:21 PM, you wrote: AMG0 Ellison says Oracle's 'whole business' to run on Linux AMG0 The Oracle chairman and CEO said the company will replace three Unix AMG0 servers AMG0 that run the bulk of its business applications with a cluster of Intel AMG0 Corp. AMG0 servers running Linux. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux taking over at Oracle
We had a small discussion yesterday about Oracle moving to Linux (possibly), so my SA asks ... Is there any OS vendor left in the market that Uncle L hasn't pissed off yet? Sun was dumped in favor of HP, they already pissed off IBM because of DB/2, not dumping HP they move to Linux. So I told him that wait, they haven't done anything yet to MacOS, (after revival) CP/M (and a bunch of other Operating Systems). Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: Linux taking over at Oracle
it's not just Oracle, this tends to be a trend in all businesses. Just as there are fads in clothing (shorter hemlines, longer hemlines etc), there seem to be fads in the right way to manage your computer systems. I've seen the cycle turn a number of times centralize all software and systems, one data center to serve them all, standards cross-company then suddenly it's decentralize, one big center makes no sense, we don't get the things we need fast enough from them --- Jonathan Gennick [EMAIL PROTECTED] wrote: Interesting news. Makes me wonder though. Remember when Oracle moved to support client-server computing? Now Larry derides client-server and distributed computing saying that it's cheaper to have just one big system. How many times have you heard Larry talk about how Oracle's consolidated their email servers? Makes me wonder whether five years down the road Larry will be telling us that it's silly to run a database on 50 cheap boxes because it's much easier to administer one big one. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Thursday, January 31, 2002, 2:36:21 PM, you wrote: AMG0 Ellison says Oracle's 'whole business' to run on Linux AMG0 The Oracle chairman and CEO said the company will replace three Unix AMG0 servers AMG0 that run the bulk of its business applications with a cluster of Intel AMG0 Corp. AMG0 servers running Linux. AMG0 http://computerworld.com/nlt/1%2C3590%2CNAV47_STO67867_NLTAM%2C00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Linux taking over at Oracle
In a previous life in the 1980s, an IBM salesman has told me a funny story about an IBM marketing guy who was a specialist of strategy speeches, future of IT, etc. The salesman took a customer to a presentation once, and was very impressed by the speech in which the marketing man was demonstrating, extremely logically, that the future of IT was centralized big servers. As he had been so impressed, he took another customer to the same presentation a few months later, and, as he had already heard it, listened a bit less attentively. He began to startle around the conclusion, which no less logically than the first time was proving beyond any doubt that the future of IT was made of distributed processing power (IBM had announced the PC in the meantime). The salesman told me he had never understood where the logic had derailed. I have heard the marketing guy myself, he was VERY good. Rachel Carmichael wrote: it's not just Oracle, this tends to be a trend in all businesses. Just as there are fads in clothing (shorter hemlines, longer hemlines etc), there seem to be fads in the right way to manage your computer systems. I've seen the cycle turn a number of times centralize all software and systems, one data center to serve them all, standards cross-company then suddenly it's decentralize, one big center makes no sense, we don't get the things we need fast enough from them -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Linux taking over at Oracle
Hi All, I don't think anything here indicates that we are going back to hundreds of smaller databases. I does indicate that he is pushing the Real Application Clusters on thes smaller boxes so that they can continue to support large databases. John [EMAIL PROTECTED] wrote: Jonathan, I remember reading an article in Oracle Magazine about a year to year a half ago, where Uncle Larry was prostelatizing us to create one large database vs. having lots of small ones. So the screw turns once more!! Also I remember Oracle being torqued at RedHat some time ago find that 9i is NOT certified on RedHat. Guess that will change! Also, for those who remember, Uncle Larry did predict that the database would replace the operating system some years ago. Funny how these ideas change, don't materialize, or have other problems that prevent them becoming reality. But then I guess that's what you get trying to read a foggy crystal ball!! :-) My problem with all of this is that he's pointing us towards cheaper computers and operating systems, but will the cost of Oracle itself follow?? I doubt it. Which puts a pile of us in a rather sticky position. How do you justify $40K for Oracle on a $10K computer with a $0 OS? My brain hurts. Dick Goulet BTW: Uncle Larry torqued off Apple (MacOS) some years ago when he dropped support for it all together. Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 1/31/2002 6:35 PM Interesting news. Makes me wonder though. Remember when Oracle moved to support client-server computing? Now Larry derides client-server and distributed computing saying that it's cheaper to have just one big system. How many times have you heard Larry talk about how Oracle's consolidated their email servers? Makes me wonder whether five years down the road Larry will be telling us that it's silly to run a database on 50 cheap boxes because it's much easier to administer one big one. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Thursday, January 31, 2002, 2:36:21 PM, you wrote: AMG0 Ellison says Oracle's 'whole business' to run on Linux AMG0 The Oracle chairman and CEO said the company will replace three Unix AMG0 servers AMG0 that run the bulk of its business applications with a cluster of Intel AMG0 Corp. AMG0 servers running Linux. AMG0 http://computerworld.com/nlt/1%2C3590%2CNAV47_STO67867_NLTAM%2C00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux taking over at Oracle
On a contrarian note with all the Larry hype aside... Linux is much more that just a fad. In a relatively short time it has already put a very significant dent in MS server software sales and I'm sure it's going to affect Sun/HP regardless of Oracle's IT infrastructure strategies. Linux/Intel is a proven production quality platform and having worked with Linux/Oracle servers for over a year now I conclude that the Linux revolution is not going away like just another fad. In fact, it's just getting started. BTW, I'm getting ready to buy a ReplayTV unit and guess what it runs on? ... LINUX!!! If you want to get a good idea of what folks are doing with Oracle on Linux just join the [EMAIL PROTECTED] list or go to http://www.suse.com/en/support/oracle/index.html ... etc. I think the point behind all this is that, large, complex servers can be a support challenge with capacity planning for always on, 24x7, unlimited future scalability needs. Rather than racking our brains we should be RAC'ing our servers. Steve Orr, Montana Revolutionary -Original Message- Sent: Friday, February 01, 2002 5:40 AM To: Multiple recipients of list ORACLE-L it's not just Oracle, this tends to be a trend in all businesses. Just as there are fads in clothing (shorter hemlines, longer hemlines etc), there seem to be fads in the right way to manage your computer systems. I've seen the cycle turn a number of times centralize all software and systems, one data center to serve them all, standards cross-company then suddenly it's decentralize, one big center makes no sense, we don't get the things we need fast enough from them --- Jonathan Gennick [EMAIL PROTECTED] wrote: Interesting news. Makes me wonder though. Remember when Oracle moved to support client-server computing? Now Larry derides client-server and distributed computing saying that it's cheaper to have just one big system. How many times have you heard Larry talk about how Oracle's consolidated their email servers? Makes me wonder whether five years down the road Larry will be telling us that it's silly to run a database on 50 cheap boxes because it's much easier to administer one big one. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Thursday, January 31, 2002, 2:36:21 PM, you wrote: AMG0 Ellison says Oracle's 'whole business' to run on Linux AMG0 The Oracle chairman and CEO said the company will replace three Unix AMG0 servers AMG0 that run the bulk of its business applications with a cluster of Intel AMG0 Corp. AMG0 servers running Linux. AMG0 http://computerworld.com/nlt/1%2C3590%2CNAV47_STO67867_NLTAM%2C00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux taking over at Oracle
I think that the LVM announcement in the link below is the lynchpin for getting Linux Enterprise-wide (man, I hate buzzwords!): http://www.veritas.com/news/press/PressReleaseDetail.jhtml?NewsId=9483 Now if I could only get Oracle on Linux for Alpha, I'd be set! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, February 01, 2002 9:56 AM To: Multiple recipients of list ORACLE-L On a contrarian note with all the Larry hype aside... Linux is much more that just a fad. In a relatively short time it has already put a very significant dent in MS server software sales and I'm sure it's going to affect Sun/HP regardless of Oracle's IT infrastructure strategies. Linux/Intel is a proven production quality platform and having worked with Linux/Oracle servers for over a year now I conclude that the Linux revolution is not going away like just another fad. In fact, it's just getting started. BTW, I'm getting ready to buy a ReplayTV unit and guess what it runs on? ... LINUX!!! If you want to get a good idea of what folks are doing with Oracle on Linux just join the [EMAIL PROTECTED] list or go to http://www.suse.com/en/support/oracle/index.html ... etc. I think the point behind all this is that, large, complex servers can be a support challenge with capacity planning for always on, 24x7, unlimited future scalability needs. Rather than racking our brains we should be RAC'ing our servers. Steve Orr, Montana Revolutionary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux taking over at Oracle
I've seen the cycle turn a number of times centralize all software and systems, one data center to serve them all, standards cross-company then suddenly it's decentralize, one big center makes no sense, we don't get the things we need fast enough from them I always think that thinking in IT is like a huge pendulum in one of those granfather clocks - swing one way this year, swing the other way the next, and back again we go! Whatever direction it swings, there has to be some springs and gears and wheels that makes it all work. DBAs are a small but important part of that clock - we only have to watch out for that piezo-electric crytal and LED/LCDs that *may* make us moving parts redundant. Just another lesson in Life from yours truly! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Fear is the darkroom where Evil develops your negatives. Wanna break free of fear? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Linux taking over at Oracle
I thought it also put a dent in HP/UX Solaris sales...easier to migrate UNIX to Linux. I believe Amazon is a good example. For the record, I have no love for MS. Congrats on your ReplayTV, it will blow your mind once you fully grasp it's usefulness. I love my TiVo, and I can't live without it. Looking forward to the Superbowl, and doing my own replays, slow motion plays back and forth, etc. -Original Message- Sent: Friday, February 01, 2002 10:56 AM To: Multiple recipients of list ORACLE-L On a contrarian note with all the Larry hype aside... Linux is much more that just a fad. In a relatively short time it has already put a very significant dent in MS server software sales and I'm sure it's going to affect Sun/HP regardless of Oracle's IT infrastructure strategies. Linux/Intel is a proven production quality platform and having worked with Linux/Oracle servers for over a year now I conclude that the Linux revolution is not going away like just another fad. In fact, it's just getting started. BTW, I'm getting ready to buy a ReplayTV unit and guess what it runs on? ... LINUX!!! If you want to get a good idea of what folks are doing with Oracle on Linux just join the [EMAIL PROTECTED] list or go to http://www.suse.com/en/support/oracle/index.html ... etc. I think the point behind all this is that, large, complex servers can be a support challenge with capacity planning for always on, 24x7, unlimited future scalability needs. Rather than racking our brains we should be RAC'ing our servers. Steve Orr, Montana Revolutionary -Original Message- Sent: Friday, February 01, 2002 5:40 AM To: Multiple recipients of list ORACLE-L it's not just Oracle, this tends to be a trend in all businesses. Just as there are fads in clothing (shorter hemlines, longer hemlines etc), there seem to be fads in the right way to manage your computer systems. I've seen the cycle turn a number of times centralize all software and systems, one data center to serve them all, standards cross-company then suddenly it's decentralize, one big center makes no sense, we don't get the things we need fast enough from them --- Jonathan Gennick [EMAIL PROTECTED] wrote: Interesting news. Makes me wonder though. Remember when Oracle moved to support client-server computing? Now Larry derides client-server and distributed computing saying that it's cheaper to have just one big system. How many times have you heard Larry talk about how Oracle's consolidated their email servers? Makes me wonder whether five years down the road Larry will be telling us that it's silly to run a database on 50 cheap boxes because it's much easier to administer one big one. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Thursday, January 31, 2002, 2:36:21 PM, you wrote: AMG0 Ellison says Oracle's 'whole business' to run on Linux AMG0 The Oracle chairman and CEO said the company will replace three Unix AMG0 servers AMG0 that run the bulk of its business applications with a cluster of Intel AMG0 Corp. AMG0 servers running Linux. AMG0 http://computerworld.com/nlt/1%2C3590%2CNAV47_STO67867_NLTAM%2C00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: RE: Linux taking over at Oracle
There are rumors that Red Hat is buying Microsoft? -Original Message- Sent: Friday, February 01, 2002 11:16 AM To: Multiple recipients of list ORACLE-L Steve, As one of the GREAT MicroSlop bashers, I pray you are more than correct. May the Penguin rule!! BTW: I've experimented with Oracle 8 8i on Linux, RedHat's variant, I'll agree it is stable, easy to use, and very supportable. The problem is the cost of Oracle on a Linux box. One reason I've been playing around with PostGres. I can't say I like it as much, but you really can't beat the price tag. DickG. Reply Separator Author: Orr; Steve [EMAIL PROTECTED] Date: 2/1/2002 7:55 AM On a contrarian note with all the Larry hype aside... Linux is much more that just a fad. In a relatively short time it has already put a very significant dent in MS server software sales and I'm sure it's going to affect Sun/HP regardless of Oracle's IT infrastructure strategies. Linux/Intel is a proven production quality platform and having worked with Linux/Oracle servers for over a year now I conclude that the Linux revolution is not going away like just another fad. In fact, it's just getting started. BTW, I'm getting ready to buy a ReplayTV unit and guess what it runs on? ... LINUX!!! If you want to get a good idea of what folks are doing with Oracle on Linux just join the [EMAIL PROTECTED] list or go to http://www.suse.com/en/support/oracle/index.html ... etc. I think the point behind all this is that, large, complex servers can be a support challenge with capacity planning for always on, 24x7, unlimited future scalability needs. Rather than racking our brains we should be RAC'ing our servers. Steve Orr, Montana Revolutionary -Original Message- Sent: Friday, February 01, 2002 5:40 AM To: Multiple recipients of list ORACLE-L it's not just Oracle, this tends to be a trend in all businesses. Just as there are fads in clothing (shorter hemlines, longer hemlines etc), there seem to be fads in the right way to manage your computer systems. I've seen the cycle turn a number of times centralize all software and systems, one data center to serve them all, standards cross-company then suddenly it's decentralize, one big center makes no sense, we don't get the things we need fast enough from them --- Jonathan Gennick [EMAIL PROTECTED] wrote: Interesting news. Makes me wonder though. Remember when Oracle moved to support client-server computing? Now Larry derides client-server and distributed computing saying that it's cheaper to have just one big system. How many times have you heard Larry talk about how Oracle's consolidated their email servers? Makes me wonder whether five years down the road Larry will be telling us that it's silly to run a database on 50 cheap boxes because it's much easier to administer one big one. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Thursday, January 31, 2002, 2:36:21 PM, you wrote: AMG0 Ellison says Oracle's 'whole business' to run on Linux AMG0 The Oracle chairman and CEO said the company will replace three Unix AMG0 servers AMG0 that run the bulk of its business applications with a cluster of Intel AMG0 Corp. AMG0 servers running Linux. AMG0 http://computerworld.com/nlt/1%2C3590%2CNAV47_STO67867_NLTAM%2C00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access
RE: Linux taking over at Oracle
For a different perspective step into Larry's shoes for a minute, (O... that's scary!)... Hmmm... the less they have to spend on servers the more money left over to spend on me, er, my products... Oracle will get away with their pricing as long as the competition isn't so stiff that they have to lower their prices to protect their base... but a day of reckoning is coming. Not selling my Oracle stock... yet. -Original Message- Sent: Friday, February 01, 2002 9:15 AM To: Orr, Steve; Multiple recipients of list ORACLE-L Steve, As one of the GREAT MicroSlop bashers, I pray you are more than correct. May the Penguin rule!! BTW: I've experimented with Oracle 8 8i on Linux, RedHat's variant, I'll agree it is stable, easy to use, and very supportable. The problem is the cost of Oracle on a Linux box. One reason I've been playing around with PostGres. I can't say I like it as much, but you really can't beat the price tag. DickG. Reply Separator Author: Orr; Steve [EMAIL PROTECTED] Date: 2/1/2002 7:55 AM On a contrarian note with all the Larry hype aside... Linux is much more that just a fad. In a relatively short time it has already put a very significant dent in MS server software sales and I'm sure it's going to affect Sun/HP regardless of Oracle's IT infrastructure strategies. Linux/Intel is a proven production quality platform and having worked with Linux/Oracle servers for over a year now I conclude that the Linux revolution is not going away like just another fad. In fact, it's just getting started. BTW, I'm getting ready to buy a ReplayTV unit and guess what it runs on? ... LINUX!!! If you want to get a good idea of what folks are doing with Oracle on Linux just join the [EMAIL PROTECTED] list or go to http://www.suse.com/en/support/oracle/index.html ... etc. I think the point behind all this is that, large, complex servers can be a support challenge with capacity planning for always on, 24x7, unlimited future scalability needs. Rather than racking our brains we should be RAC'ing our servers. Steve Orr, Montana Revolutionary -Original Message- Sent: Friday, February 01, 2002 5:40 AM To: Multiple recipients of list ORACLE-L it's not just Oracle, this tends to be a trend in all businesses. Just as there are fads in clothing (shorter hemlines, longer hemlines etc), there seem to be fads in the right way to manage your computer systems. I've seen the cycle turn a number of times centralize all software and systems, one data center to serve them all, standards cross-company then suddenly it's decentralize, one big center makes no sense, we don't get the things we need fast enough from them --- Jonathan Gennick [EMAIL PROTECTED] wrote: Interesting news. Makes me wonder though. Remember when Oracle moved to support client-server computing? Now Larry derides client-server and distributed computing saying that it's cheaper to have just one big system. How many times have you heard Larry talk about how Oracle's consolidated their email servers? Makes me wonder whether five years down the road Larry will be telling us that it's silly to run a database on 50 cheap boxes because it's much easier to administer one big one. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Thursday, January 31, 2002, 2:36:21 PM, you wrote: AMG0 Ellison says Oracle's 'whole business' to run on Linux AMG0 The Oracle chairman and CEO said the company will replace three Unix AMG0 servers AMG0 that run the bulk of its business applications with a cluster of Intel AMG0 Corp. AMG0 servers running Linux. AMG0 http://computerworld.com/nlt/1%2C3590%2CNAV47_STO67867_NLTAM%2C00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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:
RE: RE: Linux taking over at Oracle
It's not a rumor, it's true...MS is letting themselves become aquired by Red Hat, they figure that all the lawsuits will have to be dropped, and there going to put the Windows GUI onto RH Linux. A killer combo. A brillant move by Bill Gates. https://www.usatoday.com/current/0201/am/rhmspur.html -Original Message- Sent: Friday, February 01, 2002 12:50 PM To: Multiple recipients of list ORACLE-L There are rumors that Red Hat is buying Microsoft? -Original Message- Sent: Friday, February 01, 2002 11:16 AM To: Multiple recipients of list ORACLE-L Steve, As one of the GREAT MicroSlop bashers, I pray you are more than correct. May the Penguin rule!! BTW: I've experimented with Oracle 8 8i on Linux, RedHat's variant, I'll agree it is stable, easy to use, and very supportable. The problem is the cost of Oracle on a Linux box. One reason I've been playing around with PostGres. I can't say I like it as much, but you really can't beat the price tag. DickG. Reply Separator Author: Orr; Steve [EMAIL PROTECTED] Date: 2/1/2002 7:55 AM On a contrarian note with all the Larry hype aside... Linux is much more that just a fad. In a relatively short time it has already put a very significant dent in MS server software sales and I'm sure it's going to affect Sun/HP regardless of Oracle's IT infrastructure strategies. Linux/Intel is a proven production quality platform and having worked with Linux/Oracle servers for over a year now I conclude that the Linux revolution is not going away like just another fad. In fact, it's just getting started. BTW, I'm getting ready to buy a ReplayTV unit and guess what it runs on? ... LINUX!!! If you want to get a good idea of what folks are doing with Oracle on Linux just join the [EMAIL PROTECTED] list or go to http://www.suse.com/en/support/oracle/index.html ... etc. I think the point behind all this is that, large, complex servers can be a support challenge with capacity planning for always on, 24x7, unlimited future scalability needs. Rather than racking our brains we should be RAC'ing our servers. Steve Orr, Montana Revolutionary -Original Message- Sent: Friday, February 01, 2002 5:40 AM To: Multiple recipients of list ORACLE-L it's not just Oracle, this tends to be a trend in all businesses. Just as there are fads in clothing (shorter hemlines, longer hemlines etc), there seem to be fads in the right way to manage your computer systems. I've seen the cycle turn a number of times centralize all software and systems, one data center to serve them all, standards cross-company then suddenly it's decentralize, one big center makes no sense, we don't get the things we need fast enough from them --- Jonathan Gennick [EMAIL PROTECTED] wrote: Interesting news. Makes me wonder though. Remember when Oracle moved to support client-server computing? Now Larry derides client-server and distributed computing saying that it's cheaper to have just one big system. How many times have you heard Larry talk about how Oracle's consolidated their email servers? Makes me wonder whether five years down the road Larry will be telling us that it's silly to run a database on 50 cheap boxes because it's much easier to administer one big one. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Thursday, January 31, 2002, 2:36:21 PM, you wrote: AMG0 Ellison says Oracle's 'whole business' to run on Linux AMG0 The Oracle chairman and CEO said the company will replace three Unix AMG0 servers AMG0 that run the bulk of its business applications with a cluster of Intel AMG0 Corp. AMG0 servers running Linux. AMG0 http://computerworld.com/nlt/1%2C3590%2CNAV47_STO67867_NLTAM%2C00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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,
RE: Linux taking over at Oracle
Not selling my Oracle stock... yet. now is the time to buy! it's cheap! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, February 01, 2002 1:42 PM To: Multiple recipients of list ORACLE-L For a different perspective step into Larry's shoes for a minute, (O... that's scary!)... Hmmm... the less they have to spend on servers the more money left over to spend on me, er, my products... Oracle will get away with their pricing as long as the competition isn't so stiff that they have to lower their prices to protect their base... but a day of reckoning is coming. Not selling my Oracle stock... yet. -Original Message- Sent: Friday, February 01, 2002 9:15 AM To: Orr, Steve; Multiple recipients of list ORACLE-L Steve, As one of the GREAT MicroSlop bashers, I pray you are more than correct. May the Penguin rule!! BTW: I've experimented with Oracle 8 8i on Linux, RedHat's variant, I'll agree it is stable, easy to use, and very supportable. The problem is the cost of Oracle on a Linux box. One reason I've been playing around with PostGres. I can't say I like it as much, but you really can't beat the price tag. DickG. Reply Separator Author: Orr; Steve [EMAIL PROTECTED] Date: 2/1/2002 7:55 AM On a contrarian note with all the Larry hype aside... Linux is much more that just a fad. In a relatively short time it has already put a very significant dent in MS server software sales and I'm sure it's going to affect Sun/HP regardless of Oracle's IT infrastructure strategies. Linux/Intel is a proven production quality platform and having worked with Linux/Oracle servers for over a year now I conclude that the Linux revolution is not going away like just another fad. In fact, it's just getting started. BTW, I'm getting ready to buy a ReplayTV unit and guess what it runs on? ... LINUX!!! If you want to get a good idea of what folks are doing with Oracle on Linux just join the [EMAIL PROTECTED] list or go to http://www.suse.com/en/support/oracle/index.html ... etc. I think the point behind all this is that, large, complex servers can be a support challenge with capacity planning for always on, 24x7, unlimited future scalability needs. Rather than racking our brains we should be RAC'ing our servers. Steve Orr, Montana Revolutionary -Original Message- Sent: Friday, February 01, 2002 5:40 AM To: Multiple recipients of list ORACLE-L it's not just Oracle, this tends to be a trend in all businesses. Just as there are fads in clothing (shorter hemlines, longer hemlines etc), there seem to be fads in the right way to manage your computer systems. I've seen the cycle turn a number of times centralize all software and systems, one data center to serve them all, standards cross-company then suddenly it's decentralize, one big center makes no sense, we don't get the things we need fast enough from them --- Jonathan Gennick [EMAIL PROTECTED] wrote: Interesting news. Makes me wonder though. Remember when Oracle moved to support client-server computing? Now Larry derides client-server and distributed computing saying that it's cheaper to have just one big system. How many times have you heard Larry talk about how Oracle's consolidated their email servers? Makes me wonder whether five years down the road Larry will be telling us that it's silly to run a database on 50 cheap boxes because it's much easier to administer one big one. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Thursday, January 31, 2002, 2:36:21 PM, you wrote: AMG0 Ellison says Oracle's 'whole business' to run on Linux AMG0 The Oracle chairman and CEO said the company will replace three Unix AMG0 servers AMG0 that run the bulk of its business applications with a cluster of Intel AMG0 Corp. AMG0 servers running Linux. AMG0 http://computerworld.com/nlt/1%2C3590%2CNAV47_STO67867_NLTAM%2C00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists