well yeah... that's the whole point of USING DNS, so that it will work like that
--- Djordje Jankovic <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > > 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).