Disk /dev/sdb: 5368 MB, 5368709120 bytes
255 heads, 63 sectors/track, 652 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 499 4008186 83 Linux
/dev/sdb2 500 585 690795 83 Linux
/dev/sdb3 586 622 297202+ 83 Linux
/dev/sdb4 623 652 240975 83 Linux
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
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 []: dba
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
Initializing the Oracle ASMLib driver: [FAILED]
晕,出问题了,尝试将SELINUX设置disabled
[iyunv@dbsvr tmp]# vi /etc/sysconfig/selinux
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - SELinux is fully disabled.
SELINUX=disabled
# SELINUXTYPE= type of policy in use. Possible values are:
# targeted - Only targeted network daemons are protected.
# strict - Full SELinux protection.
SELINUXTYPE=targeted
[iyunv@dbsvr tmp]# setenforce 0
[iyunv@dbsvr tmp]# /usr/sbin/sestatus
SELinux status: enabled
SELinuxfs mount: /selinux
Current mode: permissive
Mode from config file: disabled
Policy version: 18
Policy from config file:targeted
Broadcast message from root (pts/2) (Sun Aug 23 17:01:10 2009):
The system is going down for reboot NOW!
[iyunv@dbsvr tmp]# /usr/sbin/sestatus
SELinux status: disabled
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
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 [dba]:
Start Oracle ASM library driver on boot (y/n) [y]:
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [ OK ]
Scanning the system for Oracle ASMLib disks: [ OK ]
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm disable
Writing Oracle ASM library driver configuration: done
Dropping Oracle ASMLib disks: [ OK ]
Shutting down the Oracle ASMLib driver: [ OK ]
[iyunv@dbsvr tmp]# /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 ]
5、对磁盘组的操作
1)创建asm磁盘组
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb2
Marking disk "VOL1" as an ASM disk: [ OK ]
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdb3
Marking disk "VOL2" as an ASM disk: [ OK ]
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm createdisk VOL3 /dev/sdb4
Marking disk "VOL3" as an ASM disk: [ OK ]
注意:磁盘名称是 ASCII 大写字母、数字和下划线。它们必须以字母开始。
2)当然不再被 ASM 使用的磁盘也可以取消标记
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm deletedisk VOL1
Removing ASM disk "VOL1": [ OK ]
3)可以查询任意的操作系统磁盘,以了解它是否被 ASM 使用:
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm querydisk /dev/sdb2
Device "/dev/sdb2" is marked an ASM disk with the label "VOL1"
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm querydisk /dev/sdb3
Device "/dev/sdb3" is marked an ASM disk with the label "VOL2"
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm querydisk /dev/sdb4
Device "/dev/sdb4" is marked an ASM disk with the label "VOL3"
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm querydisk VOL1
Disk "VOL1" is a valid ASM disk
[iyunv@dbsvr tmp]# /etc/init.d/oracleasm scandisks
Scanning the system for Oracle ASMLib disks: [ OK ]
5、利用dbca建库时,需要运行脚本,注意是root用户,但环境变量是oracle
[iyunv@dbsvr 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.
dbsvr
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
附:ASM实例可以手工创建,也可以通过dbca创建,如手工创建
1、创建asm参数
[oracle@dbsvr dbs]$ more spfile+ASM.ora
+ASM.asm_diskgroups='ASMDISK'#Manual Mount
*.asm_diskgroups='ASMDISK'
*.background_dump_dest='/oracle/app/admin/+ASM/bdump'
*.core_dump_dest='/oracle/app/admin/+ASM/cdump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='SHARED'
*.user_dump_dest='/oracle/app/admin/+ASM/udump'
2、创建diskgroup组
SQL> ALTER DISKGROUP ALL MOUNT
Sun Aug 23 18:26:49 2009
Loaded ASM Library - Generic Linux, version 2.0.4 (KABI_V2) library for asmlib interface
Sun Aug 23 18:29:24 2009
SQL> CREATE DISKGROUP asmdisk External REDUNDANCY DISK '/dev/sdb2' SIZE 674M ,'/dev/sdb3' SIZE 290M ,'/dev/sdb4' SIZE 235M ,'/dev/sdc1' SIZE 1913M;