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

简介: 关于无法加载asm dg错误[oracle@mars ~]$ crs_start -allCRS-2501: Resource 'ora.

关于无法加载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后显示失败。查看日志

[sql]  view plain copy
  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 plain copy
  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 plain copy
  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执行成功。

目录
相关文章
|
Oracle 关系型数据库 数据库
Oracle生产数据库insert插入较慢分析过程和解决办法
Oracle生产数据库insert插入较慢分析过程和解决办法
459 0
|
5月前
|
Oracle 关系型数据库
Navicat 连接Oracle ORA-28547: connection to server failed, probable Oracle Net admin error
Navicat 连接Oracle ORA-28547: connection to server failed, probable Oracle Net admin error
139 0
|
8月前
|
SQL Oracle Unix
Oracle sqlplus failed on AIX platform(/usr/lib/lib
Oracle sqlplus failed on AIX platform(/usr/lib/lib
49 1
|
8月前
|
存储 NoSQL 关系型数据库
实时计算 Flink版操作报错之抽取Oracle11g时,报错: "Retrieve schema history failed, the schema records for engine ... has been removed",怎么处理
在使用实时计算Flink版过程中,可能会遇到各种错误,了解这些错误的原因及解决方法对于高效排错至关重要。针对具体问题,查看Flink的日志是关键,它们通常会提供更详细的错误信息和堆栈跟踪,有助于定位问题。此外,Flink社区文档和官方论坛也是寻求帮助的好去处。以下是一些常见的操作报错及其可能的原因与解决策略。
|
Oracle 关系型数据库 Java
java处理oracle的Clob字段类型的坑和2种解决办法
java处理oracle的Clob字段类型的坑和2种解决办法
|
Oracle 关系型数据库 数据库
mstsc连接远程服务器CredSSP加密数据库修真、加密Oracle修正报错解决办法
mstsc连接远程服务器CredSSP加密数据库修真、加密Oracle修正报错解决办法
|
运维 Oracle 关系型数据库
登录Oracle数据库遇到ORA-01017密码错误的解决办法
我们在登录Oracle数据库时可能会遇到ORA-01017错误,这里分析原因并提供解决办法。 点击试看博主的专著《MySQL 8.0运维与优化》(清华大学出版社)
1032 0
Zp
|
SQL Oracle 关系型数据库
Oracle sql使用sys_guid() 生成32位id乱码解决办法
Oracle sql使用sys_guid() 生成32位id乱码解决办法
Zp
2942 0
Oracle sql使用sys_guid() 生成32位id乱码解决办法
|
Oracle 关系型数据库
Oracle报 ORA-00054资源正忙的解决办法
Oracle报 ORA-00054资源正忙的解决办法