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?可執行文件權限后問題解決

轉載于:https://blog.51cto.com/tiany/1374228

總結

以上是生活随笔為你收集整理的Oracle 11g RAC ASM 错误之(1)的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。