Re: How to connect to multiple instances ?

you need to edit the listener to connect to the second database when the appropriate sid is received. You need to edit tnsnames.ora on the client to specify a new alias for the second instance.

Valent Levente wrote:

> 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

--
To reply, remove the "<nospame>" from the address.

Marcel Kates
Digital Equipment Corporation  Voice: 1-978-506-3743
Multivendor Systems Engineering DTN:      226-3743
153 Taylor Street  TAY2-1/H14 FAX:   1-978-506-3576
Littleton, MA 01460-1407  DTN:      226-3576
United States of America