At RMOUG last week, I heard that someone (Chip Briggs I think) had 5 (count 'em 5) isntances of Oracle running on his PC. I don't think it was Linux and it definitely wasn't production anything
Rachel --- [EMAIL PROTECTED] wrote: > Thomas, > > Now that's an interesting comment. I can't remember ever seeing > more than > one instance on an NT machine either except when we were playing > around & boy > did that crash in a big hurry (NT 4.0 Oracle 8.0). On the other hand > I've set > up Linux with 4 instances (same piece of hardware) and had no > problems. Got to > love the Penguin. > > Dick Goulet > > ____________________Reply Separator____________________ > Author: "Thomas Day" <[EMAIL PROTECTED]> > Date: 3/11/2003 6:19 AM > > > I can't remember the last time that I saw a server (other than WinNT) > running a single instance. My experience is that it's quite normal > to run > multiple instances on a single server. > > One Oracle home per version of Oracle. I'm not sure what the point > of a > separate Oracle home per instance would be. > > On the licensing issue --- that's Oracle's call. We have a site > license so > it's not an issue for me. > > > > > > > Hemant K Chitale > > > <hkchital To: Multiple > recipients of > list ORACLE-L <[EMAIL PROTECTED]> > @singnet.com.sg> cc: > > > Sent by: root Subject: Running > multiple > instances on a [large] server > > > > > > > 03/11/2003 03:48 > > > AM > > > Please respond > > > to ORACLE-L > > > > > > > > > > > > > > One of the teams here is planning to run anything > from 8 to 16 database instances [no indication on > sizing yet, but gut-feel SGAs are 200MB to 1GB > and DB sizes 500MB to 40GB] on a "large" server, > something like a Sun E6800 or an equivalent > HP or Fujitsu server. > > 1. How many of you do run, and are comfortable running, > multiple databases on the same server, whether it is > "partitioned" or not ? > 2. Do you create a seperate ORACLE_HOME for > each instance ? > 3. Do you just buy the Oracle DB CPU license on the > total number of CPUs on the server ? > > My positioning is > a. We might not be able to create 8 partitions but > partition such that we have a max of 2 or 3 instances > in one partition. Hopefully, I can dynamically change > CPU partitioning to reallocate CPU to another group > of instances. > > b. Each instance should have it's own ORACLE_HOME. > [Disk space is not a constraint]. > > c. Just add up the number of CPUs on the server, > across all partitions, and buy a CPU license. Also, > a CPU license is much preferable to Named-User as some > of these databases would host Portals for 1,000+ end-users. > > > Hemant K Chitale > http://hkchital.tripod.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hemant K Chitale > 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: Thomas Day > 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: > 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). > __________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
