Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

The provider ran out of memory.

878418Jul 27 2011 — edited May 31 2013
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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 28 2013
Added on Jul 27 2011
1 comment
3,211 views