Re: how to connect to 2nd instance

From: Silvio Seifert <silvio.seifert_at_gmx.net>
Date: Thu, 24 May 2001 15:36:51 GMT
Message-ID: <9ej9f2$frt$05$2@news.t-online.com>

svrmgrl has an "set instance <SID>" command. Use this, then you have not to exit the tool. Ofcourse, your TNS should be set up correctly ..

Best Regards,

Silvio

On Mon, 21 May 2001 22:11:20 +0800, "Woodstock" <woodstock1172_at_yahoo.com.sg> 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?
>
>

Silvio Seifert
Foehrer Strasse 34
65199 Wiesbaden
Germany Received on Thu May 24 2001 - 10:36:51 CDT