SQL Server Performance

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle"

Discussion in 'SQL Server 2005 General DBA Questions' started by suedixon, May 31, 2009.

  1. suedixon New Member

    The linked servers on SQL Server stopped working Suddenly. Error message is below

    Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "<name>".

    It used to happen once a week, we added a "timeout" to the Oracleprovider, since then, it is happening once every month or two.

    One of the known solution is a full SQL Server restart. But restartingthe SQL server is not a viable solution all the time because of theserver usage times.

    Any one has any idea why the Oracle driver may do this?
    And if there is any other known fix?
  2. Sandy New Member

Share This Page