Yes, the discrepancy there may cause such an effect. You are right.
Regards
On 1/2/2019 3:31 AM, Stefan Knecht wrote:
What are your compatible settings?--
compatible.rdbms on the diskgroups, and compatible in the init.ora of the database?
Stefan
On Wed, Jan 2, 2019 at 7:29 AM David Barbour <david.barbour1@xxxxxxxxx <mailto: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.
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net <http://zztat.net/> | @zztat_oracle | fb.me/zztat <http://fb.me/zztat> | zztat.net/blog/ <http://zztat.net/blog/>
