Sql> Startup
ORACLE instance started.
Total System Global area 1854021632 bytes
Fixed Size 2242584 bytes
Variable Size 1136658408 bytes
Database buffers 708837376 bytes
Redo buffers 6283264 bytes
Ora-00205:error in identifying control file, check alert log for more info
View Alert logs
Sql> Select value from v$diag_info where name = ' Diag Alert ';
VALUE
-------------------------------------------------------------------------------
/data/oracle/ora11g/diag/rdbms/tjdb/tjdb/alert
[Email protected] ~]cd/data/oracle/ora11g/diag/rdbms/tjdb/tjdb/alert
[email protected] alert]# LL
? 102508
-rw-r-----. 1 Oracle Oinstall 10485978 12?. Log_16.xml
-rw-r-----. 1 Oracle Oinstall 10485945 1?. Log_17.xml
-rw-r-----. 1 Oracle Oinstall 10485763 2?. Log_18.xml
-rw-r-----. 1 Oracle Oinstall 10485996 3?. 8 Log_19.xml
-rw-r-----. 1 Oracle Oinstall 10485761 3?. Log_20.xml
-rw-r-----. 1 Oracle Oinstall 10485841 4?. 3 Log_21.xml
-rw-r-----. 1 Oracle Oinstall 10485932 4?. Log_22.xml
-rw-r-----. 1 Oracle Oinstall 10485792 7?. 4 17:42 Log_23.xml
-rw-r-----. 1 Oracle Oinstall 10485970 7?. 4 23:41 Log_24.xml
-rw-r-----. 1 Oracle Oinstall 10392897 10?. 09:20 Log.xml
[email protected] alert]# less log.xml
Alert Log Fragment:
Host_id= ' hrtestdb ' host_addr= ' 10.3.64.204 ' module= '
Pid= ' 7210 ' >
<txt>ora-00210:cannot Open the specified control file
Ora-00202:control File: '/data/oracle/ora11g/oradata/tjdb/control03.ctl'
Ora-27086:unable to lock File-already inch use
Linux-x86_64 Error:11:resource temporarily unavailable
Solve :
1. Use lsof or fuser to first query the processes that are using these files:
[email protected] ~]#fuser-m-v/data
Or
[email protected] ~]# lsof/data/oracle/ora11g/oradata/tjdb/control*
COMMAND PID USER FD TYPE DEVICE size/off NODE NAME
Oracle 8041 Oracle 256u REG 0,19 11026432 1867986/data/oracle/ora11g/oradata/tjdb/control01.ctl
Oracle 8041 Oracle 257u REG 0,19 11026432 1868772/data/oracle/ora11g/oradata/tjdb/control02.ctl
Oracle 8041 Oracle 258u REG 0,19 11026432 1868514/data/oracle/ora11g/oradata/tjdb/control03.ctl
Oracle 8043 Oracle 256u REG 0,19 11026432 1867986/data/oracle/ora11g/oradata/tjdb/control01.ctl
Oracle 8043 Oracle 257u REG 0,19 11026432 1868772/data/oracle/ora11g/oradata/tjdb/control02.ctl
Oracle 8043 Oracle 258u REG 0,19 11026432 1868514/data/oracle/ora11g/oradata/tjdb/control03.ctl
Oracle 8045 Oracle 256uW REG 0,19 11026432 1867986/data/oracle/ora11g/oradata/tjdb/control01.ctl
Oracle 8045 Oracle 257uW REG 0,19 11026432 1868772/data/oracle/ora11g/oradata/tjdb/control02.ctl
Oracle 8045 Oracle 258uW REG 0,19 11026432 1868514/data/oracle/ora11g/oradata/tjdb/control03.ctl
Oracle 8051 Oracle 258u REG 0,19 11026432 1867986/data/oracle/ora11g/oradata/tjdb/control01.ctl
Oracle 8051 Oracle 259u REG 0,19 11026432 1868772/data/oracle/ora11g/oradata/tjdb/control02.ctl
Oracle 8051 Oracle 260u REG 0,19 11026432 1868514/data/oracle/ora11g/oradata/tjdb/control03.ctl
Oracle 8278 Oracle 257u REG 0,19 11026432 1867986/data/oracle/ora11g/oradata/tjdb/control01.ctl
Oracle 8278 Oracle 258u REG 0,19 11026432 1868772/data/oracle/ora11g/oradata/tjdb/control02.ctl
Oracle 8278 Oracle 259u REG 0,19 11026432 1868514/data/oracle/ora11g/oradata/tjdb/control03.ctl
[Email protected] ~]# Ps-ef | Grep/data/oracle |grep-v grep |cut-c 9-15 |xargs kill-s 9
Or
[Email protected] ~]# lsof/data |cut-c 9-13 |xargs kill-s 9
2. uninstalling the file system
[email protected] ~]#unmount /data
3. remount The file system
The Mount NFS Directory method:
Mount-t NFS hostname (ORIP):/directory /mount/point
[Email protected] ~]# df-h
/dev/mapper/volgroup-lv_root 18G 4.4G 13G 27%/
Tmpfs 1.9G 1.8G 140M 93%/DEV/SHM
/DEV/SDA1 485M 37M 423M 8%/boot
10.5.6.250:/nfs/hrtestdb178G 74G 95G 44%/data
[email protected] ~]#mount-t nfs-o nolock 10.5.6.250:/nfs/hrtestdb /data
Ora-27086:unable to lock File-already inch use