Re: how to connect to second instance

"Woodstock" <woodstock1172_at_yahoo.com.sg> wrote in message news:<9eb94a$39c$1_at_coco.singnet.com.sg>...
> 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 woodstock,

Letz take a small example. Let us call Instance 1 as one and Instance 2 as two.

By default the db will be connected to one. If you want to connect to instance 2 follow the following steps.

If you are working in Unix environment (say ksh)

$ export ORACLE_SID=two
type svrmgrl
then connect internal

select name from v$database ;

this should return instance name two.

If you are using windows mac

SET ORACLE_SID=two

Hope you are clear

Balaji Received on Mon May 21 2001 - 14:10:25 CDT