Re: Two 9i DBs on Win Server 2003

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
> problems.
>
> One lesson I learned the hard way - NEVER set Oracle home in the CMD
> environment.
>
> 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 (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)
> >
>
>
>
> --
> 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-l