Re: Two 9i DBs on Win Server 2003
Date: Sat, 16 Feb 2008 20:00:08 -0800
Hit SEND too soon, I need to clarify this.
Do not set ORACLE_HOME in the Registry for the CMD environment.
At the command line is fine, and necessary.
On Feb 16, 2008 7:59 PM, Jared Still <jkstill_at_gmail.com> wrote:
> I've run multiple Oracle databases in a single Win2k server with few
> One lesson I learned the hard way - NEVER set Oracle home in the CMD
> Lots of things will start breaking. Patches don't work, services start
> the wrong databases.
> All kinds of fun things.
> On Feb 16, 2008 6:38 AM, <JApplewhite_at_austinisd.org> wrote:
> > Any issues with having two 9i (184.108.40.206) 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)
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 16 2008 - 22:00:08 CST