Re: oradim

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 29 Jan 2004 15:50:41 -0800
Message-ID: <1ac7c7b3.0401291550.35947fcd@posting.google.com>

Chuck <chuckh_nospam_at_softhome.net> wrote in message news:<Xns947F83DEDD5F6chuckhsofthomenet_at_130.133.1.4>...
> I have a win2000 server with two different oracle homes on it. When
> creating an Oracle service with oradim, how do I tell it which home to use
> when it starts the instance? The homes contain different versions and I
> want different services starting different instances in different versions.
> The versions involved are 8.1.7.0 and 8.1.7.12.

if you create a database using the Oracle Database Creation Assistant (dbca) and save the scripts, it specifies the full path to each executable that is run.

seems like a good practice to me.

if your Oracle homes are as follows:

D:\oracle

         \ora81
         \ora92

then to create a new service for an 8.1.7 db (assuming that you already have a password file in D:\oracle\ora92\database)

C:\> d:\oracle\ora81\bin\oradim.exe -new -sid <mysid> -startmode m -pfile <path> -timeout 150

hth.

Pd Received on Thu Jan 29 2004 - 17:50:41 CST