SOA Cluster High Availability for DB Adapters - Findings

SOA 11g version: 11.1.1.5

DB Adapter:

1. Create a Datasource

2. Create a Connection pool

Steps: SOADomain -> Deployments -> DbAdapter -> Configuration -> OutboundConnectionPools -> Create 'New" connection pool.

3. Save and Activate the changes. At this point if you observer 'DbAdapter' is in 'Prepeared' state. We have to update the 'Dbadapter' by selecting the changed 'Plan.xml'.

4. When try to update and deploy the 'DbAdapter'. It will fail saying 'Location for 'Plan.xml' is not found.

Solution: Change the location of the Plan.xml from its original location in '$ORACLE_HOME/Oracle_SOA1/soa/connectors' to '$SHARED_LOCATION/Dbadapter/'

Updated the DbAdapter and target to soacluster and activate the changes.

Still the 'DbAdapter' is in 'prepared' state.

Restart the managed servers. Now you will see the 'DbAdapter' in Active State.