Re: how to connect to 2nd instance

And for NT ( or other windows)
use
SET ORACLE_SID=sidname
before running the tool;

Rafal Jank <yankee_at_wp-sa.pl> wrote:

>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?
>I don't know which OS you use, but under linux try
>export ORACLE_SID=name_of_your_second_instance
>and then run svrmgrl
>Rafal
Received on Mon May 21 2001 - 10:24:26 CDT