Forum Discussion

NK_50834's avatar
NK_50834
Icon for Nimbostratus rankNimbostratus
Aug 09, 2012

Issues with BIH-IP LTM for Oracle Database:

Here is what I've done: 1. created an Oracle health monitor   2. created nodes for each host (2 in this case [x.y.z.152, x.y.z.154] )   3. created an oracle pool with both the members in it   4....
oracle
partner
NK_50834's avatar
NK_50834
Icon for Nimbostratus rankNimbostratus
Aug 10, 2012

Thanks for you response Chris..

 

 

 

Below are my responses to your comments:

 

 

 

Hi NK. From first look and the ORA-12545 error message, it would appear that the instance name is incorrect/does not match. When using RAC, the first Node could be "primary1", the second Node "primary2", etc. The switch_map in the iRule must be updated to match the instance names and the correct Node IP Addresses.

 

 

We are NOT in a RAC environment. The sid for both the primary and physical standby (on a different m/c) is same.

 

 

 

 

 

Also, as a troubleshooting step, try removing the iRule from the virtual server, and disable the second Node in the pool, to find out what instance names are registered/work on Node 1 by itself. Then reverse the process, only enable Node2 in the pool, and see what works. I know it might sound simplistic, but with RAC clusters, the details can be tough to pin down sometimes.

 

 

 

Aug 10 10:42:21 pscsb11F5 mcpd[729]: 01070641:3: Node 10.136.100.154 session status enabled.

 

Aug 10 10:42:33 pscsb11F5 mcpd[729]: 01070640:3: Node 10.136.100.154 monitor status up.

 

Aug 10 10:42:43 pscsb11F5 mcpd[729]: 01070641:3: Node 10.136.100.152 session status enabled.

 

Aug 10 10:42:55 pscsb11F5 mcpd[729]: 01070640:3: Node 10.136.100.152 monitor status up.

 

Aug 10 10:48:48 pscsb11F5 mcpd[729]: 01070638:3: Pool member 10.136.100.152:1521 monitor status up.

 

Aug 10 10:48:48 pscsb11F5 mcpd[729]: 01070639:3: Pool member 10.136.100.152:1521 session status disabled.

 

 

 

Aug 10 11:08:

 

 

12 tmm tmm[732]: 01220001:3: TCL error: Rule instance-switching-irule - list must have an even number of elements while executing "array set switch_map { "odyssey" "10.136.100.154" "odyssey" "10.136.100.152" "paradox2" "10.136.100.152" "paradox" ..."

 

 

 

 

 

 

I hope this should help you point me in the right direction.

 

 

 

Thanks for your help.

 

 

 

regards,

 

NK