The diskgroups are definitely mounted:
SQL> select name, state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
ACTIVE MOUNTED
ARCH MOUNTED
DATA MOUNTED
FRA MOUNTED
OCRVTG MOUNTED
and in ASMCMD I can see the correct controlfiles:
ASMCMD> pwd
+data/orcl/CONTROLFILE
ASMCMD> ls
current.334.821879157
ASMCMD> pwd
+arch/orcl/CONTROLFILE
ASMCMD> ls
current.272.820415093
On Tue, Jan 1, 2019 at 6:28 PM David Barbour <david.barbour1@xxxxxxxxx>
wrote:
Of Course. Happy New Year All.
Anyone run into this? Upgrading 12.1.0.2 to 12.2.01 on RAC w/ASM
ASM has been upgraded to 12.2.0 several weeks ago.
Installed new 12.2 software in new home. Altered spfile to cluster=FALSE,
moved password files, etc, shut down the instances, tried to start from the
new home and get this:
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 2.7488E+11 bytes
Fixed Size 29874920 bytes
Variable Size 3.2212E+10 bytes
Database Buffers 2.4213E+11 bytes
Redo Buffers 506994688 bytes
ORA-00205: error in identifying control file, check alert log for more info
Alert log shows:
Errors in file
/u01/app/oracle/diag/rdbms/orcl/ORCL1/trace/ORCL1_m000_11372.trc:
ORA-00202: control file: '+DATA/orcl/controlfile/current.334.821879157'
ORA-17503: ksfdopn:2 Failed to open file
+DATA/orcl/controlfile/current.334.821879157
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+ARCH/orcl/controlfile/current.272.820415093'
ORA-17503: ksfdopn:2 Failed to open file
+ARCH/orcl/controlfile/current.272.820415093
ORA-15001: diskgroup "ARCH" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
But the diskgroups are mounted:
ora.ARCH.dg
ONLINE ONLINE 685921-db5 STABLE
ONLINE ONLINE 685925-db6 STABLE
ora.DATA.dg
ONLINE ONLINE 685921-db5 STABLE
ONLINE ONLINE 685925-db6 STABLE
Ideas? Can't seem to find a similar issue with an exception that a TDE
Wallet is not configured properly. This database had a tablespace using
TDE over a year ago, but that has been eliminated and there is no wallet
any longer.