Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to connect to second instance

Re: how to connect to second instance

From: Michael Bierenfeld <michael.bierenfeld_at_atmiralis.de>
Date: Mon, 21 May 2001 17:12:14 +0200
Message-ID: <3B09304E.67512ACF@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 Received on Mon May 21 2001 - 10:12:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US