RE: Two 9i DBs on Win Server 2003
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <JApplewhite@xxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Feb 2008 10:34:06 -0500
Jack,
This is no problem at all. It all comes down to resources on the machine (can
it supporty multiple db's on it?).
I've seen up to two dozen db's on one WIN machine with multiple Oracle Homes.
This was a development box, but we never had any issues with it.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of JApplewhite@xxxxxxxxxxxxx
Sent: Sat 2/16/2008 9:38 AM
To: oracle-l
Cc: oracle-l-bounce@xxxxxxxxxxxxx
Subject: Two 9i DBs on Win Server 2003
Any issues with having two 9i (9.2.0.4) databases on the same Win 2003
server? We've had one small departmental Production DB on this server for
about 3 years and want to put another there. We have lots of HPUX and
Linux servers with multiple DBs and know how to do that very well.
I've put Oracle DBs on Win servers since Oracle7, but don't recall that I
ever had two on the same machine at once. All I think I need to do is use
the oradim utility to create a new Windows Service and put a pfile in
ORACLE_HOME\database pointing to the one for the new DB, along with a
password file. The new DB will use the same ORACLE_HOME as the existing
one and, of course, I'll make sure I adjust the SGA, etc. of the new DB so
that it fits in available memory.
Any gotchas that y'all have encountered or things I've forgotten?
Thanks.
Jack C. Applewhite - Database Administrator
Austin I.S.D.
414.9715 (phone) / 935.5929 (pager)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
