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

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

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_D-TOSG1ECI_I-2880258847_TS-AUDIT_TBS_FNO-6_9pokb24c' , '/xyz/testdb/ora_data_testdb0.dbf');
BEGIN dbms_dnfs.clonedb_renamefile('/abc/bkp/CLONEDBBKP/data_D-TOSG1ECI_I-2880258847_TS-AUDIT_TBS_FNO-6_9pokb24c' , '/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...

 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms