My Oracle Support Banner

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 12.1.0.2 and later
Information in this document applies to any platform.

Goal

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?
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.