Re: Upgrade Issue - ORA-00205: error in identifying control file

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_at_gmail.com> 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 | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/

--
http://www.freelists.org/webpage/oracle-l