Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: listener on a second machine using the same SID
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 Received on Tue Jun 26 2007 - 07:10:42 CDT