Removing NFS Locks on Opensolaris / Nexenta (or handling ORA-27086: unable to lock file – already in use when using Oracle over NFS)
- Oracle running on Linux / Solaris
- Oracle data files and control file are stored on NFS
- NFS server used Opensolaris or Nexenta
ORA-00205: error in identifying controlfile, check alert log for more info ORA-00210: cannot open the specified control file ORA-00202: control file:: '/u02/oradata/ORA11P/control02.ctl' ORA-27086: unable to lock file - already in use Linux-x86_64 Error: 11: Resource temporarily unavailable Additional information: 8
Due to a database crash or unclean shutdown NFS locks were not properly release on storage side. You have to clean them manually in order to be able to startup the database again.
Step 1 – Remove NFS locks on Opensolaris / Nexenta side
root@nex2:/volumes# clear_locks oracle11 Clearing locks held for NFS client oracle11 on server nex2 clear of locks held for oracle11 on nex2 returned success
Note: It is NOT sufficient to enter the IP adress. You have to use the HOSTNAME here.
Step 2 – Mount & Open the database
oracle@oracle11:/u02/oradata/LIMSTEST> sqlplus / as sysdba SQL*Plus: Release 184.108.40.206.0 Production on Thu Apr 28 20:53:19 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Release 220.127.116.11.0 - 64bit Production SQL> alter database mount; Database altered. SQL> alter database open; Database altered.