Windows平台模拟单实例ASM环境

支持数据库版本：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;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22558114/viewspace-1103753/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22558114/viewspace-1103753/