{"id":152,"date":"2011-05-03T12:37:56","date_gmt":"2011-05-03T12:37:56","guid":{"rendered":"http:\/\/eldar.pro\/?p=152"},"modified":"2019-07-18T20:16:11","modified_gmt":"2019-07-18T20:16:11","slug":"restarting-the-sql-server-service-due-to-error-oracle-provider","status":"publish","type":"post","link":"https:\/\/eldar.pro\/?p=152","title":{"rendered":"Restarting the SQL Server service due to error Oracle provider"},"content":{"rendered":"<p>OS version: Windows Server 2008R2 EE x64<br \/>\nSQL Server version: SQL Server 2008R2 x64 SP1<\/p>\n<p>Due to unspecified &#8220;Oracle provider for OLE DB&#8221; error twice restart SQL Server service.<br \/>\nAn entry in the Application log:<\/p>\n<p><em>01:46:12 PM Information SERVERNAME.domain.a 1001 Windows Error Reporting N\/A N\/A Fault bucket , type 0 Event Name: APPCRASH Response: Not available Cab Id: 0 Problem signature: P1: sqlservr.exe P2: 2009.100.2500.0 P3: 4dfb6221 P4: StackHash_6d63 P5: 6.1.7601.17725 P6: 4ec4aa8e P7: c0000374 P8: 00000000000c40f2 P9: P10: Attached files: C:\\Users\\username\\AppData\\Local\\Temp\\WERC049.tmp.appcompat.txt C:\\Users\\username\\AppData\\Local\\Temp\\WERCB13.tmp.WERInternalMetadata.xml C:\\Users\\username\\AppData\\Local\\Temp\\WERDDCA.tmp.mdmp C:\\Users\\username\\AppData\\Local\\Temp\\WERE22E.tmp.WERDataCollectionFailure.txt These files may be available here: C:\\ProgramData\\Microsoft\\Windows\\WER\\ReportQueue\\AppCrash_sqlservr.exe_acc33c1fca791edc578ecac2be501126d4755535_cab_64a1e249 Analysis symbol: Rechecking for solution: 0 Report Id: 15cbe2fd-ae2a-11e1-a618-3c4a927b0a88 Report Status: 0<br \/>\n01:46:12 PM Error SERVERNAME.domain.a 19019 MSSQL$SQL1 Server N\/A The MSSQL$SQL1 service terminated unexpectedly.<\/em><\/p>\n<p>Reason restart SQL Server is an access violation &#8211; heap corruption:<\/p>\n<p><em>STACK_TEXT:<br \/>\n00000000`00000000 00000000`00000000 oraoledbutl10!Unknown+0x0<br \/>\nFAILURE_BUCKET_ID: ACTIONABLE_HEAP_CORRUPTION_heap_failure_block_not_busy_AFTER_CALL_c0000374_OraOLEDButl10.dll <\/em><\/p>\n<p>To prevent this situation in the future, remove the property \u201callow in process\u201d Oracle provider, to the provider for a linked Oracle server work out of the process SQL Server:<br \/>\n<a href=\"\/\/eldar.pro\/wp-content\/uploads\/2012\/09\/Oracle_LS.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-139 aligncenter\" title=\"Oracle_LS\" src=\"\/\/eldar.pro\/wp-content\/uploads\/2012\/09\/Oracle_LS-300x269.jpg\" alt=\"\" width=\"300\" height=\"269\" \/><\/a><\/p>\n<p>Further, according to <a href=\"\/\/blogs.msdn.com\/b\/dataaccesstechnologies\/archive\/2010\/08\/19\/permissions-needed-to-set-up-linked-server-with-out-of-process-provider.aspx\">this article<\/a>, customize access to MSDAINITIALIZE.<\/p>\n<p>Now provider error &#8220;Oracle provider for OLE DB&#8221; will not lead to restart the SQL Server.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>OS version: Windows Server 2008R2 EE x64 SQL Server version: SQL Server 2008R2 x64 SP1 Due to unspecified &#8220;Oracle provider for OLE DB&#8221; error twice restart SQL Server service. An entry in the Application log: 01:46:12 PM Information SERVERNAME.domain.a 1001 Windows Error Reporting N\/A N\/A Fault bucket , type 0 Event Name: APPCRASH Response: Not [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"class_list":["post-152","post","type-post","status-publish","format-standard","hentry","category-s-sql-server-en"],"_links":{"self":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=152"}],"version-history":[{"count":1,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/152\/revisions"}],"predecessor-version":[{"id":379,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/152\/revisions\/379"}],"wp:attachment":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}