Re: Setting Default Instance

It's the NT environement variable ORACLE_SID

Check under Settings->Control Panel->System->Environment

Hope that helps

Graham

Russ Braaten wrote:

> I have two instances running on the same NT4.0 server. They are both Oracle
> 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 Fri Jul 28 2000 - 00:00:00 CDT