Linux-x86_64 Error: 11: Resource temporarily unavailable / ORA-27086: unable to lock file

ORA-27086: unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Scenario

Today I am having a issue on mounting the standby database, but I am not able to, the reason is that oracle not able to find the control file.  But the control files is exists.

Means OS is not able to use the control file as its is in lock position.  So what should we do in that case.

Approach :

1.   shutdown the instance

2.   Go the location where control file exists

3.   Move the controlfile to new name and then revert to existing name

4.   Start the database

Note :

This solution is also work for all database.

Problem

SQL> startup mount

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area  217157632 bytes

Fixed Size                  2251816 bytes

Variable Size             159384536 bytes

Database Buffers           50331648 bytes

Redo Buffers                5189632 bytes

ORA-00205: error in identifying control file, check alert log for more info

from the alert  logfile

ORACLE_BASE from environment = /u01/app/oracle

Tue Jun 07 21:07:14 2016

DMON started with pid=17, OS id=12540

Tue Jun 07 21:07:14 2016

ALTER DATABASE   MOUNT

ORA-00210: cannot open the specified control file

ORA-00202: control file: '/u01/app/ORADATA/STBY/controlfile/o1_mf_c001bldt_.ctl'

ORA-27086: unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

Additional information: 2577

ORA-205 signalled during: ALTER DATABASE   MOUNT...

Tue Jun 07 21:07:16 2016

PING[ARC2]: Heartbeat failed to connect to standby 'STBY'. Error is 16047.

Tue Jun 07 21:08:16 2016

PING[ARC2]: Heartbeat failed to connect to standby 'STBY'. Error is 16047.

Tue Jun 07 21:08:38 2016

alter database mount

ARCH: STARTING ARCH PROCESSES

Solution :

Go to the location where controlfile exists.

vm225:STBY> cd /u01/app/ORADATA/STBY/controlfile/

vm225:STBY>

vm225:STBY>

vm225:STBY>

vm225:STBY> ls -ltr

total 48760

-rw-r-----. 1 oracle oinstall  9748480 Sep 21  2015 o1_mf_c001bldt_.ctl_old

-rw-r-----. 1 oracle oinstall 10043392 Sep 23  2015 o1_mf_c001bldt_.ctl_old_file

-rw-r-----. 1 oracle oinstall 10043392 Sep 23  2015 o1_mf_c001bldt_.ctl_12345

-rw-r-----. 1 oracle oinstall 10043392 Jun  7 21:08 o1_mf_c001bldt_.ctl

vm225:STBY> mv o1_mf_c001bldt_.ctl old_o1_mf_c001bldt_.ctl

vm225:STBY> cp old_o1_mf_c001bldt_.ctl o1_mf_c001bldt_.ctl

vm225:STBY> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 7 21:08:34 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database mount ;

Database altered.