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

Mohamed_Aziz_21's avatar
Mohamed_Aziz_21
Icon for Nimbostratus rankNimbostratus
Aug 06, 2015

How to use F5 to connect to multible SERVICE_NAMES

Hi

 

I'm new to F5 , we have the following scenarios:

 

  • we have about 4 databases , all are being serviced on port 1521 , with different service names
  • changing the port is not possible at this time

Please advise how to configure the F5 so that every connection coming from the each database instance is correctly redirected to its same database again

 

If you can provide the steps , will be much appreciated

 

Thanks

 

2 Replies

  • Kevin_Stewart's avatar
    Kevin_Stewart
    Icon for Employee rankEmployee
    Aug 06, 2015

    While you could technically do this, I can almost guarantee you're not going to like how you'd have to do it. In short, what you're talking about is parsing a binary protocol and looking for some data in that protocol (in every request) for something that is unique to a given database. Depending on the type of SQL you're talking about, that's not always possible and never easy.

     

    Is there ANY way that you can use different destination IPs? Something outside of the protocol itself to differentiate traffic?

     

  • Stanislas_Piro2's avatar
    Stanislas_Piro2
    Icon for Cumulonimbus rankCumulonimbus
    Aug 10, 2015

    Seriously, did you google before creating the thread? To help you, i search "F5 oracle service_name"... and 30 seconds later, I found in the F5 Deployment guide of Oracle the following link:

    https://www.f5.com/solutions/resources/deployment-guides/files/service-name-switching-irule.txt

    You can change the array definition with service names and pools....

    array set switch_map {
    "ccards"   "ccards-db_pool"
    "hr"       "hr-db_pool"
    "product"  "product-db_pool"
}