Help - Search - Members - Calendar
Full Version: tnsnames.ora with 2 servers
Oracle DBA Forums > Oracle > Oracle Forum
gutopmc
Is there a way to put on tnsnames.ora the alternative IP of a server that if the first dont respond it tries the ip of the second?
Example:

ORA92 =
(DESCRIPTION =
(ADDRESS_LIST =
try
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521))
except
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.2)(PORT = 1521))
end
)
(CONNECT_DATA =
(SERVICE_NAME = tsh1.world)
)
)
burleson
Hi,


>> the alternative IP of a server that if the first dont respond it tries the ip of the second?


Good question!

Yes, it's called TAF:

http://dba-oracle.com/googlesearchsite_pro...UTF-8&q=taf
gutopmc
Thanks for the reply! Does TAF works with oracle 9i?

QUOTE (burleson @ Jan 31 2012, 03:50 PM) *
Hi,


>> the alternative IP of a server that if the first dont respond it tries the ip of the second?


Good question!

Yes, it's called TAF:

http://dba-oracle.com/googlesearchsite_pro...UTF-8&q=taf

gutopmc
Heeelp! blink.gif
My client just started to use this solution today but Im having a problem. The user opens the ERP and it conects to Database1. He just closes it and opens again and it connects to database2. This supposed to happen only if database1 was offline. qhat is happening?

here is the tnsnames that im using:
ORA92 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.202)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = servidor)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 10)
(DELAY = 5)
)
)
)
burleson
Hi,

TAF was designed to work with RAC. there may be a bug.

>> The user opens the ERP and it conects to Database1. He just closes it and opens again and it connects to database2.

Your TNSNAMES looks file, it's not supposed to work that way.

You tested this in TEST before moving into production, right?

I would open an emergency service request with Oracle tech support:

http://support.oracle.com

If you say it's a production interruption issue, you get immeduate service.

They have the source code, you may have a bug here . . .


Let us know what they say!
dave
you have load balance = yes, you want load balance = no
gutopmc
QUOTE (dave @ Feb 29 2012, 09:40 AM) *
you have load balance = yes, you want load balance = no


Worked fine dave! THAAAAAANKS!!!! laugh.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.