Learn F5 Technologies, Get Answers & Share Community Solutions Join DevCentral

Filter by:
  • Solution
  • Technology
Clear all filters
Answers

Oracle Instance name switching using iRules

I am using this iRule http://www.f5.com/solutions/resources/deployment-guides/files/instance-switching-irule.txt to select the node based on the Oracle instance name provided on the client connection string.

When the command node $switch_map($instance_name) is executed it fails with the message: Address in use (line 1) invoked from within "node $switch_map($instance_name)". If I try LB::detach before running the node command the error does not happen, but the connection fails with ORA-12537: TNS:connection closed.

Any ideas about how to use an iRule to direct the connection to the specified RAC node?

Thanks, Marcelo

0
Rate this 0

Replies to this 0

placeholder+image

When the command node $switch_map($instance_name) is executed it fails with the message: Address in use (line 1) invoked from within "node $switch_map($instance_name)".

is it in middle of connection (server-side connection has already been established)?

0
placeholder+image

No. Nothing was sent to the oracle database server (I watched oracle listener log, and it did not receive any request).

The command node is inside the event CLIENT_DATA:

when CLIENT_DATA { if { [TCP::payload] contains "(CONNECT_DATA=" } { if { [TCP::payload] contains "(INSTANCE_NAME=" } { ... node $switch_map($instance_name) ...

Thanks, Marcelo

0
placeholder+image

Hi All,

I now this is a very old topic.....

Currently the links to download this irules in the F5 - Oracle deployment guide are broken. Could someone share both irules please?.

Note: In the pdf there are two links, load balancing Rac nodes by INSTANCE_NAME or by SERVICE_NAME. I need both of them.

Thanks in advance.

0