ASM Instance Creation on Windows
1. Create INIT.ORA file for asm instance
DIAGNOSTIC_DEST=C:\app\mqm\diag_asm_allow_only_raw_disks= FALSE instance_type=asm remote_login_passwordfile=exclusive
memory_target=52m
Note: Minimum required parameters.
C:\>oradim -new -asmsid +ASM -startmode manual
Instance created.
C:\>oradim -edit -asmsid +ASM -startmode a
C:\>oradim -edit -asmsid +ASM -syspwd change_on_install
C:\>set ORACLE_SID=+ASM
C:\>sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Apr 8 11:22:47 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pfile ='c:\init.ora';
ASM instance started
Total System Global Area 267825152 bytes
Fixed Size 1332584 bytes
Variable Size 241326744 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
SQL> create spfile from pfile='c:\init.ora';
File created.
SQL> shutdown
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 267825152 bytes
Fixed Size 1332584 bytes
Variable Size 241326744 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
SQL> SELECT group_number, disk_number, mount_status, header_status, state, path FROM v$asm_disk;
GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU STATE PATH
----------- ----------- ------- ------------ -------- -------------------- 0 1 CLOSED CANDIDATE NORMAL E:\ASMDISKS\DISK2 0 0 CLOSED CANDIDATE NORMAL E:\ASMDISKS\DISK1
1. Create INIT.ORA file for asm instance
DIAGNOSTIC_DEST=C:\app\mqm\diag_asm_allow_only_raw_disks= FALSE instance_type=asm remote_login_passwordfile=exclusive
memory_target=52m
Note: Minimum required parameters.
C:\>oradim -new -asmsid +ASM -startmode manual
Instance created.
C:\>oradim -edit -asmsid +ASM -startmode a
C:\>oradim -edit -asmsid +ASM -syspwd change_on_install
C:\>set ORACLE_SID=+ASM
C:\>sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Apr 8 11:22:47 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pfile ='c:\init.ora';
ASM instance started
Total System Global Area 267825152 bytes
Fixed Size 1332584 bytes
Variable Size 241326744 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
SQL> create spfile from pfile='c:\init.ora';
File created.
SQL> shutdown
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 267825152 bytes
Fixed Size 1332584 bytes
Variable Size 241326744 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
SQL> SELECT group_number, disk_number, mount_status, header_status, state, path FROM v$asm_disk;
GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU STATE PATH
----------- ----------- ------- ------------ -------- -------------------- 0 1 CLOSED CANDIDATE NORMAL E:\ASMDISKS\DISK2 0 0 CLOSED CANDIDATE NORMAL E:\ASMDISKS\DISK1
No comments:
Post a Comment