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 multiple instances ?

Re: How to connect to multiple instances ?

From: Jim <jimmorgan_at_csi.com>
Date: 1998/03/03
Message-ID: <6dh10h$rf6$1@ausnews.austin.ibm.com>#1/1

If you're on AIX, you need to set ORACLE SID to the instance you want, then connect. You can only connect to one instance at a time, I believe. If you want to access two tables in two different instances you have to use dblinks.

-- 
Regards,
Jim
Valent Levente wrote in message <6dgfu9$e91_at_goliat.c3.hu>...

|I've set up two instances on a machine, but now I can only connect to
the
|first (orcl) instance.
|
|Where do I have to configure Oracle to accept connects to the 2nd
(lsft)
|instance ?
|
|I've tried to edit the listener.ora, but it wasn't successfull.
|
|--
|Levente Valent
|lsoft_at_szabinet.hu
|
|
Received on Tue Mar 03 1998 - 00:00:00 CST

Original text of this message

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