Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: how to connect to 2nd instance
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 - 08:49:29 CDT
![]() |
![]() |