Assure DQ

The current working connection string to Oracle is formatted like this:
jdbc:oracle:thin:User=OurUserId/Password={Our Password}@ORAX3388:1521/ORAX3388

We are being asked by a DBA to make this connection which allows for ability to switch from one Oracle instance to an alternate disaster recovery Oracle instance; example below.  Is this possible using Wildfly 10 and if so, please provide an example connection string.

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=OFF)(FAILOVER=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ORAX3388.amfam.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=ORAX3388DR.amfam.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORAX3388)))

Hi Ellen,

The scenario you mention has not been tested at Infogix.

How does this Oracle feature handle active connections? If the Assure database connection is interrupted, it will need to be re-established via a JVM restart.

From a data standpoint, if the backup database is 100% identical, the change will be seamless to Assure as it would not know the difference. That being said, this also depends on how active connections are handled.

If the database is not 100% identical -- even a few seconds out of date -- then this will not work. There are many key dependencies that will become out-of-sync if the database is swapped to a different database while Assure is processing controls.

Matthew Kennedy