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

I got ” ORA-27086: unable to lock file – already in use | ORA-31641 ORA-39000  ” error in Oracle database during the expdp running.

 

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

 

Details of error are as follows.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/zfs/export/MSDBA_SCHEMA01.dmp"
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10

 

If you want to learn more details about Export import, read the following tutorial series.

Oracle Data Pump – Export Import ( Expdp Impdp ) Tutorial with Examples-4

See more

 

 

ORA-31641: unable to create dump file | ORA-39000: bad dump file specification

This ORA-27086 , ORA-31641, ORA-39000 errors are related with the NFS Lock Service or NFS Mount permissions.

 

Firstly Check NFSLock service like following.

# service nfslock status

rpc.statd is stopped

# /etc/init.d/nfslock start
Starting NFS statd:                      [ OK ]

 

And run the following command to start nfslock service automatically when the server reboot.

# chkconfig nfslock on

 

Other case; On Oracle Linux, when making use of NFS and an Oracle Database, the database may report :

ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 37: No locks available

 

Bug in nfs-utils package

Bug 8727960 : LX64: DATAFILES ON NFS, ORA-01157: CANNOT IDENTIFY/LOCK DATA FILE 202 (unpublished Bug) 

 

To solve this error,  Upgrade to nfs-utils-1.0.9-66 or later

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 

Oracle Data Pump – Export Import ( Expdp Impdp ) Tutorial with Examples-3

See more