ORA-27086: unable to lock file over NFS -- but it's NOT Netapp!
FredCMay 5 2008 — edited Jul 29 2012My 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