Oracle 11g RAC ASM 错误之(1)
系统环境：
操作系统：RedHat EL5.5
集群软件: GI (11.2.0.1)
数据库软件：Oracle 11g（11.2.0.1）
故障现象：在通过pfile创建 spfile时出现I/O错误（spfile放在ASM DISKGROUP上）
Oracle ASM 磁盘组错误：
-----在asm 磁盘组上创建spfile 报错
SQL> create spfile='+DG1/stddb/spfilestddb.ora' from pfile='/home/oracle/initstddb.ora';
ORA-15081: failed to submit an I/O operation to a disk
-----告警日志
ORACLE_BASE from environment = /u01/app/oracle
Errors in file /u01/app/oracle/diag/rdbms/stddb/stddb1/trace/stddb1_rbal_4575.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
WARNING: FAILED to load library: /opt/oracle/extapi/32/asm/orcl/1/libasm.so
Errors in file /u01/app/oracle/diag/rdbms/stddb/stddb1/trace/stddb1_rbal_4575.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
SUCCESS: diskgroup DG1 was mounted
解决方法：
-----查看$ORACLE_HOME/bin/oracle 目录所有者和权限
------oracle 文件正确的权限
[oracle@node1 bin]$ pwd
/u01/app/oracle/product/11.2.0/db_1/bin
[oracle@node1 bin]$ ls -ld oracle
-r-sr-s--x 1 oracle asmadmin 173515905 May 3 12:32 oracle
----错误的文件权限（导致在往磁盘组写入文件时报错）
[grid@rac1 ~]$ cd $ORACLE_HOME/bin
[grid@rac1 bin]$ ls -ld oracle
-rwsr-s--x 1 grid oinstall 152462728 May 20 18:26 oracle
[grid@rac1 bin]$ su -
Password:
------更改oracle 文件所有者和权限
[root@rac1 ~]# chown oracle:asmadmin /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@rac1 ~]# chmod 6751 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@rac2 ~]# ls -ld /u01/app/oracle/product/11.2.0/db_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 173515905 May 21 10:51 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
修改Oracle 可执行文件权限后问题解决
