1)利用ASMTOOL创建虚拟磁盘
在Windows平台下,Oracle提供了一个工具叫asmtool(位于%ORACLE_HOME%bin目录下),通过asmtool可以构建虚拟ASM磁盘,从而让我们有了一个可以在虚拟ASM磁盘上建立学习环境的机会。
E:\Documents and Settings\Administrator>asmtool -create f:\asmdisk\asmdisk1 1024
E:\Documents and Settings\Administrator>asmtool -create f:\asmdisk\asmdisk2 1024
E:\Documents and Settings\Administrator>asmtool -create f:\asmdisk\asmdisk3 1024
E:\Documents and Settings\Administrator>asmtool -create f:\asmdisk\asmdisk4 1024
E:\Documents and Settings\Administrator>asmtool -create f:\asmdisk\asmdisk5 1024
E:\Documents and Settings\Administrator>asmtool -create f:\asmdisk\asmdisk6 1024
2)配置CSS(Cluster Synchronization Services)
利用dbca创建,第一次创建时,会要求执行一个脚本,用于启动OCSS进程
E:\Documents and Settings\Administrator>%ORACLE_HOME%\bin\localconfig add
Step 1: creating new OCR repository
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'administrator', privgrp ''..
Operation successful.
Step 2: creating new CSS service
successfully created local CSS service
successfully added CSS to home
配置完成后,在Windows Services中会出现类似如下一个entry
--检查CSS守护进程的状态
D:oracle10g>crsctl check cssd
CSS appears healthy
D:oracle10g>
备注:如果后期要删除这个css服务,只需要在windows command下执行如下命令即可:
localconfig delete
2)配置ASM实例参数
配置asm_diskstring='F:\asmdisk\asmdisk*'和SYS密码后,直接下一步,这时我们发现没有asmdisk磁盘。
E:\Documents and Settings\Administrator>set ORACLE_SID=+ASM
E:\Documents and Settings\Administrator>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on 星期一 12月 5 21:04:42 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create pfile='F:\pfile.ora' from spfile;
文件已创建。
打开pfile.ora,添加*._asm_allow_only_raw_disks=FALSE
注意:此处"_asm_allow_only_raw_disks"为隐含参数,设为FALSE是为了允许ASM使用非裸设备,在这里是必须要设置为FALSE的。
此时pfile.ora如下:
*.asm_diskstring='F:\asmdisk\asmdisk*'
*.background_dump_dest='F:\oracle\product\10.2.0\db_1\admin\+ASM\bdump'
*.core_dump_dest='F:\oracle\product\10.2.0\db_1\admin\+ASM\cdump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='SHARED'
*.user_dump_dest='F:\oracle\product\10.2.0\db_1\admin\+ASM\udump'
*._asm_allow_only_raw_disks=FALSE
然后关闭实例,用pfile启动实例
SQL> shutdown immediate;
ORA-15100: ??????????
ASM 实例已关闭
SQL> startup pfile='F:\pfile.ora';
ASM 实例已启动
Total System Global Area 83886080 bytes
Fixed Size 1295152 bytes
Variable Size 57425104 bytes
ASM Cache 25165824 bytes
ORA-15110: ??????
注意:这里有一个ORA-15110的错误信息,因为是首次启动asm实例,还没有创建diskgroup,所以显示15110错误是正常的,忽略掉该错误,继续后面的步骤。
然后用spfile启动+ASM
SQL> create spfile from pfile='F:\pfile.ora';
文件已创建。
SQL> shutdown immediate;
ORA-15100: ??????????
ASM 实例已关闭
SQL> startup
ASM 实例已启动
Total System Global Area 83886080 bytes
Fixed Size 1295152 bytes
Variable Size 57425104 bytes
ASM Cache 25165824 bytes
ORA-15110: ??????
SQL> show parameter spfile;
NAME TYPE
------------------------------------ ------------
VALUE
------------------------------
spfile string
F:\ORACLE\PRODUCT\10.2.0\DB_1\
DATABASE\SPFILE+ASM.ORA
SQL> col host_name format a10
SQL> col version format a10
SQL> col instance_name format a15
SQL> select host_name,instance_name,version,status from v$instance;
HOST_NAME INSTANCE_NAME VERSION STATUS
---------- --------------- ---------- ------------------------
CXJ +asm 10.2.0.4.0 STARTED
创建dgroupa磁盘组
创建完磁盘组
命令行查看:
SQL> col path for a30
SQL> select path,mount_status from v$asm_disk order by disk_number;
PATH MOUNT_STATUS
------------------------------ --------------
F:\ASMDISK\ASMDISK1 CLOSED
F:\ASMDISK\ASMDISK2 CLOSED
F:\ASMDISK\ASMDISK3 CLOSED
F:\ASMDISK\ASMDISK4 CLOSED
F:\ASMDISK\ASMDISK5 CLOSED
F:\ASMDISK\ASMDISK6 CLOSED
NAME TYPE VALUE
------------------------------------ ---------- -----------------------------
_asm_allow_only_raw_disks boolean FALSE
asm_diskgroups string DGROUPA
asm_diskstring string F:\asmdisk\asmdisk*
asm_power_limit integer 1
再看一下磁盘的状态:
SQL> select path,mount_status from v$asm_disk order by disk_number;
PATH MOUNT_STATUS
------------------------------ --------------
F:\ASMDISK\ASMDISK1 CACHED
F:\ASMDISK\ASMDISK2 CACHED
F:\ASMDISK\ASMDISK3 CACHED
F:\ASMDISK\ASMDISK4 CACHED
F:\ASMDISK\ASMDISK5 CLOSED
F:\ASMDISK\ASMDISK6 CLOSED
这时的磁盘状态,MOUNT_STATUS变成"CACHED",表示磁盘已经成为磁盘组的一部分,并且正在被ASM Instance访问。
磁盘组使用情况:
SQL> select group_number,name,sector_size,block_size,allocation_unit_size,state,
type,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE
------------ ------ ----------- ---------- --------------------
STATE TYPE TOTAL_MB FREE_MB
---------------------- ---------- ---------- ----------
1 DGROUPA 512 4096 1048576
MOUNTED NORMAL 4096 3941
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24104518/viewspace-712762/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24104518/viewspace-712762/