RE: Listeners listening to multiple IPs

Ditto.

In addition, DNS will use multiple IP's in a round robin fashion as a crude form of load balancing.

Jared

                                                                                       
                             
                    Rachel                                                             
                             
                    Carmichael           To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>        
                    <wisernet100_at_y       cc:                                           
                             
                    ahoo.com>            Subject:     RE: Listeners listening to 
multiple IPs                       
                    Sent by:                                                           
                             
                    root_at_fatcity.c                                                     
                             
                    om                                                                 
                             
                                                                                       
                             
                                                                                       
                             
                    12/11/01 10:41                                                     
                             
                    AM                                                                 
                             
                    Please respond                                                     
                             
                    to ORACLE-L                                                        
                             
                                                                                       
                             
                                                                                       
                             

well yeah...

that's the whole point of USING DNS, so that it will work like that

• Djordje Jankovic <djankovic_at_corp.attcanada.ca> wrote:
  > I am not talking whether putting DNS entry works, but am just
  > pointing to
  > the fact that oracle behaves differently if you put hardcoded IP - it
  > than
  > listens to one IP only, and if you put the dns name - listens to all
  > IPs.
  >
  > Djordje
  >
  > > -----Original Message-----
  > > From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
  > > Sent: Tuesday, December 11, 2001 11:50 AM
  > > To: Multiple recipients of list ORACLE-L
  > > Subject: Re: Listeners listening to multiple IPs
  > >
  > >
  > > it's not so much a feature of the listener as it is of DNS as far
  > as I
  > > know. One of the reasons it's best not to hard-code IP addresses
  > into
  > > the listener.ora is because when you do a failover, or
  > > combine machines
  > > as you have, the listener.ora and tnsnames.ora files need to be
  > > updated.
  > >
  > > If you use DNS and let the DNS server resolve the address, you
  > don't
  > > have to change anything.
  > >
  > > This has been around for as long as I can remember using the
  > listener,
  > > which means going back to version 6
  > >
  > > Rachel
  > >
  > > --- Djordje Jankovic <djankovic_at_corp.attcanada.ca> wrote:
  > > > Something I learned today, but haven't seen it documented
  > anywhere
  > > > and would
  > > > like to see whether anybody has come across it.
  > > >
  > > > We have a Sun server (call it oracle.acme.com). It came to life
  > by
  > > > combining two machines (oracle1.acme.com and oracle2.acme.com).
  > So
  > > > now it
  > > > has two IP addresses: hme0: x.y.z.001 - from oracle1 and hme1:
  > > > x.y.z.002 -
  > > > from oracle2. There are few databases there (some of them were
  > on
  > > > oracle1
  > > > some on oracle2) and one listener listening to all of them.
  > > >
  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).