none
Linked Server Issues

    Question

  • I have been running a stored procedure that accesses an Oracle database using an OpenQuery string on SQL 2008 R2 (server is MS Windows Server 2008 R2 64-bit running virtualized).  I have 2 seperate databases, Development and Production, that use the same linked server in the same SSMS instance.  The stored procedure has been running successfully on the Development database hourly for a number of weeks.  When I tried to start running the SP on the Production database I received the following error (where F21_YAS is the linked server). 

    =======================================================

    Msg 7399, Level 16, State 1, Line 1

    The OLE DB provider "OraOLEDB.Oracle" for linked server "F21_YAS" reported an error. The provider did not give any information about the error.

    Msg 7330, Level 16, State 2, Line 1

    Cannot fetch a row from OLE DB provider "OraOLEDB.Oracle" for linked server "F21_YAS".

    ========================================================

    In troubleshooting I found that the same query would fail on the Development database if it was not run as a SP.  When I run the query on my personal computer, with a linked server set up to the same Oracle database, it runs successfully.  I also have other linked servers set up on the Development and Production databases to other Oracle databases that run succesfully. I was not able to see this specific issue in any of my forum searches, any guidance would be appreciated.

    Thursday, June 07, 2012 3:09 PM

Answers

All replies