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

Source: Internet
Author: User

    • 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.