[URGENT - PRODUCTION ISSUE]
All of a sudden, on a SQL Server 2005 instance, all the Linked Servers to Oracle stopped working. All other instances can connect to the linked servers without a problem using identical configurations.
When I right-click and "Test connection", I get:
Cannot initialize the data source object of OLE DV provider "OraOLEDB.Oracle" for linked server "servername". OLE DB provider "OraOLEDB.Oracle" for linked server "servername" returned message "*gibberish characters here*" (Microsoft SQL Server, Error: 7303)
The error is different gibberish characters every time I test the connection. (Squares and unreadable characters). I am using the Oracle ODAC 10 client on the SQL Server. Any ideas on how to fix this other than restarting the instance?