Re: listener on a second machine using the same SID

On Jun 26, 8:10 am, EdStevens <quetico_..._at_yahoo.com> wrote:
> On Jun 26, 5:36 am, Michael Pye <mich..._at_ulimit.org> wrote:
>
> > I'm planning to bring up a new oracle 9.2.0.5 (solaris 10) instance
> > using the backup of an existing oracle instance, on the same network but
> > on a different machine/ip address.
>
> > So there will be two physical machines on the same subnet, both running
> > a listener configured with the same SID and have the same datafiles. As
> > long as clients are still using the original IP address this shouldn't
> > present a problem should it ? I'm told that it's possible the 2nd
> > listener will interfere with the primary machine listener because it
> > uses the same database/SID. Is this possible ?
>
> > --
> > Michael
>
> yes, and as long as you are careful with your name resolution
> (tnsnames) it poses no real problem. In a default, out of the box
> installation the LISTENER section of your listener.ora file specifies
> which host the listener is listening.
>
> Now, while it is possible, is it desireable? That's a bit more of a
> religious issue, which I'll not address here

Michael, you should really be using service names instead of SID's but you can have the same SID name used on more than one location. If is probably not a great idea but it will work. It is also likely to cause confusion down the line as someone tries to connect to the right SID at the wrong address.

HTH -- Mark D Powell -- Received on Tue Jun 26 2007 - 08:38:43 CDT