{"id":416,"date":"2013-07-09T16:34:04","date_gmt":"2013-07-09T19:34:04","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=416"},"modified":"2014-10-09T23:43:15","modified_gmt":"2014-10-10T02:43:15","slug":"oracle-rac-vmware-ora-27072-2","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/","title":{"rendered":"Oracle RAC em VMWare caindo com ORA-27072: File I\/O error"},"content":{"rendered":"<p>Durante 3 meses, tive problemas constantes de n\u00f3s de uma instala\u00e7\u00e3o Oracle RAC caindo constantemente. O sistema era o seguinte:<\/p>\n<ul>\n<li>S.O: Red Hat Enterprise Linux Server release 5.8 (Tikanga) &#8211; x86_64<\/li>\n<li>Kernel: 2.6.18-308.16.1.el5<\/li>\n<li>VMWare: VMware ESXi 5.0<\/li>\n<li>Oracle 11.2.0.3 PSU 6<\/li>\n<li>Oracle homes individuais e discos compartilhados para o RAC via VMFS<\/li>\n<\/ul>\n<p>Era aleat\u00f3rio, o n\u00f3 caia e voltava. As vezes a m\u00e1quina reiniciava pelos processos do Oracle.<br \/>\nMesmo ap\u00f3s reinsta\u00e7\u00e3o e atualiza\u00e7\u00e3o do Oracle para a \u00faltima vers\u00e3o e aplica\u00e7\u00e3o do \u00faltimo PSU, o problema continuava.<\/p>\n<p>Os logs do alerta e trace do oracle apresentavam o seguinte erro:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">ORA-27072: File I\/O error\r\nLinux-x86_64 Error: 5: Input\/output error\r\nAdditional information: 4\r\nAdditional information: 657408\r\nAdditional information: -1\r\nWARNING: Read Failed. group:1 disk:0 AU:321 offset:0 size:4096\r\npath:\/dev\/oracleasm\/disks\/DATA01\r\nincarnation:0xe968aff8 synchronous result:'I\/O error'\r\nsubsys:System iop:0x7fb195be9000 bufp:0x7fb196117000 osderr:0x0 osderr1:0x0\r\nERROR: failed to read ACD block gn=1 blk=10752\r\nORA-15080: synchronous I\/O operation to a disk failed\r\nWARNING: LGWR failed to read ACDC for diskgroup 1 thread 2\r\nWARNING: disk offlining resulting in I\/O error\r\nWARNING: Write Failed. group:1 disk:0 AU:321 offset:0 size:4096\r\npath:\/dev\/oracleasm\/disks\/DATA01\r\nincarnation:0xe968aff8 asynchronous result:'I\/O error'\r\nsubsys:System iop:0x7fb195be9000 bufp:0x647fd000 osderr:0x534b4950 osderr1:0x0<\/pre>\n<p>Pesquisando mais a fundo, encontrei o seguinte erro no log do Redhat \/var\/log\/messages:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Jul 6 19:45:58 oraclesrv01 kernel: sd 1:0:0:0: reservation conflict\r\nJul 6 19:45:58 oraclesrv01 kernel: sd 1:0:0:0: Unhandled error code\r\nJul 6 19:45:58 oraclesrv01 kernel: sd 1:0:0:0: SCSI error: return code = 0x00110018\r\nJul 6 19:45:58 oraclesrv01 kernel: Result: hostbyte=invalid driverbyte=DRIVER_OK,SUGGEST_OK<\/pre>\n<p>Como solu\u00e7\u00e3o, tentei:<\/p>\n<ul>\n<li>Montar discos novos, mas o problema se mant\u00e9m.<\/li>\n<li>Separar os dados 1 disco DATA e a configura\u00e7\u00e3o do cluster e votefiles em 3 discos OCRVOTE.<\/li>\n<\/ul>\n<p>Nada resolveu. Depois de pesquisar bastante, finalmente descobri a causa do erro.<\/p>\n<p><span style=\"color: #0000ff;\">O VMFS \u00e9 um sistema de arquivos de cluster que desativa (por padr\u00e3o) que m\u00faltiplas m\u00e1quinas virtuais abrem e leiam o mesmo disco virtual (arquivo .vmdk). Isso previne que mais de uma m\u00e1quina virtua acesse inadvertidamente o mesmo arquivo .vmdk.<\/span><\/p>\n<p><span style=\"color: #0000ff;\">A op\u00e7\u00e3o &#8220;multi-writer&#8221; permite que os discos VMFS sejam compartilhados por m\u00faltiplas m\u00e1quinas virtuais. Essa op\u00e7\u00e3o \u00e9 usada para permitir &#8220;fault tolerance&#8221; no VMWare, em casos que os discos precisam ser lidos e escritos simultaneamente.<\/span><\/p>\n<p>O artigo do link abaixo ensina o passo a passo para ativar esta op\u00e7\u00e3o:<\/p>\n<p><a title=\"http:\/\/kb.vmware.com\/selfservice\/microsites\/search.do?language=en_US&amp;cmd=displayKC&amp;externalId=1034165\" href=\"http:\/\/kb.vmware.com\/selfservice\/microsites\/search.do?language=en_US&amp;cmd=displayKC&amp;externalId=1034165\">http:\/\/kb.vmware.com\/selfservice\/microsites\/search.do?language=en_US&amp;cmd=displayKC&amp;externalId=1034165<\/a><br \/>\n<strong>Disabling simultaneous write protection provided by VMFS using the multi-writer flag (1034165)<\/strong><\/p>\n<p>Resumidamente, o que precisa ser feito \u00e9 editar o arquivo &#8220;.vmx&#8221; que define as configura\u00e7\u00f5es da m\u00e1quina virtual e adicionar para cada disco a ser compartilhado a seguinte entrada:<\/p>\n<p style=\"padding-left: 30px;\">scsiX:Y.sharing = &#8220;multi-writer&#8221;<\/p>\n<p>Se forem 4 discos, as entradas seriam as seguintes:<\/p>\n<p style=\"padding-left: 30px;\">scsi1:0.sharing = &#8220;multi-writer&#8221;<br \/>\nscsi1:1.sharing = &#8220;multi-writer&#8221;<br \/>\nscsi1:2.sharing = &#8220;multi-writer&#8221;<br \/>\nscsi1:3.sharing = &#8220;multi-writer&#8221;<\/p>\n<p>Pronto! Agora o seu oracle ir\u00e1 parar de dar error inexplic\u00e1veis.<\/p>\n<b>Gostou? N\u00e3o deixe de comentar ou deixar um \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-416 jlk' href='javascript:void(0)' data-task='like' data-post_id='416' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-416 lc'>+5<\/span><\/a><\/div><\/div> <div class='status-416 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Durante 3 meses, tive problemas constantes de n\u00f3s de uma instala\u00e7\u00e3o Oracle RAC caindo constantemente. O sistema era o seguinte: S.O: Red Hat Enterprise Linux Server release 5.8 (Tikanga) &#8211; x86_64 Kernel: 2.6.18-308.16.1.el5 VMWare: VMware ESXi 5.0 Oracle 11.2.0.3 PSU 6 Oracle homes individuais e discos compartilhados para o RAC via VMFS Era aleat\u00f3rio, o &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/\">Continue lendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[],"class_list":["post-416","post","type-post","status-publish","format-standard","hentry","category-linux","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle RAC em VMWare caindo com ORA-27072: File I\/O error - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Descobrindo a causa do erro oracle ORA-27072 em Oracle Rac executando em VMWare .\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2013\\\/07\\\/oracle-rac-vmware-ora-27072-2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2013\\\/07\\\/oracle-rac-vmware-ora-27072-2\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Oracle RAC em VMWare caindo com ORA-27072: File I\\\/O error\",\"datePublished\":\"2013-07-09T19:34:04+00:00\",\"dateModified\":\"2014-10-10T02:43:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2013\\\/07\\\/oracle-rac-vmware-ora-27072-2\\\/\"},\"wordCount\":365,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"Linux for Database\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2013\\\/07\\\/oracle-rac-vmware-ora-27072-2\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2013\\\/07\\\/oracle-rac-vmware-ora-27072-2\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2013\\\/07\\\/oracle-rac-vmware-ora-27072-2\\\/\",\"name\":\"Oracle RAC em VMWare caindo com ORA-27072: File I\\\/O error - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\"},\"datePublished\":\"2013-07-09T19:34:04+00:00\",\"dateModified\":\"2014-10-10T02:43:15+00:00\",\"description\":\"Descobrindo a causa do erro oracle ORA-27072 em Oracle Rac executando em VMWare .\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2013\\\/07\\\/oracle-rac-vmware-ora-27072-2\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2013\\\/07\\\/oracle-rac-vmware-ora-27072-2\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2013\\\/07\\\/oracle-rac-vmware-ora-27072-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle RAC em VMWare caindo com ORA-27072: File I\\\/O error\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle RAC em VMWare caindo com ORA-27072: File I\/O error - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Descobrindo a causa do erro oracle ORA-27072 em Oracle Rac executando em VMWare .","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/","twitter_misc":{"Escrito por":"DBA RJ","Est. tempo de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Oracle RAC em VMWare caindo com ORA-27072: File I\/O error","datePublished":"2013-07-09T19:34:04+00:00","dateModified":"2014-10-10T02:43:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/"},"wordCount":365,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["Linux for Database"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/","url":"https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/","name":"Oracle RAC em VMWare caindo com ORA-27072: File I\/O error - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website"},"datePublished":"2013-07-09T19:34:04+00:00","dateModified":"2014-10-10T02:43:15+00:00","description":"Descobrindo a causa do erro oracle ORA-27072 em Oracle Rac executando em VMWare .","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2013\/07\/oracle-rac-vmware-ora-27072-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/pt-br\/"},{"@type":"ListItem","position":2,"name":"Oracle RAC em VMWare caindo com ORA-27072: File I\/O error"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website","url":"https:\/\/www.dbarj.com.br\/pt-br\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/pt-br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/comments?post=416"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/416\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/media?parent=416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/categories?post=416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/tags?post=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}