Re: Setting Default Instance

You can always add a LOCAL entry into the registry to set your default instance.
Something like this:
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE ->String Value-> LOCAL ant the value is the name of your instance.

Tavo

"Russ Braaten" <russ_braaten_at_fmo.com> wrote in message news:8ls8ui$lru$1_at_news3.infoave.net...
> I have two instances running on the same NT4.0 server. They are both Ora
 cle
> 7.3. I don't have any problems performance wise, but I do have a definate
> issue. Whether or not you use instance manager (in Enterprise Manager) or
> Server Manager, if you don't specify a pfile when you startup your startup
 a
> database, it will always start one particular database. (If you don't
 think
> that's a problem, think about what running one database under a different
> SID will do to your archive log files........) Now, I know the solution
 to
> this is to ALWAYS specify a pfile when starting a database, but I remember
> reading somewhere where the default (the one that always starts) is set.
>
> Anybody know where that is set?
>
> Thanks,
>
> Russ Braaten
>
>
Received on Mon Jul 31 2000 - 00:00:00 CDT