{"id":1217,"date":"2015-04-09T22:14:43","date_gmt":"2015-04-09T20:14:43","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=1217"},"modified":"2015-04-10T09:32:04","modified_gmt":"2015-04-10T07:32:04","slug":"ora-29786-eliminando-un-diskgroup","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/ora-29786-eliminando-un-diskgroup\/","title":{"rendered":"ORA-29786 eliminando un Diskgroup"},"content":{"rendered":"<p>Hoy vamos a ver un error que puede ser bastante com\u00fan si creamos las cosas a mano \u00bb a la antigua usanza\u00bb.<\/p>\n<p>Veamos algo que puede ocurrirnos cuando intentamos eliminar un diskgroup en nuestro ASM <\/p>\n<pre>\r\n[oracle@test]$ sqlplus \"\/as sysasm\"\r\nSQL*Plus: Release 11.2.0.3.0 Production on Fri Apr 09 21:10:38 2015\r\nCopyright (c) 1982, 2011, Oracle.  All rights reserved.\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Automatic Storage Management option\r\nSQL> DROP DISKGROUP TEMP INCLUDING CONTENTS;\r\nDROP DISKGROUP TEMP INCLUDING CONTENTS\r\n*ERROR at line 1:\r\nORA-15039: diskgroup not dropped\r\nORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]lsts[0]]\r\n<\/pre>\n<p>Este error nos va a dar tanto si est\u00e1 montado, desmontado, tiene ficheros, o est\u00e1 vac\u00edo, y , el problema es el modo de creacion.<\/p>\n<p>Desde la versi\u00f3n 11gr2 el ASM es un recurso mas del CRS, por lo cual, para poder llevar a cabo determinadas operaciones como create\/drop diskgroup, create pfile\/spfile   es necesario que el ASM est\u00e9 registrado como un recurso del cluster.<\/p>\n<p>La solucion para poder llevar a cabo estas acciones es a\u00f1adir el ASM al repositorio del cluster <\/p>\n<pre>\r\nsrvctl add asm -h\r\nAdds an ASM configuration to be managed by Oracle Restart.\r\nUsage: srvctl add asm [-l <lsnr_name>] [-p <spfile>] [-d <asm_diskstring>]\r\n    -l <lsnr_name>           Listener name\r\n    -p <spfile>              Server parameter file path\r\n    -d <asm_diskstring>      ASM diskgroup discovery string\r\n    -h                       Print usage\r\n\r\n\r\nsrvctl add asm  -p $GRID_HOME\/dbs\/init+ASM.ora \r\nsrvctl status asm\r\n<\/pre>\n<p>M\u00e1s informacion como siempre en metalink en la nota <\/p>\n<ul>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?_afrLoop=525714969343460&#038;id=976075.1&#038;_afrWindowMode=0&#038;_adf.ctrl-state=8wm0qifcb_141\">Doc ID 976075.1 ORA-29786: SIHA attribute GET failed with Error If 11gR2 ASM instance is created manually<\/a>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a ver un error que puede ser bastante com\u00fan si creamos las cosas a mano \u00bb a la antigua usanza\u00bb. Veamos algo que puede ocurrirnos cuando intentamos eliminar un diskgroup en nuestro ASM [oracle@test]$ sqlplus \u00ab\/as sysasm\u00bb SQL*Plus: &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/ora-29786-eliminando-un-diskgroup\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,42,66,199],"tags":[132,219,218,57,217],"class_list":["post-1217","post","type-post","status-publish","format-standard","hentry","category-11g","category-asm","category-errores-ora","category-oracle","tag-asm-2","tag-borrar","tag-drop","tag-ora","tag-ora-29786"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=1217"}],"version-history":[{"count":6,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1217\/revisions"}],"predecessor-version":[{"id":1223,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1217\/revisions\/1223"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=1217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=1217"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=1217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}