Forum Discussion
kazeem_yusuf1
Oct 12, 2017Nimbostratus
ORACLE RAC IRULE ISSUES (JDBC QUERY)
I need help on my Oracle Database VIP. It is configured and green,however,when a JDBC call is made to virtual Ip, there is TNS LISTENER ERROR. Part of my irule goes thus, service name is "tpp_n4"
when CLIENT_ACCEPTED { set last_service_name "tpp_n4"
Change to a non-zero number if your clients are specifying an
INSTANCE_NAME in their connect stings and you wish to remove it. This
allows you to have clients connect through the BIG-IP without the need
to worry which instance of your database the connection gets load-balanced
to. As a result, the individual nodes will not reject a connection
because of a Instance Name mismatch.
set remove_instance_name 0
Map service names to the pool on which they run.
Use lower case instance names since arrays are case-sensitive and we are
converting everything to lower case when we do comparisons later on.
array set switch_map {
"tpp_n4" "ORACLE_11G_PRIMARY"
}
TCP::collect
}
- keithhubbEmployee
Just curious, did you follow the Oracle RAC deployment guide when you created the virtual server?
Recent Discussions
Related Content
DevCentral Quicklinks
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com
Discover DevCentral Connects