RE: Listeners listening to multiple IPs

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 11 Dec 2001 10:52:18 -0800
Message-ID: <F001.003DA259.20011211104109@fatcity.com>

I used to define it on localhost (127.0.0.1) and this worked great with all ip addresses (only on Solaris).

Did not work on NT!

Regards,

Waleed

-----Original Message-----

Sent: Tuesday, December 11, 2001 9:40 AM To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.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