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!

error in identifying control file; during startup, SOLVED

DrBugsJun 2 2007 — edited Jun 7 2007
Virag_Sh: Thanks for your valuable inputs.

Oracle is not able to identify the control files on startup.
[oracle@localhost ~]$ sqlplus sys/change_on_install as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 2 11:36:25 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 88080384 bytes
Fixed Size 1217836 bytes
Variable Size 79694548 bytes
Database Buffers 4194304 bytes
Redo Buffers 2973696 bytes
ORA-00205: error in identifying control file, check alert log for more info

initTSH1.ora file contents:
CONTROL_FILES = ("/boot/u01/app/oracle/oradata/orcl/control1.ctl","/boot/u01/app/oracle/oradata/orcl/control2.ctl","/boot/u01/app/oracle/oradata/orcl/control3.ctl"

And here are the control files:
[oracle@localhost orcl]$ pwd
/boot/u01/app/oracle/oradata/orcl
[oracle@localhost orcl]$ ls -l | grep ctl
-rw-r----- 1 oracle oinstall 7061504 May 31 15:19 control01.ctl
-rw-r----- 1 oracle oinstall 7061504 May 31 15:19 control02.ctl
-rw-r----- 1 oracle oinstall 7061504 May 31 15:19 control03.ctl

Message was edited by:
user545563
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2007
Added on Jun 2 2007
33 comments
5,867 views