ORA-00205: error in identifying controlfile
DBA2011Aug 24 2006 — edited Apr 24 2009I 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