Re: [Q] ORACLE 9iR2 two ethernet cards, two listeners auestions?

You do not need two addresses.
The parameter address_list really means what its name applies. You can have two addresses in a single listener. Just put in the host= the tcp/ip address of each network card.

The same applies also to tnsnames.ora. You can write two addresses in the address_list parameters.

See oracle 9i net services reference guide, chapter protocol address configuration.

Yechiel Adar
Mehish
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, September 17, 2003 6:04 PM

> We have SUN ultra Sparc server with two Gigabit
> Ethernet cards on
> it. Those two Ethernet card will connect to "big
> IP" (firewall/router). The reason we need two Gigabit
> Ethernet cards is
> securiyt (in case one card fail). I know I can
> configure
> two listener entries on "listener.ora" like:
>
>
> listener1=
> (address_list=
> (address= (protocol=tcp) (host=ip1)
> (port=1521)))
>
>
> listener2=
> (address_list=
> (address= (protocol=tcp) (host=ip2)
> (port=1521)))
>
>
> Is their has way to condifure PC tnsnames.ora file to
> make it automatic
> switch to another entry while one Ethernet card fail?
> For example
> Ethernet card (listener1) fail and PC can automatic
> use listener2.
>
> Our envirnoment is ORACLE 9ir2, but NOT RAC.
>
> Thanks
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: mike mon
> INET: mccdba_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).