关于“Initializing the Oracle ASMLib driver: [FAILED]”的解决办法

来源:互联网 发布:软件推广渠道 编辑:程序博客网 时间:2024/05/17 06:25

关于无法加载asm dg错误


[oracle@mars ~]$ crs_start -allCRS-2501: Resource 'ora.ons' is disabledAttempting 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 performedORA-15017: diskgroup "ASM_DATA" cannot be mountedORA-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 -tName           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 scandisksReloading disk partitions: doneCleaning 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后显示失败。查看日志

[sql] view plaincopy
  1. [root@localhost log]# more /var/log/oracleasm   
  2. Cleaning any stale ASM disks...  
  3. File "/dev/" is not a block device  
  4. Disk "VOL1" does not exist or is not instantiated  
  5. Writing disk header: done  
  6. Instantiating disk: oracleasm-instantiate-disk: Unable to open manager: No such file or directory  
  7. failed  
  8. Clearing disk header: done  
  9. Disk "VOL1" does not exist or is not instantiated  
  10. Writing disk header: done  
  11. Instantiating disk: oracleasm-instantiate-disk: Unable to open manager: No such file or directory  
  12. failed  
  13. Clearing disk header: done  
  14. Creating /dev/oracleasm mount point: /dev/oracleasm  
  15. Loading module "oracleasm": failed  
  16. Unable to load module "oracleasm"  

原来是找不到ASM组件oracleasm.ko

在文件系统中查找

[sql] view plaincopy
  1. [root@localhost log]# find / -name oracleasm.ko  
  2. /lib/modules/2.6.18-53.1.21.el5/kernel/drivers/addon/oracleasm/oracleasm.ko  

手工安装ASM组件

[sql] view plaincopy
  1. [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执行成功。

0 0