How about one listener listening to two IPs. I have
the following working in a development area:
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= db1))
(ADDRESS= (PROTOCOL= IPC)(KEY= db1.world))
(ADDRESS= (PROTOCOL= IPC)(KEY= extproc0))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= dbsrvr01)(Port=1521))
(ADDRESS= (PROTOCOL= TCP)(Host=
dbsrvr01b)(Port=1521))
)
- 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.
> > >
> > > If you configure listener.ora file so that
> HOST=x.y.z.001, or
> > > HOST=x.y.z.002
> > > that listener listens to that ONE IP only.
> However, if you put
> > > HOST=oracle.acme.com in listener.ora than it
> listens to all IPs (in
> > > netstat
> > > -an you see that it is listening to "*.1521"
> instead of to
> > > "oracle.acme.com.1521"). That would mean that
> oracle does not
> > > resolve DNS
> > > at replaces it with IP but first checks whether
> this is the primary
> > > IP for
> > > that box.
> > >
> > > So, once we have put HOST=oracle.acme.com, all
> the connections were
> > > OK
> > > (coming from clients with tnsnames files that
> are pointing to old
> > > oracle1.acme.com and oracle2.acme.com) Of
> course DNS was changed..
> > >
> > > Anybody has come across this undocumented
> feature ? Any explanation
> > > to that
> > > ?
> > >
> > > Djordje
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author: Djordje Jankovic
> > > INET: djankovic_at_corp.attcanada.ca
> > >
> > > 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).
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Check out Yahoo! Shopping and Yahoo! Auctions for
> all of
> > your unique holiday gifts! Buy at
> http://shopping.yahoo.com
> > or bid at http://auctions.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.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).
> >
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Djordje Jankovic
> INET: djankovic_at_corp.attcanada.ca
>
> 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).
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at
http://shopping.yahoo.com
or bid at
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mohammed bhatti
INET: mkb125_at_yahoo.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).
Received on Wed Dec 12 2001 - 09:20:46 CST
