ORA-15183: ASMLIB initialization error [driver/agent not installed]

来源：互联网发布：虚拟机安装ubuntu出错编辑：程序博客网时间：2024/05/16 13:52

最近安装了一个11.2.0.3.9的类似rac环境的数据库，但是在切换过程中出现问题，在主节点上可以正常起库，但是在备节点上都无法mount。

alter database mount
Wed Apr 30 21:15:04 2014
Errors in file /paic/dev/oracle/11g/app/oracle/diag/rdbms/d0smdbds/d0smdbds/trace/d0smdbds_rbal_4579.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
Errors in file /paic/dev/oracle/11g/app/oracle/diag/rdbms/d0smdbds/d0smdbds/trace/d0smdbds_rbal_4579.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
Wed Apr 30 21:15:04 2014
SUCCESS: diskgroup DATA1_MIDG was mounted
Wed Apr 30 21:15:04 2014
ERROR: failed to establish dependency between database d0smdbds and diskgroup resource ora.DATA1_MIDG.dg
Errors in file /paic/dev/oracle/11g/app/oracle/diag/rdbms/d0smdbds/d0smdbds/trace/d0smdbds_ckpt_4570.trc (incident=24169):
ORA-00600: internal error code, arguments: [kfioTranslateIO03], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /paic/dev/oracle/11g/app/oracle/diag/rdbms/d0smdbds/d0smdbds/incident/incdir_24169/d0smdbds_ckpt_4570_i24169.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Apr 30 21:15:05 2014
Dumping diagnostic data in directory=[cdmp_20140430211505], requested by (instance=1, osid=4570 (CKPT)), summary=[incident=24169].
Errors in file /paic/dev/oracle/11g/app/oracle/diag/rdbms/d0smdbds/d0smdbds/trace/d0smdbds_ckpt_4570.trc (incident=24170):
ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /paic/dev/oracle/11g/app/oracle/diag/rdbms/d0smdbds/d0smdbds/incident/incdir_24170/d0smdbds_ckpt_4570_i24170.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Dumping diagnostic data in directory=[cdmp_20140430211506], requested by (instance=1, osid=4570 (CKPT)), summary=[incident=24170].
ERROR: unrecoverable error ORA-600 raised in ASM I/O path; terminating process 4570
Wed Apr 30 21:15:07 2014
PMON (ospid: 4427): terminating the instance due to error 469
System state dump requested by (instance=1, osid=4427 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /paic/dev/oracle/11g/app/oracle/diag/rdbms/d0smdbds/d0smdbds/trace/d0smdbds_diag_4500.trc
Dumping diagnostic data in directory=[cdmp_20140430211507], requested by (instance=1, osid=4427 (PMON)), summary=[abnormal instance termination].
Instance terminated by PMON, pid = 4427

因mount是读取控制文件，现在无法读取。应该是asm磁盘问题，oracle无法访问asm磁盘导致。

备节点：

cnsz181007:d0smdbds > cd $ORACLE_HOME/bin
cnsz181007:d0smdbds > ls -l oracle
-rwsr-s--x 1 odsz11g oinstall 232748913 Apr 25 17:45 oracle

主节点：

cnsz181006:d0smdbds > cd $ORACLE_HOME/bin
cnsz181006:d0smdbds > ls -l oracle
-rwsr-s--x 1 odsz11g asmadmin 232748913 Apr 25 17:42 oracle

使用root修改文件的group

cnsz181007:d0smdbds > chgrp asmadmin oracle
chgrp: changing group of `oracle': Operation not permitted
cnsz181007:d0smdbds > pwd
/paic/dev/oracle/11g/app/oracle/product/11.2.0.3.9/bin
cnsz181007:d0smdbds > ls -l oracle
-rwxr-x--x 1 odsz11g asmadmin 232748913 Apr 25 17:45 oracle
cnsz181007:d0smdbds > chmod 6751 oracle
cnsz181007:d0smdbds > ls -l oracle
-rwsr-x--x 1 odsz11g asmadmin 232748913 Apr 25 17:45 oracle

奇怪的是这个修改后还是不行。

cnsz181007:d0smdbds > sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 30 21:52:00 2014

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2522189824 bytes
Fixed Size                  2230912 bytes
Variable Size            1157629312 bytes
Database Buffers         1342177280 bytes
Redo Buffers               20152320 bytes
ORA-03113: end-of-file on communication channel
Process ID: 10906
Session ID: 601 Serial number: 1

理因有权限访问了，但是为啥还是失败？哪位能提供下为啥呢？

解决办法：

切换的asm磁盘管理的用户

cnsz181007:d0smdbds > ls -l oracle
-rwsr-x--x 1 odsz11g asmadmin 232748913 Apr 25 17:45 oracle
cnsz181007:d0smdbds > su - grid
Password:
[grid@cnsz181007 ~]$ setasmgidwrap o=/paic/dev/oracle/11g/app/oracle/product/11.2.0.3.9/bin/oracle

完成后即可！

0 0