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:[EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
