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

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

-- 
Mladen Gogala Database Consultant Tel: (347) 321-1217

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