Hi ,
Last week we had a preventive maintenance shutdown at our data center. After that activity when we tried to bring back our servers we started facing some issue in our Sandbox system which is running on Linux & Oracle.
We couldn't start the oracle server , we tried through sqlplus,
SQL> startup;
ORACLE instance started.
Total System Global Area 2298478592 bytes
Fixed Size 2085616 bytes
Variable Size 1157631248 bytes
Database Buffers 1124073472 bytes
Redo Buffers 14688256 bytes
ORA-00205: error in identifying control file, check alert log for more info
The alert log file has error "Permission denied"
Thu Jan 2 17:35:02 2014
ORA-00202: control file: '/oracle/R01/origlogB/cntrl/cntrlR01.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
Thu Jan 2 17:35:02 2014
ORA-205 signalled during: ALTER DATABASE MOUNT...
But cntrlR01.dbf has file permission 755...
ls -ltr
total 15044
-rwxr-xr-x 1 orar01 dba 15384576 Jan 2 16:44 cntrlR01.dbf
Even we tried after restoring the DB , but still facing the same issue. Any idea , how we can resolve this?
Go through the following checklist:
1. Make sure you set $ORACLE_SID and $ORACLE_HOME in you environment
variables.
2. Since you have restored the database you need to recreate the control
files, then recover the database using backup control file.
3. If you use BRTOOLS for the backup you can restore the control file from
the backup at the same time that you restore the DB, but you will still
need to "recover database using backup controlfile;"
4. If you did not have step #3 can still be done by creating a new
controlfile, but it gets complicated and you will need to know what you are
doing.