RE: Multiple production databases (and/or oracle_homes) on one windows server
Date: Mon, 25 Jan 2010 17:49:03 +0100
In a nutshell..
You can have as many oracle databases/oracle_home's as you want on windows 2003. No limits, same as Unix/Linux
Each running database is a single multithreaded windows process (oracle.exe)
Each database has an associated windows service so that's how you manage automatic startup after a boot
"Dos box" sqlplus is my own favourite SQL CLI because of command history.
As for HA, next to RAC and Dataguard there's also Failsafe, based on MSCS.
Van: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
Namens Toon Koppelaars
Verzonden: maandag 25 januari 2010 17:30 Aan: oracle-l-freelists
Onderwerp: Multiple production databases (and/or oracle_homes) on one windows server
Context: 11Gr1, Windows Server 2003
I'm curious if this (see subject) is done at all.
My background is primarily using Unix/Linux as the OS for a database server.
And I see how having multiple production databases, supported by a single, or even multiple oracle_homes, is not an issue on Unix/Linux.
Given that there is enough memory + cpu to service the instances.
But how is this in the Windows space?
Should I go there?
Or stay far away from it?
Any comments are appreciated.
-- Toon Koppelaars RuleGen BVReceived on Mon Jan 25 2010 - 10:49:03 CST
TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals"
www.RuleGen.com/pls/apex/f?p=14265:13 -- http://www.freelists.org/webpage/oracle-l