Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to connect to multiple instances ?
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>...Received on Tue Mar 03 1998 - 00:00:00 CST
|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
|
|