InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 19:59:50 GMT20http://www.sqlservercentral.com/Forums/Topic1369589-1044-1.aspxA reboot cleared this up.Mon, 08 Oct 2012 07:23:23 GMTjshurakhttp://www.sqlservercentral.com/Forums/Topic1369589-1044-1.aspxI 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 [code="sql"]"ORA-12154: TNS:could not resolve the connect identifier specified". [SQLSTATE 01000] (Error 7412)[/code] 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.Sun, 07 Oct 2012 19:33:50 GMTjshurak