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: Kurt <hbxiao_at_msn.com>
Date: 21 May 2001 10:37:32 -0700
Message-ID: <df897fb4.0105210937.66139aa1@posting.google.com>

"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

You need set $ORALCE_SID before you invoke SQL*Plus to connect to the local databases other than your "default db"

On UNIX(sh, ksh) it is:
ORALCE_SID=xxx; export ORACLE_SID

then sqlplus xxx/xxx

HTH.
>
> I will be automatically connect to instance #1. How can i connect to the
> second instance?
Received on Mon May 21 2001 - 12:37:32 CDT

Original text of this message

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