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@xxxxxxxxx> 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@xxxxxxxxxxxxx> 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