Ora-27086:unable to lock File-already inch use

• Problem phenomenon:

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: &apos;/data/oracle/ora11g/oradata/tjdb/control03.ctl&apos;
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