关于无法加载asm dg错误
[oracle@mars ~]$ crs_start -all
CRS-2501: Resource 'ora.ons' is disabled
Attempting to start `ora.PRD_LISTENER.lsnr` on member `mars`
Attempting to start `ora.LISTENER.lsnr` on member `mars`
Attempting to start `ora.cssd` on member `mars`
Attempting to start `ora.diskmon` on member `mars`
Attempting to start `ora.evmd` on member `mars`
Start of `ora.evmd` on member `mars` succeeded.
Start of `ora.diskmon` on member `mars` succeeded.
Start of `ora.PRD_LISTENER.lsnr` on member `mars` succeeded.
Start of `ora.LISTENER.lsnr` on member `mars` succeeded.
Start of `ora.cssd` on member `mars` succeeded.
Attempting to start `ora.asm` on member `mars`
Start of `ora.asm` on member `mars` succeeded.
Attempting to start `ora.ASM_DATA.dg` on member `mars`
CRS-5017: The resource action "ora.ASM_DATA.dg start" encountered the following error:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "ASM_DATA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ASM_DATA"
Start of `ora.ASM_DATA.dg` on member `mars` failed.
Attempting to stop `ora.ASM_DATA.dg` on member `mars`
Stop of `ora.ASM_DATA.dg` on member `mars` succeeded.
CRS-0215: Could not start resource 'ora.rudy.db'.
CRS-2660: Resource 'ora.ons' or all of its instances are disabled
[oracle@mars ~]$ crs_stat -v -t
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....DATA.dg ora....up.type 0/5 0/ ONLINE OFFLINE
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE mars
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE mars
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE mars
ora.cssd ora.cssd.type 0/5 0/5 ONLINE ONLINE mars
ora.diskmon ora....on.type 0/10 0/5 ONLINE ONLINE mars
ora.evmd ora.evm.type 0/10 0/5 ONLINE ONLINE mars
ora....prod.db ora....se.type 0/2 0/1 ONLINE OFFLINE
ora.ons ora.ons.type 0/3 0/ OFFLINE OFFLINE
[root@mars init.d]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "ASM_VOL1"
Unable to instantiate disk "ASM_VOL1"
Instantiating disk "ASM_VOL2"
Unable to instantiate disk "ASM_VOL2"
SQL> select group_number,disk_number,mount_status,header_status,name,path from v$asm_disk;
no rows selected
安装完ASM相应组件后,执行/etc/Init.d/oracleasm enable后显示失败。查看日志
- [root@localhost log]# more /var/log/oracleasm
- Cleaning any stale ASM disks...
- File "/dev/" is not a block device
- Disk "VOL1" does not exist or is not instantiated
- Writing disk header: done
- Instantiating disk: oracleasm-instantiate-disk: Unable to open manager: No such file or directory
- failed
- Clearing disk header: done
- Disk "VOL1" does not exist or is not instantiated
- Writing disk header: done
- Instantiating disk: oracleasm-instantiate-disk: Unable to open manager: No such file or directory
- failed
- Clearing disk header: done
- Creating /dev/oracleasm mount point: /dev/oracleasm
- Loading module "oracleasm": failed
- Unable to load module "oracleasm"
原来是找不到ASM组件oracleasm.ko
在文件系统中查找
- [root@localhost log]# find / -name oracleasm.ko
- /lib/modules/2.6.18-53.1.21.el5/kernel/drivers/addon/oracleasm/oracleasm.ko
手工安装ASM组件
- [root@localhost log]# /sbin/insmod /lib/modules/2.6.18-53.1.21.el5/kernel/drivers/addon/oracleasm/oracleasm.ko
/etc/init.d/oracleasm enable执行成功。