racle ASMLib driver: [ ?OK ?]
Scanning the system for Oracle ASMLib disks: [ ?OK ?]
?
2、启用ASMLib驱动程序:
[root@wwl asmpark]# /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [ ?OK ?]
Scanning the system for Oracle ASMLib disks: [ ?OK ?]
?
3、通过以root用户身份运行以下命令来标记由 ASMLib 使用的磁盘:
?
[root@wwl asmpark]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb1
Marking disk "VOL1" as an ASM disk: [ ?OK ?]
[root@wwl asmpark]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdc1
Marking disk "VOL2" as an ASM disk: [ ?OK ?]
[root@wwl asmpark]#
?
4、通过如下命令查看ASM所能使用的磁盘及状态,一切显示都是正常的。
[root@wwl asmpark]# oracleasm querydisk VOL1
Disk "VOL1" is a valid ASM disk
[root@wwl asmpark]# oracleasm querydisk /dev/sdb1
Device "/dev/sdb1" is marked an ASM disk with the label "VOL1"
[root@wwl asmpark]# oracleasm querydisk VOL2
Disk "VOL2" is a valid ASM disk
[root@wwl ~]# oracleasm querydisk /dev/sdc1
Device "/dev/sdc1" is marked an ASM disk with the label "VOL2"
[root@wwl asmpark]# oracleasm listdisks
VOL1
VOL2
[root@wwl asmpark]# ls -l /dev/oracleasm/disks/*
brw-rw---- 1 oracle dba 8, 17 Apr 10 00:25 /dev/oracleasm/disks/VOL1
brw-rw---- 1 oracle dba 8, 33 Apr 10 00:25 /dev/oracleasm/disks/VOL2
[root@wwl asmpark]# oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes
?
5、如上ASMLib已经安装完成,并且也将磁盘标记为可用,接下来要做的就是创建ASM实例,并构建一个使用ASM磁盘来存储数据的
数据库,可以使用DBCA,当然也可以使用手工的方式来创,在这里,我就采用手工方式创建ASM实例,步骤如下:
?
6、创建初始化参数文件,信息如下:
[oracle@ jb51.net dbs]$ vi $ORACLE_HOME/dbs/init$ORACLE_SID.ora
asm_diskstring='WWL:VOL*'
background_dump_dest='/oracle/admin/+ASM/bdump'
core_dump_dest='/oracle/admin/+ASM/cdump'
user_dump_dest='/oracle/admin/+ASM/udump'
instance_type='asm'
large_pool_size=12M
remote_login_passwordfile='SHARED'
?
7、增加实例信息到/etc/oratab
$ vi /etc/oratab
+ASM:/u01/app/oracle/product/10.2.0/db_1:Y
?
8、创建ASM实例密码文件:
[oracle@ jb51.net dbs]$ $ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password='oracle' force=y;
[oracle@ jb51.net dbs]$
?
9、创建ASM实例相应的目录:
[oracle@ jb51.net dbs]$ ?mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/bdump
[oracle@ jb51.net dbs]$ mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/cdump
[oracle@ jb51.net dbs]$ mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/udump
[oracle@ jb51.net dbs]$
?
$ su - root
[root@wwl ~]# /oracle/orahome/10.2.0/db_1/bin/localconfig add
/etc/oracle does not exist. Creating it now.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized
Adding to inittab
Startup will be queued to init within 90 seconds.
Checking the status of new
Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
? ? ? ? wwl
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
?
11、启动ASM实例,并创建ASM磁盘组:
[oracle@ jb51.net dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 10 01:23:44 2012
Copyright (c) 1982, 2005, Oracle. ?All rights reserved.
Connected to:
Oracle Database 10g Enterprise E