March 29, 2012 at 12:51 am
Dear All,
I need your help.
I have one production server working on environment Windows Server 2008 (32 bit) with SQL Server 2008 R2 Service pack 1 CU4 (32 bit).
We have created one link server to Oracle 9i server.
I migrated my 2000 database to 2008. I have created link server also.
But after that I am facing a very serious problem.
Sometimes my SQL server stop automatically and when I checked in error log I found stack dump in that. And event viewer log shows me following errors.
SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
The OLE DB provider "MSDAORA" for linked server "IIS" reported an error 0x80004005 aborting the current transaction.
Can anyone please help me on this.
April 2, 2012 at 3:43 am
No-one else has picked this up, which often means there is little expertise available for this aspect of SQL Server.
You should not have a SQL Server crash because of a problem with a relatively minor component such as Oracle OLE. At worst, the problem should be restricted to the Oracle connection - but it should definitely not cause the SQL instance to crash.
You should try Googling the error messages you are seeing in the SQL dump log to see if there is a known solution to the problem. Otherwise, my advise is to open a case with Microsoft - they have people paid to help you in this situation.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply