Share via

Connection failover doesn't work with the MicrosoftSSISOracleConnector using tnsnames file and the first service is unaccessible

Dragana Popovic 5 Reputation points
2024-02-14T22:14:56.1466667+00:00

Hello, I have installed MicrosoftSSISOracleConnector-SQL22 v1.2 (64-bit) on Microsoft SQL Server 2022. Everything was working fine until I used failover=on in the tnsnames.ora and the first service in the list was unaccessible. It can be tested by creating new DSN using this driver and changing the order of the accessible and unaccessible services with failover=on parameter. When using the same list in the tnsnames.ora and the first service is accessible the connection is successful. Is it fixed in v1.3 or the issue is still present?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,670 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,564 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 36,116 Reputation points
    2024-02-15T01:38:40.3733333+00:00

    Hi @Dragana Popovic, I haven't found the release note for Microsoft Connector for Oracle V1.3. You may install the v1.3 for a try. Regards， Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

  2. Dragana Popovic 5 Reputation points
    2024-03-18T14:04:02.36+00:00

    The issue with failover not working while using TNS connection list, when the first node in the list is not accesible, is resolved in Microsoft Connector for Oracle V1.3 due to enhancement in:

    • Oracle Driver Upgrades - Upgrade driver version to 8.0.2.3072.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.