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
- dgoulet_at_vicr.com 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" <tday6_at_csc.com>
> 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 <ORACLE-L_at_fatcity.com>
> @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: 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: Thomas Day
> INET: tday6_at_csc.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: dgoulet_at_vicr.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).
>
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: wisernet100_at_yahoo.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 - 10:14:04 CST