Welcome to OracleGiants.com!     

Oracle 10g DBA & Business Intelligence Resources.

Transparent Application Failover

Ensure your Application Servers are using proper failover in TNSNAMES.ORA files

First off with Oracle 10g RAC, clients should be using the Virtual IP (VIP) as the connection target for failover purposes. Ensure you are NOT using the public IP.

Additionally a Transparent Application Failover (TAF) entry must be present in the TNSNAMES.ORA.

Use the following example TNSNAMES.ORA entry to ensure your TAF entry is setup properly:

PROD =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = vip1.oraclegiants.local)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = vip2.oraclegiants.local)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = vip3.oraclegiants.local)(PORT = 1521))
  (LOAD_BALANCE = yes)
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = PROD)
  )
)

 

Use Xattr CloudFiler™ to dedup, encrypt and move your RMAN backups to the cloud.

Recent Posts

This site recommends Burleson Consulting for DBA Support & Consulting.

We are currently paying for accepted Oracle 10g DBA & Business Intelligence articles, scripts, tips & tricks. Send yours to the editor and we will review within three weeks.

Learn more

Editorial submissions & questions: editor@oraclegiants.com

 

 

This site is moderated by an:
Oracle Certified Professional
Oracle ACE

 

  Classic Car Online - The #1 spot for classic and muscle car enthusiats
2010 OracleGiants.com