For more information regarding the security incident at F5, the actions we are taking to address it, and our ongoing efforts to protect our customers, click here.

Forum Discussion

Patcha_164590's avatar
Patcha_164590
Icon for Nimbostratus rankNimbostratus
Jul 23, 2014

Oracle/F5 can't connect after fail over

I'm DBA and new to F5. We are doing POC if F5 can redirect IP after Oracle data guard fail over. The applications config files hard code database ip in config files and want to keep the same ip after...
availability
BIG-IQ
deployment
oracle
Chris_Akker_129's avatar
Chris_Akker_129
Historic F5 Account
Jul 23, 2014

Hi Patcha, no IP re-routing needed.

 

You just need to follow the instructions for "Priority Group Activation" of pool members, contained in the LTM and RAC deployment guide. The example in this guide is for RAC Primary to Standby cluster failover, but the same concepts/principles apply to DataGuard Active/Standby role changes. Just modify the DB health monitor SQL query to look for the current DataGuard Role status of both DB servers, so LTM can determine which pool member is UP. If the application is hard coded to a single IP address, this is the only way practical way to do this efficiently with LTM.

 

You can find the details here:

 

http://www.f5.com/pdf/deployment-guides/oracle-rac-database-ltmv11-dg.pdf

 

Good Luck !

 

-Chris.