Re: Upgrade Issue - ORA-00205: error in identifying control file
Date: Tue, 1 Jan 2019 18:46:05 -0600
Message-ID: <CAFH+ifdf1GJU4Djvc2g1rUQ+FaJCHW_nkN=tca20ePRUdQXL7g_at_mail.gmail.com>
The diskgroups are definitely mounted:
SQL> select name, state from v$asm_diskgroup;
and in ASMCMD I can see the correct controlfiles:
ASMCMD> pwd
On Tue, Jan 1, 2019 at 6:28 PM David Barbour <david.barbour1_at_gmail.com>
wrote:
> Of Course. Happy New Year All.
NAME STATE
------------------------------ -----------
ACTIVE MOUNTED
ARCH MOUNTED
DATA MOUNTED
FRA MOUNTED
OCRVTG MOUNTED
+data/orcl/CONTROLFILE
ASMCMD> ls
current.334.821879157
ASMCMD> pwd
+arch/orcl/CONTROLFILE
ASMCMD> ls
current.272.820415093
>
> 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.
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 02 2019 - 01:46:05 CET