Re: How does Oracle Server determine what protocol to use when faced with multiple types?

You'll have to hardcode the IP address into the LISTENER.ORA file. Otherwise TNSListener is going to ask the o/s to translate the name into an address, and if it's using DNS and/or WINS, it's really quite difficult to make it pick a specific interface.

If you're using DNS, you can create an additional name for the desired interface (say, "oracle_listen" if the server's name is oracle now), and use that. That way the IP address can be changed without have to change the LISTENER.ORA file. Just remember that the clients will have to make their connections to that address as well, not the main one for the server.

The ideal configuration though is to just set it up to listen on _both_ interfaces and let the clients connect to whichever one is more efficient for them.

rptracy_at_my-dejanews.com wrote in message <6rkqll$hte$1_at_nnrp1.dejanews.com>...
>Oracle server 7(NT os) running on a net server with both Token ring and
>Ethernet pci cards. When I specify the host name in the listener.ora file,
>the listener defaults to the ethernet ip. I want it to default to the
token
>ring ip. Without hard coding the ip, how can I do this?. Assume that NT
>bindings are all correct, and wins is disabled on the ethernet card.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Aug 21 1998 - 17:42:44 CDT