Link server to oracle not working from one AG node

Question

Hi All,

I have a linked server to Oracle DB from SQL AG replicas. It was working without issues. For few days link server is not connecting from one replica.

I am able to ping the link server and telnet the port.

Restarted the replica.

Same version of Oracle OLEDB driver is present in both replicas.

Any clue about this error?

Thanks,

ACDBA

Answer 1

Is the provider configured to run in-process? If it is not, maybe you should check if there an instance of the provider running already, and possibly kill it.

You may have no choice but to restart SQL Server or the entire machine.

Answer 2

Hi @ACDBA,

Here is a same thread which mentioned several solutions, you may take a reference to.

Regards，

Zoe Hui

---

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