支援資料庫版本：11gR2
前提條件：安裝Oracle及GridInfracture

1. 啟動ora.cssd，ora.LISTENER.lsnr等服務
> crsctl start res -all

2. 建立asm例項並新增到crs中
> oradim -new -asmsid +ASM -startmode manual -pfile 'D:\init+ASM.ora'
對應ORA-29786: SIHA attribute GET failed with error
> srvctl add asm -l LISTENER -d 'D:\asmdisk\disk*'

3. 建立asm初始化引數檔案
D:\init+ASM.ora
--
INSTANCE_TYPE=ASM
DB_UNIQUE_NAME=+ASM
ASM_DISKSTRING='D:\oracle\data\asmdisk\disk*'
_ASM_ALLOW_ONLY_RAW_DISKS=FALSE
--

4. 建立asm磁碟
> asmtool -create D:\asmdisk\disk00 100M

5. 啟動asm例項，建立spfile
> set oracle_sid=+ASM
> sqlplus / as sysasm
SQL> startup pfile='D:\init+ASM.ora'
SQL> create spfile from pfile='D:\init+ASM.ora';
SQL> shutdown immediate
SQL> startup

6. 建立磁碟組
SQL> CREATE DISKGROUP dg00 external REDUNDANCY DISK 'D:\asmdisk\disk00';
SQL> select name, state, type, total_mb, free_mb from v$asm_diskgroup;
SQL> SELECT name, mount_status, header_status, state, path FROM v$asm_disk order by name;

Windows平臺模擬單例項ASM環境

相關文章