loaded on boot and what permissions it will have.The current values
will be shown in brackets ('[]').Hitting
answer will keep that current value.Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: oinstall
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
5、然后通过DBCA配置
[oracle@myorcl ~]$ dbca
选择配置ASM
就可以看到之前的裸设备
冗余机制有normal ：两个磁盘组，hight：三个磁盘组，external：外部冗余：一个磁盘组
然后完成，不配置其他选项
6、访问实例
[oracle@myorcl ~]$ export ORACLE_SID=+ASM
[oracle@myorcl ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 5 07:59:01 2013
Copyright (c) 1982, 2005, Oracle.All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select instance_name from v$instance;
INSTANCE_NAME
------------------------------------------------
+ASM
查看ASM磁盘组
SQL> desc v$asm_diskgroup
NameNull Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBERNUMBER
NAMEVARCHAR2(30)
SECTOR_SIZENUMBER
BLOCK_SIZENUMBER
ALLOCATION_UNIT_SIZENUMBER
STATEVARCHAR2(11)
TYPEVARCHAR2(6)
TOTAL_MBNUMBER
FREE_MBNUMBER
REQUIRED_MIRROR_FREE_MBNUMBER
USABLE_FILE_MBNUMBER
OFFLINE_DISKSNUMBER
UNBALANCEDVARCHAR2(1)
COMPATIBILITYVARCHAR2(60)
DATABASE_COMPATIBILITYVARCHAR2(60)
7、查看数据库实例是否能够使用ASM磁盘组
[oracle@myorcl asm]$ export ORACLE_SID=orcl
[oracle@myorcl asm]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 5 08:03:07 2013
Copyright (c) 1982, 2005, Oracle.All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
SQL>
SQL> select name from v$asm_diskgroup;
NAME
--------------------------------------------------------------------------------
DB
8、创建ASM实例数据库