Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-27086: unable to lock file over NFS -- but it's NOT Netapp!

FredCMay 5 2008 — edited Jul 29 2012
My 10.2 database crashed, and when it came back I got the following error:

ORA-00202: control file: '/local/opt/oracle/product/10.2.0/dbs/lkFOOBAR'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 11: Resource temporarily unavailable

This is a classic symptom of a Netapp problem, which likes to hold file locks open on NFS mounts. There is a standard procedure for clearing those locks; see, for instance, document 429912.1 on Metalink.

Unfortunately, my files are mounted on an Isilon, one of Netapp's twisted cousins. I can find no references to "isilon" on Metalink, and we are at a loss how to resolve this.

My sysadmin assures me that "there are no locks on the Isilon". But I know this cannot be the case, because if I do the following:

1. delete the lockfile /local/opt/oracle/product/10.2.0/dbs/lkFOOBAR, and then
2. move my controlfiles aside, and then copy them back into place,

then the database will mount. However, it will not open, because now all the datafiles have locks.

Is there anyone with experience in clearing NFS locks? I know this is more of a SA task than DBA, but I am sure my SA has overlooked something.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2012
Added on May 5 2008
10 comments
38,106 views