ORA-00205: error in identifying control file, check alert log for more info.
When startup the databse getting error like ORA-00205
[oracle@db_ ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 27 21:18:15 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SYS@adjstage>startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2220200 bytes
Variable Size 855641944 bytes
Database Buffers 201326592 bytes
Redo Buffers 9748480 bytes
ORA-00205: error in identifying control file, check alert log for more info
Solution :-
Check the control file location.
SYS@adjstage>show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/datafile/adjstage_datafil
es/ADJSTAGE/controlfile/o1_mf_
7knp4dys_.ctl
Ensure control file exists in the respective locations.
Also check the permission for the file.
[root@db_ controlfile]# ll u01/datafile/adjstage_datafiles/ADJSTAGE/controlfile/o1_mf_7knp4dys_.ctl
-rw-r----- 1 oracle oinstall 14237696 Dec 27 22:38 o1_mf_7knp4dys_.ctl
[root@db_ controlfile]#
permission should be oracle:oinstall.
After checking the permission shutdown and startup the database.
Shutdown the database and start it up:
SYS@adjstage> shut immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@adjstage>startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2220200 bytes
Variable Size 855641944 bytes
Database Buffers 201326592 bytes
Redo Buffers 9748480 bytes
Database mounted.
Database opened.
SYS@adjstage>select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ADJSTAGE READ WRITE
