ORA-27086 "Linux-x86_64 Error: 37" During dbms_dnfs.clonedb_renamefile
(Doc ID 1587173.1)
Last updated on MARCH 23, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.
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_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...
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |