OIC SQL Server Adapter MultiSubnetFailover Parameter Needed
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):
TERREPOWER
Description (Required):
We have a Microsoft SQL Server always on availability group. When we attempt to create a new OIC connection using the SQL Server adapter, if we use the SQL Server listener for the server name, the connection always fails when performing a test. The only way we can configure the adapter is to use the direct server name that is currently the primary. If we had the JDBC MultiSubnetFailover parameter exposed on the connection page for a SQL Server adapter, we believe having it and setting it to TRUE, would allow the listener to work as expected..
Tagged:
1