Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00205: error in identifying controlfile

DBA2011Aug 24 2006 — edited Apr 24 2009
I am having problem with control file, what is solution? all the 4 control file are present on OS

SQL> ALTER SYSTEM SET CONTROL_FILES="C:\oracle\oradata\Inf\CONTROL01.CTL","C:\oracle\oradata\Inf\CON
TROL02.CTL","C:\oracle\oradata\Inf\CONTROL03.CTL","C:\oracle\oradata\Inf\CONTROL04.CTL" SCOPE=SPFILE
;

System altered.

SQL> STARTUP FORCE;
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info


SQL> SHOW PARAMETER CONTROL_FILES;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string C:\oracle\oradata\Inf\CONTROL0
1.CTL, C:\oracle\oradata\Inf\C
ONTROL02.CTL, C:\oracle\oradat
a\Inf\CONTROL03.CTL, C:\oracle
\oradata\Inf\CONTROL04.CTL
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2009
Added on Aug 24 2006
7 comments
83,169 views