ASM DISK Group加载ORA-15183错误一例(三)

2015-07-16 12:08:00 · 作者: · 浏览: 2
--- ------------------------------


spfile? string? ? ? +DATA/sicsstb/spfilesicsstb.ora


SQL> show parameter control


NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? VALUE


------------------------------------ ----------- ------------------------------


control_file_record_keep_time? ? ? ? integer? ? 7


control_files? ? ? ? ? ? ? ? ? ? ? ? string? ? ? +DATA/sicsstb/controlfile/curr


? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ent.260.878897845, +RECO/sicsstb/controlfile/current.256.878


? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 897845


control_management_pack_access? ? ? string? ? ? DIAGNOSTIC+TUNING


注意:此处的ASM无法启动,并不是笔者没有启动ASM组件。如果是简单因为ASM组件没有开启,先启动数据库服务的话,错误信息如下:


[oracle@NCR-Standby-Asm ~]$ sqlplus /nolog


SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 1 08:39:11 2015


Copyright (c) 1982, 2013, Oracle.? All rights reserved.


SQL> conn / as sysdba


Connected to an idle instance.


SQL> startup


ORA-01078: failure in processing system parameters


ORA-01565: error in identifying file '+DATA/sicsstb/spfilesicsstb.ora'


ORA-17503: ksfdopn:10 Failed to open file +DATA/sicsstb/spfilesicsstb.ora


ORA-15077: could not locate ASM instance serving a required diskgroup


nomount阶段要访问spfile,我们的SPFILE是在+DATA里面,如果ASM真的不可用的话,连nomount阶段都不能进入。


[root@NCR-Standby-Asm ~]# rpm -qa | grep asm


libatasmart-0.17-4.el6_2.x86_64


oracleasmlib-2.0.4-1.el6.x86_64


oracleasm-support-2.1.8-1.el6.x86_64


kmod-oracleasm-2.0.6.rh1-3.el6_5.x86_64


查找对应生成的trace文件,可以看到问题的更详细描述。


[root@NCR-Standby-Asm trace]# tail -n 200 sicsstb_rbal_4147.trc


Trace file /u02/app/oracle/diag/rdbms/sicsstb/sicsstb/trace/sicsstb_rbal_4147.trc


Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production


With the Partitioning, Automatic Storage Management, OLAP, Data Mining


and Real Application Testing options


ORACLE_HOME = /u02/app/oracle/product/11.2.0/dbhome_1


System name:? ? Linux


Node name:? ? ? NCR-Standby-Asm


Release:? ? ? ? 2.6.32-431.el6.x86_64


Version:? ? ? ? #1 SMP Sun Nov 10 22:19:54 EST 2013


Machine:? ? ? ? x86_64


VM name:? ? ? ? VMWare Version: 6


Instance name: sicsstb


Redo thread mounted by this instance: 0


Oracle process number: 15


*** 2015-05-25 16:09:31.634


*** SESSION ID:(190.1) 2015-05-25 16:09:31.634


*** CLIENT ID:() 2015-05-25 16:09:31.634


*** SERVICE NAME:() 2015-05-25 16:09:31.634


*** MODULE NAME:() 2015-05-25 16:09:31.634


*** ACTION NAME:() 2015-05-25 16:09:31.634


ERROR: asm_version error. err: driver/agent not installed rc:2


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


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


ERROR: asm_version error. err: driver/agent not installed rc:2


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


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


ERROR: asm_version error. err: driver/agent not installed rc:2


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


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


ERROR: asm_version error. err: driver/agent not installed rc:2


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


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


ERROR: asm_version error. err: driver/agent not installed rc:2


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


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


Incident 9721 created, dump file: /u02/app/oracle/diag