Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Running multiple instances on a [large] server

RE: Running multiple instances on a [large] server

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 11 Mar 2003 06:34:05 -0800
Message-ID: <F001.00565EFF.20030311063405@fatcity.com>


Hemant

   What you are considering is certainly feasible. Consider how compatible these applications are, whether they have similar requirements in terms of uptime. Are their performance requirements compatible? One factor to consider is future upgrade paths of the applications. We seem to run into situations where one application needs a new Oracle version, which means a new O.S. version, but another application cannot upgrade at this time. Just be aware you are chaining these applications together by doing this.

   I have only run that many Oracle instances on test, but would not hesitate to do that on production.

   I create an Oracle home for each Oracle version. This was discussed recently on this list, although more of the discussion related to having separate Unix userids for each instance, something I do not do.

   Oracle licensing is based on the number of CPUs, for the CPU licensing option.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, March 11, 2003 2: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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Mar 11 2003 - 08:34:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US