I have installed the Oracle 11g client on all the nodes on the cluster and the binaries exist on the same location on all nodes. Also I make the TNS...

I added the linked server using your query but when trying to explore the objects from linked server it is giving me the below error.

Msg 7302, Level 16, State 1,...

The Windows version is 2003 server with SP1. I am connecting to Oracle 11g Database server and I already installed the Oracle 11g client software on all nodes. I tested...