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, I guess we need to know more about your database environment, so it woud help if you could describe what you have and what you are trying to do in detail.
My previous suggestions were based on the assumption that you were using Oracle RAC. The RAC load balancing deployment guide and iRules are for RAC clusters with two or more RAC Nodes. If you are trying to load balance standalone databases, it will not work. The Standby database will never pass the SQL health check, because it is not in the OPEN state - as shown by the last "Pool member ... sessin status disabled" log message.
However, if you have standalone database servers, and are trying to use LTM to automate the TCP connection failover, you could use the priority group activation feature. You could have the Prinary database server in the high prioirty group, and your Standby database in the low priority group, and set up the failover to use that feature. This woud be one pool with 2 priority levels. The iRule is not needed for this.
The iRule debug log statement that you included, the "list must have an even number of elements..." error. It appears you have the name odyssey with two different IP addresses - .152 and .154. This will not work, the array must contain unique key-value pairs.
So I think the architecture you have is different than what the deployment guide and iRules were written for. So plz explain what you have and what you want to accomplish so we can make better suggestions.
Thanx,
Chris.
