Advertisements

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

My server was having a problem with Oracle saying that is unable to create dump file and the filesystem was in a NFS share

Export: Release 11.2.0.2.0 – Production on Wed Dec 2 15:08:02 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file “/orabkp/hbr022/export/reeng/expdp_reeng.20151202150630_hbr022_9964.dmp”
ORA-27086: unable to lock file – already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10

Start the service nfslock and make sure after reboot it will be started

root@linux:~ # service nfslock start
root@linux:~ # chkconfig nfslock on

Advertisements
%d bloggers like this: