My Oracle Support Banner

ORA-27086 "Linux-x86_64 Error: 37" During dbms_dnfs.clonedb_renamefile (Doc ID 1587173.1)

Last updated on JANUARY 24, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


You are running the following procedure to copy the datafile ( clonedb procedure given by dNFS, refer MOS Doc ID 1210656.1 ) and encountering errors



SQL> exec dbms_dnfs.clonedb_renamefile('/abc/bkp/data_AUDIT_TBS' , '/xyz/test/ora_data_testdb0.dbf');
BEGIN dbms_dnfs.clonedb_renamefile('/abc/bkp/data_AUDIT_TBS' , '/xyz/testdb/ora_data_testdb0.dbf'); END;

ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10
ORA-06512: at "SYS.X$DBMS_DNFS", line 10
ORA-06512: at line 1



You have checked NFS service is running

# service nfs status
rpc.mountd (pid 23126) is running...
nfsd (pid 23123 23122 23121 23120 23119 23118 23117 23116) is running...
rpc.rquotad (pid 23112) is running...






To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.