Re: Running multiple instances on a [large] server
A Dell Inspiron 8200 laptop has 1 GB of RAM with 30 GB of disk running Window 2000 Professional. The SGA sizes for 5 Oracle instances are: Oracle 7.3.4.5.0 - 11 MB Oracle 8.0.6.3.8 - 15 MB Oracle 8.1.7.4.1 - 94 MB Oracle 9.0.1.4.0 - 109 MB Oracle 9.2.0.2.1 - 113 MB While presenting, the task manager shows ~850 MB of mem usage. Currently these 5 demo databases are running noarchivelog mode. Have Fun :) Rachel Carmichael wrote: 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip 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).
re : Running multiple instances on a [large] server -- Thanks
Re : 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 ? The consensus seems to be that 1. Multiple database instances on one server is doable and IS done. [Although some of those quoting a large number of instances were talking of Development environments, not Production]. However, issues with SGA sizing/resizing may arise. I'd have to be careful to pre-size the SGAs well enough --- the total size should be well below the physical RAM available. [BTW, our System Integrators say that all their applications are currently certified on 8.1.7 and Top Damagement has decided to stick to 8.1.7 overriding my request for certification for 9i before the applications go live]. 2. Some go for shared ORACLE_HOMEs, others go for seperate. I will still go for seperate ORACLE_HOMEs for the reasons i. Maintenance and Patching are seperated. ii. Upgrades of individual databases are easier. iii. In the future it allows me to hand-over ownership of the databases to different DBA[s] if the need arises. 3. A mix of CPU + NamedUser licensing has been adopted by some sites. However, I still believe Oracle would just count the total number of CPUs on that one server and charge the license for that count, regardless of the number of database instances running. Therefore, I would just buy the CPU license and not have to pay seperately for a NamedUser license for any databases on the same server. thanks everybody ! Hemant K Chitale My personal web site is : 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).
RE: Running multiple instances on a [large] server
I have run/am running multiple oracle databases on a single server on AIX/Linux/W2K/NT although not with sga's in the GB area.Just make sure you get away with your I/O requirements We only had seperate homes for seperate oracle versions, so all 817 databases were in one home and 8.0.5 databases were grouped in one home etc.etc. I did not have to deal with licensing so can't give you a comment there. -Original Message- Sent: dinsdag 11 maart 2003 9:49 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: [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: Jack van Zanen 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).
RE: Running multiple instances on a [large] server
Hi, On one of the 7 development box (aix 4.3.3) we have 27 instances Oracle 8172. All using the same oracle_home. I can't say it's the fastest response time ;-) As for the licensing we have a mix of CPU and user licences. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tél. (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Chitale 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: [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: Stephane Paquette 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).
Re: Running multiple instances on a [large] server
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 hkchitalTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @singnet.com.sg cc: Sent by: rootSubject: 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).
RE: Running multiple instances on a [large] server
Title: RE: Running multiple instances on a [large] server On our development RAC servers we have 24 instances ... on each side, performance is okay. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: Stephane Paquette [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 11, 2003 9:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Running multiple instances on a [large] server Hi, On one of the 7 development box (aix 4.3.3) we have 27 instances Oracle 8172. All using the same oracle_home. I can't say it's the fastest response time ;-) As for the licensing we have a mix of CPU and user licences. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tél. (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Chitale 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: [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: Stephane Paquette 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). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Running multiple instances on a [large] server
We are running 11 instances on WinNT with no problems! At one point, we had 26 instances. they are all development instances, so volumn and load are low. but they all share one Oracle Home. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 11, 2003 9:19 AM To: Multiple recipients of list ORACLE-L 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 hkchitalTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @singnet.com.sg cc: Sent by: rootSubject: 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: Mercadante, Thomas F 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).
RE: Running multiple instances on a [large] server
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. [EMAIL PROTECTED] -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: [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: DENNIS WILLIAMS 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).
RE: RE: Running multiple instances on a [large] server
Hemant Dick makes a good point about physical memory. The problem with a lot of instances is that they all have fixed amounts of memory (except in 9i, up to SGA_MAX_SIZE), and if one instance needs more memory you can't reallocate unless you bounce it to add memory and maybe bounce several others to reduce their memory. If you can consolidate instances, then they will be dynamically sharing memory. Probably not the answer management wants to hear, though. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 11, 2003 8:50 AM To: Multiple recipients of list ORACLE-L We also run several instances on just about every server we have. Most, but not all share the same Oracle_home. I only create new ones for newer versions of Oracle, but for each database I prefer to use seperate mount points such as: /test/system /test/rbs /test/temp /prod1/system /prod1/rbs /prod1/temp /prod2/system etc... Keeps one from stepping on one's own _. (You fill in the blanks.) The biggest problem I think you'll face is physical memory. Have too little with too big an SGA you start swapping. Have smaller SGA's and wait IO can become a problem. Simply put, you just can't have too much memory. Typically we license a server for whatever it's being used for, so yes we do have user and cpu licenses. Kind of a pain keeping track. Dick Goulet Reply Separator Author: Stephane Paquette [EMAIL PROTECTED] Date: 3/11/2003 6:19 AM Hi, On one of the 7 development box (aix 4.3.3) we have 27 instances Oracle 8172. All using the same oracle_home. I can't say it's the fastest response time ;-) As for the licensing we have a mix of CPU and user licences. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tél. (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Chitale 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: [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: Stephane Paquette 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
RE: Running multiple instances on a [large] server
Title: RE: Running multiple instances on a [large] server 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- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 11, 2003 3:49 AM To: Multiple recipients of list ORACLE-L Subject: Running multiple instances on a [large] server 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).
Re: Running multiple instances on a [large] server
Do all share the same address space or does each instance get it's own copy of Oracle.exe and it's own 2g address space? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 10:04 AM We are running 11 instances on WinNT with no problems! At one point, we had 26 instances. they are all development instances, so volumn and load are low. but they all share one Oracle Home. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 11, 2003 9:19 AM To: Multiple recipients of list ORACLE-L 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 hkchitalTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @singnet.com.sg cc: Sent by: rootSubject: 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: Mercadante, Thomas F 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: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To
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: [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: Chuck Hamilton 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).