Asset ID:	1-72-1905417.1
Update Date:	2016-07-06
Keywords:

---

Solution Type  Problem Resolution Sure

Solution  1905417.1 :   SuperCluster - "ORA-27086: Unable To Lock File - Already In Use" When Starting Database Zone.  

In this Document

Symptoms

Cause

Solution

References

---

Created from <SR 3-9154788861>

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Oracle SuperCluster M6-32 Hardware - Version All Versions to All Versions [Release All Releases]
Oracle SuperCluster T5-8 Full Rack - Version All Versions to All Versions [Release All Releases]
Oracle SuperCluster T5-8 Half Rack - Version All Versions to All Versions [Release All Releases]
SPARC SuperCluster T4-4 - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Symptoms

Trying to start database in a Solaris 11.1 SuperCluster Zone, Alert log shows the following:

ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u02/app/oracle/product/<dbname>/oradata/<instance_name>/control02.ctl'
ORA-27086: unable to lock file - already in use

Cause

The file system that  holds the controlfile and datafile are  an NFS   mount  from the ZFS device  in SuperCluster.

The problem happens  because  locks are not cleared  on  the  nfs mount
 
 

Solution

(1) Unmount the file systems once again.
(2) #clear_locks -s  <Name_of_NFS_Server>
(3) Mount the file systems back.
(4) Try starting the database instance.
 

References

<NOTE:429912.1> - ORA-01157 ORA-01110 ORA-27086 after crash prevents database from opening
<NOTE:444411.1> - OracleAS 10g OPMN Hangs / Times out - Log Shows "Address Already In Use", "Can't assign requested address", "Listener Bind failed"
<NOTE:1564912.1> - ORA-00202 & ORA-27086 Database startup fails after hardware failure
<NOTE:1591095.2> - Troubleshooting Assistant: Understand and Troubleshoot Startup/Shutdown Issues

Attachments

This solution has no attachment