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

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.

Thanks. 
Keeran kumar

Answer 1

Reference considerations-for-non-sql-server-subscribers firstly.

Answer 2

Hi,

Already referred the link. But still facing issue.

Answer 3

Ok.Let's take a look at your replication configuration slowly.
How do you configure your replication and what are their versions?Not all versions are suitable for this heterogeneous configuration.Note this:heterogeneous-database-replication

Try to configure replication by referencing:configuring-heterogeneous-database-replication-sql-server-to-oracle

Answer 4

Hi 

Please check my details

SQL Server 2016 SP2 instance(Publisher & Distributor),

Oracle Subscriber (Oracle Database 12102)

Oracle client 12c1 Full client.

Through SQLPlus & ODBC 64bit able to connect to Oracle database from Distributor server.

But during adding subscriber showing Invalid operation.

Answer 5

Do you reference the response from MartinBH in this case:"Invalid Operation" when adding Oracle subscriber to SQL Server 2016 replication publication?

---

If your issue is solved.Mark the helpful reply as answer to close your case.Otherwise, your case will always be in the open state.