Re: ORA-00205: error in identifying control file

From: Eugene Pokopac <epokopac_at_gmail.com>
Date: Mon, 23 May 2011 07:32:45 -0700 (PDT)
Message-ID: <436451d2-68fe-4543-8fbb-fc31975d1689_at_v31g2000vbs.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>
ORA-00205 error in identifying controlfile, check alert log for more info

Cause: The system could not find a control file of the specified name and size.

Action: One of the following:

Check that the proper control file name is referenced in the CONTROL_FILES initialization parameter in the initialization parameter file and try again.

When using mirrored control files, that is, more than one control file is referenced in the initialization parameter file, remove the control file name listed in the message from the initialization parameter file and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file and create another copy of the control file with a new file name in the initialization parameter file. Received on Mon May 23 2011 - 09:32:45 CDT