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

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 1 Jan 2019 21:20:44 -0500
Message-ID: <a3e4cb96-22e7-9ada-9f50-0d854074579e_at_gmail.com>


Hi David!

Please check out the value of the control_files instance parameter and use asmcmd to check whether the file exists. It sounds as if your control file was re-created, or at least if the new instance of the control file was created. I am not sure why would that happen, but it's worth checking out. ASM files never get overwritten, a new instance gets created. I assume that this is a RAC database? Does this happen with all instances or just one? That is the reason why I prefer ACFS over the plain ASM.

Regards

On 1/1/19 7:28 PM, David Barbour 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.
>
>
>

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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 02 2019 - 03:20:44 CET

Original text of this message