Re: SQL*Net and Multi-Homed Hosts

From: Contractor - Yuktton <jychan_at_corp.hp.com>
Date: 1995/06/21
Message-ID: <3sa6k0$d0d_at_hpcc48.corp.hp.com>#1/1


Tony Cook (TCook) wrote:

: Can SQL*Net (version 2) handle a host that has more than one network
: interface?
 

: eg.
: myhost has two ethernet interfaces.
: Interface 1 has address 123.456.789.1
: Interface 2 has address 123.456.789.2

i have not tried this before specifically on v2, but i have done this on v1 and don't see why there would be a problem. basically, there would be two listeners, each listening on one ip address (or hostname).

: When I issue a 'connect' to myhost, is SQL*Net smart enough to attempt
: to connect to the second address if the first is unreachable?

i don't think so, though i guess it would not be too difficult to write some initialization code to do a failover.

jc Received on Wed Jun 21 1995 - 00:00:00 CEST

Original text of this message