Saturday, March 16, 2013

steps to create ASM instance on windows


steps to create ASM instance

set oracle_sid=+ASM


create initialization parameter file
E:\app\Mani\product\11.1.0\db_1\database\init+ASM.ora
with following enteries

instance_type=asm
ASM_DISKSTRING= 'E:\asmdisks\*'
_ASM_ALLOW_ONLY_RAW_DISKS=FALSE
ASM_DISKGROUPS='dgroup1'



create service for ASM
#oradim -new -sid +ASM


create files which we trick to asm to take as raw logical volumes

asmtool -create E:\asmdisks\asmdisks1.asm 300
asmtool -create E:\asmdisks\asmdisks2.asm 300
asmtool -create E:\asmdisks\asmdisks3.asm 300

startup

create the diskgooup for asm
create diskgroup dgroup1 normal redundancy disk
'E:\ASMDISKS\ASMDISKS1.ASM','E:\ASMDISKS\ASMDISKS2.ASM';


SQL> select path,mount_status from v$asm_disk;

PATH
-------------------------------------------------MOUNT_S
-------
E:\ASMDISKS\ASMDISKS1.ASM CLOSED

E:\ASMDISKS\ASMDISKS3.ASM
CLOSED

E:\ASMDISKS\ASMDISKS2.ASM
CLOSED



ASM_DISKDROUPS='dgroup1'



SQL> shutdown;
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup
ASM instance started

Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 509162388 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted



thts it :)

No comments: