Invalid operation. The connection is closed. - when adding Oracle subscriber to SQL Server 2016(13.0.5102.14) replication publication" RRS feed

  • Question

  • Hello,

    I am  facing the issue when I try to add Oracle subscriber to SQL Server 2016 replication publication.

    I have installed Oracle 19.0.0 full client on Distributor server.

    Through SQLPlus I can able to connect to Oracle Database successfully.

    Also through ODBC 64 bit DSN test connection done successfully.

    I have given Read & Exec permission to the SQL Server Distributor Agent account.

    TNSPing command also verified successfully.

    But when I try to add Data Source Name in "Add non SQL Server Subscriber under "New Subscriber Wizard" it is giving error like "Invalid operation. The connection is closed."

    Please suggest.

    Keeran kumar

    Thursday, July 23, 2020 7:11 AM

All replies