对RAC接触不多,今天在测试环境启动RAC失败,经过一番努力,总算解决问题.下面简单记录一下:
启动报错如下所示
rac2-> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:32:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora' ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.ora ORA-15077: could not locate ASM instance serving a required diskgroup SQL> exit Disconnected
--检查ASM实例运行情况
rac2-> srvctl status asm -n rac1
ASM 实例 +ASM1 正在节点 rac1 上运行。
rac2-> srvctl status asm -n rac2
ASM 实例 +ASM2 不在节点 rac2 上运行。
--可以看出,在节点2(也就是出问题的节点)上ASM实例并没有启动
--接着检查ASM磁盘组
[root@rac2 ~]# /etc/init.d/oracleasm listdisks
没有结果输出表示ASM磁盘组没有加载,之前配置ASM的时候已经配置了自动加载ASM,可能是因为其他原因没有加载成功.下面手工加载:
[root@rac2 ~]# /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: [ OK ]
Loading module "oracleasm": [ OK ]
Mounting ASMlib driver filesystem: [ OK ]
Scanning system for ASM disks: [ OK ]
--再查看ASM磁盘组信息:
[root@rac2 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
--可以看出,ASM磁盘组加载好了.
--下面要做的是启动ASM实例
rac2-> export ORACLE_SID=+ASM2
rac2-> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:36:18 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 92274688 bytes
Fixed Size 1217884 bytes
Variable Size 65890980 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters and Data Mining options
--启动数据库
rac2-> export ORACLE_SID=devdb2
rac2-> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:39:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 1218436 bytes
Variable Size 83888252 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened
对RAC接触不多,今天在测试环境启动RAC失败,经过一番努力,总算解决问题.下面简单记录一下:
启动报错如下所示
rac2-> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:32:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora' ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.ora ORA-15077: could not locate ASM instance serving a required diskgroup SQL> exit Disconnected
--检查ASM实例运行情况
rac2-> srvctl status asm -n rac1
ASM 实例 +ASM1 正在节点 rac1 上运行。
rac2-> srvctl status asm -n rac2
ASM 实例 +ASM2 不在节点 rac2 上运行。
--可以看出,在节点2(也就是出问题的节点)上ASM实例并没有启动
--接着检查ASM磁盘组
[root@rac2 ~]# /etc/init.d/oracleasm listdisks
没有结果输出表示ASM磁盘组没有加载,之前配置ASM的时候已经配置了自动加载ASM,可能是因为其他原因没有加载成功.下面手工加载:
[root@rac2 ~]# /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: [ OK ]
Loading module "oracleasm": [ OK ]
Mounting ASMlib driver filesystem: [ OK ]
Scanning system for ASM disks: [ OK ]
--再查看ASM磁盘组信息:
[root@rac2 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
--可以看出,ASM磁盘组加载好了.
--下面要做的是启动ASM实例
rac2-> export ORACLE_SID=+ASM2
rac2-> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:36:18 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 92274688 bytes
Fixed Size 1217884 bytes
Variable Size 65890980 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters and Data Mining options
--启动数据库
rac2-> export ORACLE_SID=devdb2
rac2-> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:39:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 1218436 bytes
Variable Size 83888252 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened