Dear,
We are running SOA 11.1.1.7 on top of weblogic 10.3.6.
We have multiple datasource connectivity to surrounding system.
Once of the surrounding system is moving to DR Environment during weekend hence we need to update datasource connectivity to there DR Database.
Issue is DR database is single instance however we have created Gridlink datasource in SOA as there production database is RAC.
We need to know below.
- Can we update Grid link datasource to point to single instance DB during DR and revert to Original entry after DR. Below is the single URL which we will be updating.
jdbc:oracle:thin:@10.247.26.17:1567/SERRAC.dib.ae
-
Can this be done online without restart of SOA Managed Servers.
-
If we just untarget the datasource , update datasource URL to point to DR DB and target again will this work.
I tried above in UAT and it worked.