How to connect to the Secondary SQL Server database when the Primary SQL Server database is on Maintenance using DG4MSQL ?
(Doc ID 2699053.1)
Last updated on SEPTEMBER 07, 2020
Applies to:Oracle Database Gateway for SQL Server - Version 188.8.131.52 and later
Information in this document applies to any platform.
Q1 - Running Oracle Database Gateway for SQL Server connecting to a SQL Server database configured in MultiSubnetFailover=True.
Does Oracle Database Gateway for SQL Server support SQL Server failover?
Q2 - There is a planned SQL Server maintenance activity . During the maintenance, the Primary SQL Server would be offline and Secondary SQL Server would be online, and Oracle gateway should automatically connect to secondary SQL Server server.
Is there a workaround for this?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document