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