Re: listener on a second machine using the same SID

From: <fitzjarrell_at_cox.net>
Date: Tue, 26 Jun 2007 05:06:23 -0700
Message-ID: <1182859583.324243.143890@p77g2000hsh.googlegroups.com>

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

Why would it? The ADDRESS specifies where the listener is located and where it is listening; since the IP addresses are not the same this won't be a problem. If it were Data Guard wouldn't function.

David Fitzjarrell Received on Tue Jun 26 2007 - 07:06:23 CDT