Re: how to connect to second instance

From: Abey Joseph <abeyjoseph_at_hotmail.com>
Date: Mon, 21 May 2001 14:52:25 -0400
Message-ID: <9ebo7r$obg$1@slb7.atl.mindspring.net>

"Michael Bierenfeld" <michael.bierenfeld_at_atmiralis.de> wrote in message news:3B09304E.67512ACF_at_atmiralis.de...
> Woodstock wrote:
> >
> > I have a machine running oracle database. there are 2 instance installed
and
> > both are running. Instance #1 was setup when oracle ws install
initially,
> > while instance #2 was created at a later stage. Everytime I type
> >
> > SQL > connect internal
> >
> > I will be automatically connect to instance #1. How can i connect to the
> > second instance?
>
> Hi !
>
> Check the setting of your ORACLE_SID Environment variable. Set it to the
> second instance or use a TWO_TASK Variable.
>
> On Windows : Keine Ahnung (no clue)
>
> Regards
>
> Michael

On Windows, create a database alias with SQL Net or Net8. Provide the SID name, port number etc. Then you can refer to this alias (in the connect string entry) when connecting to the database instance.

Abey. Received on Mon May 21 2001 - 13:52:25 CDT