Hello ,
this is 11.2.0.3 on Windows 2008 ,
a 3 node RAC with ASM.
After restarting the server where third instance is,
I have the following situation , everything is up except the database
on the third node , from the node 1 and 2 database is opened , every other service is also up and running.
crsctl stat res -t
ora.bigdb.db
1 ONLINE INTERMEDIATE bigdb3 Dismounted,Mount In
itiated
2 ONLINE ONLINE bigdb2 Open
3 ONLINE ONLINE bigdb1 Open
When I try to query database from the third node , I got message that the database is not mounted ,
C:\>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 26 15:47:25 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select count(*) from v$database;
select count(*) from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
When querying ASM instance on that node seems there is nothing wrong, all disks are mounted.
C:\>set ORACLE_SID=+ASM3
C:\>sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 26 15:49:51 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
ARC MOUNTED
CRS MOUNTED
DG1 MOUNTED
DG2 MOUNTED
DG3 MOUNTED
SQL>
And this is from the alert log of the third instance.
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+ARC/control02.ctl'
ORA-17503: ksfdopn:2 Failed to open file +ARC/control02.ctl
ORA-15001: diskgroup "ARC" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DG3/bigdb/control01.ctl'
ORA-17503: ksfdopn:2 Failed to open file +DG3/bigdb/control01.ctl
ORA-15001: diskgroup "DG3" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-205 signalled during: alter database mount exclusive...
Please suggest what can be done to open database from the third node.