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 failing over. F5 was configured when primary database is switched or failed over, then the applications will reconnect data guard server. The applications just re-connect to data guard db since F5 will redirect to data guard server. Before fail over, the applications can connect to primary db with F5 ip. After performing fail over procedure and my network admin disable primary db in F5, I received ORA-12547: TNS: lost contact when trying to connect to database. Is there a documentation to deploy ip rerouting?

 

Thank you

 

availability
BIG-IQ
deployment
oracle

2 Replies

  • 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.