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
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?
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"
}