Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

OraOLEDB.Oracle Connection Expand / Collapse
Author
Message
Posted Thursday, February 14, 2013 3:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 13, 2013 9:18 AM
Points: 6, Visits: 33
I had a nightly SSIS package running on Server 2008 R2 that used the Oracle Provider for Ole DB. We have the Oracle Database as a linked server and the package was running fine. One night a couple of weeks ago, we got a error that the SQL server could not initialize the data source object of Ole DB Provider "OraOleDB.Oracle" for linked server "NAME". Microsoft SQL Error 7399.

We had put a patch on the evening before and attributed that to getting the error. We unistalled Oracle and reinstalled it and set up the TNSNames file again. And the package started running again.

Last night, the same thing happened, however, I have been told that no changes were made to the SQL server or to Oracle.

Has anybody else had this issue and knows what causes this? Obviously to fix it, we will uninstall Oracle and reinstall it, however, we need to know how to prevent this from happening in the future.

Thanks for any help.
Post #1420325
Posted Friday, February 15, 2013 2:02 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:56 PM
Points: 1,395, Visits: 6,618
Did the oraclemts service stop running? Do you have the latest oracle client?
Post #1420757
Posted Friday, February 15, 2013 2:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 13, 2013 9:18 AM
Points: 6, Visits: 33
No, the oraclemts service did not stop running and we have Oracle 11.2.0

Thanks.
Post #1420777
Posted Saturday, February 16, 2013 3:30 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:56 PM
Points: 1,395, Visits: 6,618
We had a strange cause oracle transactions failing after sometime.
It was fixed with a reboot of the server after an installation of the 11.2 client (for the post reboot file replacements). Without the reboot, the old oracle client (10) somehow lived on.
Another thing might be the non-sqlserver memory pool in ms sql server,
which is used by in-process extensions like the oracle linked server (startup option -g), but that was in the year 2000
Post #1420877
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse