Re: Running multiple instances on a [large] server

RE: Running multiple instances on a [large] serverBy "environment" do you mean "instance"? If so, couldn't you accomplish the same thing with one oracle home on each server for each version installed? That's what we do in our clustered environments. Each node has an oracle home for each version of Oracle that it might need to run. Failover here takes about the same amount of time but much less disk space. Last time I checked a single oracle home was running about 3g.

• Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Tuesday, March 11, 2003 12:10 PM

We run upto 22 instances on large SUN boxes... Each environment has their own oracle home, own file system, and in some cases-their own UNIX account for the environment..
One loses a little space for the multiple oracle homes, and it does add some overhead for the operations.. But when we need to migrate a database to a new server;we can shutdown the DB-umount,mount on the new system, and crank it up.
We have been in a situation where the machine resources choked, and we were able to move a couple of databases with less than a 3 minute hit for an outage. Would have been less if the operations guys(SA's) had things tee'd up, and ready to hit it with the Driver too. greg
-----Original Message-----
Sent: Tuesday, March 11, 2003 3:49 AM
To: Multiple recipients of list 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: hkchital_at_singnet.com.sg
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chuck Hamilton
  INET: chuckh_at_softhome.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).