Forum Stats

  • 3,838,691 Users
  • 2,262,394 Discussions
  • 7,900,734 Comments

Discussions

The provider ran out of memory.

878418
878418 Member Posts: 1
edited May 31, 2013 4:57AM in Oracle Provider for OLE DB
I've got the following error message when running a job even if there is plenty of memory on the server (Windows Server 2008 R2, 64-bit, 32GB RAM, SQL Server 2005, 32-bit):

+Executed as user: NT AUTHORITY\SYSTEM. The OLE DB provider "OraOLEDB.Oracle" for linked server "SFA" reported an error. The provider ran out of memory. [SQLSTATE 42000] (Error 7399) Cannot execute the query "select * from INCHIDERE_LUNA" against OLE DB provider "OraOLEDB.Oracle" for linked server "SFA". [SQLSTATE 42000] (Error 7320). The step failed.+

The problem appears every 3-4 days and we restart the SQL server as a workaround.

Edited by: ionut on Aug 5, 2011 1:33 AM

Edited by: ionut on Aug 5, 2011 1:33 AM

Answers

This discussion has been closed.