Upgrade Issue - ORA-00205: error in identifying control file
Date: Tue, 1 Jan 2019 18:28:19 -0600
Message-ID: <CAFH+ifeAThg9FTv6jixm6ruuKJxGWst-mTtffq7W-nsk9v_0+g_at_mail.gmail.com>
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 bytesORA-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 STABLEora.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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 02 2019 - 01:28:19 CET