Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: listener on a second machine using the same SID

Re: listener on a second machine using the same SID

From: EdStevens <quetico_man_at_yahoo.com>
Date: Tue, 26 Jun 2007 05:10:42 -0700
Message-ID: <1182859842.314225.304760@m36g2000hse.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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US