Forum Discussion

Nimbostratus

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

Nimbostratus

Aug 14, 2012

I have a lot of small to mid-sized stand-alone databases, & apart from DR providing HA via DG is our goal.

In order for applications to continue working even after switch-over w/o any changes to connect strings- I set-up the physical standby with the same SID, (db_unique_name and service are different).

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 prioirity 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.

I do have it set up as suggested - odyssey_pool has both the primary& phys-standby nodes and primary has high priority (100) and standby has low (1). (Attached is the screen shot). I had disabled the standby node for debugging. I want to see if atleast the request is sent over to the primary member of the pool via the virtual server...

~~regards,~~