error in identifying control file; during startup, SOLVED
DrBugsJun 2 2007 — edited Jun 7 2007Virag_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