{"id":132,"date":"2009-03-13T15:53:00","date_gmt":"2009-03-13T18:53:00","guid":{"rendered":"http:\/\/www.soudba.com.br\/?p=132"},"modified":"2009-03-13T15:53:00","modified_gmt":"2009-03-13T18:53:00","slug":"simulando-asm-no-windows","status":"publish","type":"post","link":"https:\/\/www.soudba.com.br\/?p=132","title":{"rendered":"Simulando ASM no Windows"},"content":{"rendered":"<p>SQL&gt; alter system set &#8220;_asm_allow_only_raw_disks&#8221;=false scope=spfile;<\/p>\n<p>No prompt do DOS crie sua pastinha onde estiver espaco pelo menos 1G.<\/p>\n<p>cria a pasta em g:asmfake<\/p>\n<p>Baixar<br \/>Ja o DD para windows esta no link:<br \/>http:\/\/www.chrysocome.net\/download<\/p>\n<p>De volta ao sqlplus:<br \/>set ORACLE_SID=+ASMsqlplus \/ as sysdba<br \/>SQL&gt; alter system set asm_diskstring=&#8217;.ORCLDISK*&#8217;,&#8217;g:asmfake*&#8217; scope=both;<br \/>SQL&gt;shutdown<br \/>SQL&gt;startup<\/p>\n<p>Fa\u00e7a o download do DD e coloque em uma pasta para ser executado &#8211; http:\/\/www.chrysocome.net\/dd<\/p>\n<p>Pasta de G:asmfake<\/p>\n<p>26\/02\/2007 23:50 342.016 dd.exe<br \/>13\/03\/2009 19:20 300 fake.bat<br \/>13\/03\/2009 19:22 10.240.000 fakeasm1<br \/>13\/03\/2009 19:22 10.240.000 fakeasm2<br \/>13\/03\/2009 19:22 10.240.000 fakeasm3<br \/>13\/03\/2009 19:22 10.240.000 fakeasm4<br \/>13\/03\/2009 19:22 10.240.000 fakeasm5<br \/>7 arquivo(s) 51.542.316 bytes<br \/>2 pasta(s) 6.377.570.304 bytes dispon\u00edveis<\/p>\n<p>G:asmfake&gt;type fake.bat<br \/>dd if=\/dev\/zero of=g:asmfakefakeasm1 bs=102400 count=100<br \/>dd if=\/dev\/zero of=g:asmfakefakeasm2 bs=102400 count=100<br \/>dd if=\/dev\/zero of=g:asmfakefakeasm3 bs=102400 count=100<br \/>dd if=\/dev\/zero of=g:asmfakefakeasm4 bs=102400 count=100<br \/>dd if=\/dev\/zero of=g:asmfakefakeasm5 bs=102400 count=100<\/p>\n<p>G:asmfake&gt;<\/p>\n<p>Sem essa alteracao no sqlplus com ASM nao ira funcionar nao &#8230;<\/p>\n<p>SQL&gt; alter system set &#8220;_asm_allow_only_raw_disks&#8221;=false scope=spfile;<\/p>\n<p>Pare e inicie de novo!<\/p>\n<p>Fa\u00e7a a confirmacao dos discos ASM:<\/p>\n<p>SQL&gt; select path from v$asm_disk;<br \/>PATH<br \/>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>G:ASMFAKEFAKEASM1<br \/>G:ASMFAKEFAKEASM2<br \/>G:ASMFAKEFAKEASM5<br \/>G:ASMFAKEFAKEASM4<br \/>G:ASMFAKEFAKEASM3<\/p>\n<p>Agora \u00e9 so acionar o dbca e criar os discos normalmente.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL&gt; alter system set &#8220;_asm_allow_only_raw_disks&#8221;=false scope=spfile; No prompt do DOS crie sua pastinha onde estiver espaco pelo menos 1G. cria a pasta em g:asmfake BaixarJa o DD para windows esta no link:http:\/\/www.chrysocome.net\/download De volta ao sqlplus:set ORACLE_SID=+ASMsqlplus \/ as sysdbaSQL&gt; &hellip; <a href=\"https:\/\/www.soudba.com.br\/?p=132\">Continue lendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30,31,77,191],"tags":[],"class_list":["post-132","post","type-post","status-publish","format-standard","hentry","category-asm-no-windows-xp","category-asm-no-xp","category-dd-asm-windows","category-oracle-asm"],"_links":{"self":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=132"}],"version-history":[{"count":0,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/132\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}