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

 

 

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
If it is not started, then start it as follows.
# /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

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *