Re: Can one have 2 instances on 8.1.6/NT 4.0?

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 15 Feb 2001 14:51:02 +1100
Message-ID: <5tIi6.209$305.67816@inet16.us.oracle.com>

Yes. Undoubtedly. The number of Instances running on a box is limited only by the amount of memory you have available.

Each Instance must have a service running (check in Control Panel - Services).

What you have found is most probably the *default* Instance name (a bit like ORACLE_SID set in the environment variables). It's the Instance to which you will connect by default unless you specify exactly which Instance it is you want with the tnsnames alias ("@SID2" etc). Clearly, there can only ever be one default.

Regards
HJR "JOEshmoe" <JOEshmoe_at_HOTMAIL.COM> wrote in message news:3A8AE6EF.88A9FB3_at_HOTMAIL.COM...
> Hi,
>
> Can an NT 4.0 system running Oracle 8.1.6 have two instances? In the
> registry the only entry for Oracle.SID is the second instance name.
> There are two entries for everything else.
>
> thanks
>
>
>
Received on Wed Feb 14 2001 - 21:51:02 CST