Re: ORA-00205: error in identifying control file

From: onedbguru <onedbguru_at_yahoo.com>
Date: Sat, 21 May 2011 14:25:04 -0700 (PDT)
Message-ID: <dd8cb755-5cc7-456e-9aaa-23bf280d677f_at_j23g2000yqc.googlegroups.com>

On May 21, 10:24 am, happy <ehabaziz2..._at_gmail.com> wrote:
> SQL> startup
> ORACLE instance started.
>
> Total System Global Area 96468992 bytes
> Fixed Size 1278688 bytes
> Variable Size 88083744 bytes
> Database Buffers 4194304 bytes
> Redo Buffers 2912256 bytes
> ORA-00205: error in identifying control file, check alert log for more
> info
>
> SQL> SHOW PARAMETERS control_files
>
> NAME TYPE VALUE
> ----------- control_files string /opt/oracle/102/dbs/ora_contro
> l1, /opt/oracle/102/dbs/ora_co
> ntrol2
> SQL> SELECT VALUE
> FROM V$PARAMETER
> WHERE NAME = 'control_files'
> /
> 2 3 4
> VALUE
> /opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2
>
> SQL>
so, do the control files exist? What did you do before you got this error message? Restore database/controlfiles? if they exist, are they the correct controlfiles and does they have the correct ownership/ permissions? Received on Sat May 21 2011 - 16:25:04 CDT