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 18.104.22.168.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
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.
Oracle Data Pump – Export Import ( Expdp Impdp ) Tutorial with Examples-3
7,349 views last month, 1 views today