Forum Discussion
NK_50834
Nimbostratus
NimbostratusIssues 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....
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.
To help you out, there are quite a few "log local0." lines in the iRule to use for debugging. I would try uncommenting some of them out, and see if you can find out what/where the iRule is working/sending the TCP connection. The log local0. iRule messages are sent to /var/log/ltm.
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.
Let us know what you find !
-Chris
