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

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Wed, 17 Sep 2003 10:44:59 -0800
Message-ID: <F001.005D03E3.20030917104459@fatcity.com>

I'm not real up on this stuff, but here is an example (I think) of a tnsnames.ora file. It's possible (not sure) you might have to configure listener and/or database for the SERVICE_NAME part.

Assuming XYZ1 is the instance name ....

In local tnsnames.ora, have:

XYZ.world =
  (DESCRIPTION_LIST=
    (DESCRIPTION=

      (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.253.11)(PORT=1526))
        (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.253.12)(PORT=1526))
      )
      (CONNECT_DATA=(SERVICE_NAME=XYZ.world))

    )
    (DESCRIPTION=

      (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.253.11)(PORT=1526))
        (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.253.12)(PORT=1526))
      )
      (CONNECT_DATA=(SERVICE_NAME=XYZ.world))

    )
  )

In the initXYZ1.ora file, have:

service_names = XYZ

In the listener.ora file, have:

LIST_XYZ1_1 =
(ADDRESS_LIST=(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(HOST=192.168.253.
11)(PORT=1526)))
LIST_XYZ1_2 =
(ADDRESS_LIST=(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(HOST=192.168.253.
12)(PORT=1526))) SID_LIST_LIST_XYZ1_1 =
(SID_LIST=(SID_DESC=(SDU=4096)(GLOBAL_DBNAME=XYZ.WORLD)(SID_NAME=XYZ1)(ORACL
E_HOME=/oracle/app/oracle/product/9.2.0))) SID_LIST_LIST_XYZ1_2 =
(SID_LIST=(SID_DESC=(SDU=4096)(GLOBAL_DBNAME=XYZ.WORLD)(SID_NAME=XYZ1)(ORACL
E_HOME=/oracle/app/oracle/product/9.2.0)))

> -----Original Message-----
> From: mike mon [mailto:mccdba_at_yahoo.com]
> Sent: Wednesday, September 17, 2003 11:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: [Q] ORACLE 9iR2 two ethernet cards, two listeners auestions?
> 
> 
> 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: Stephen Lee
  INET: Stephen.Lee_at_DTAG.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).

Received on Wed Sep 17 2003 - 13:44:59 CDT