I have an Oracle 11g r2 linked server. Its currently working for queries and stored procedures. However, when attemping to execute a stored procedure that pulls database from the linked server, we're getting the "ORA-12154: TNS:could not resolve the connect identifier specified". [SQLSTATE 01000] (Error 7412) Error.
I checked the error logs, the 'executed as user' has the correct rights through the linked server. I can test the connection and even run the stored procedure manually with this user. Any ideas?
Also, this is a bit bizarre, but if I check the 'Allow in process' for the Oracle OLE DB provider, it breaks the linked server.