Hi im trying to create clone_link between two ora19 databases due to cloning PDB databases
both DBs have created user like:
CREATE USER c##remote_clone_user IDENTIFIED BY remote_clone_user CONTAINER=ALL;
GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO c##remote_clone_user CONTAINER=ALL;
i want to copy PDB from DB2 to DB1 so i closed wanted PDB on DB2 and opened for reading:
alter pluggable database testpdb close;
alter pluggable database testpdb open read only;
from DB1 have created clone_link and tried to copy PDB (tns testpdb connection is set to DB2)
--db link to database we want to copy
create database link clone_link
connect to C##remote_clone_user identified by remote_clone_user using 'testpdb';
-- clone from DB2 to DB1
create pluggable database testpdb from testpdb@clone_link
file_name_convert = ('/u01/app/oracle/oradata/', '/testpdb/');
but im getting error :
Error starting at line : 14 in command -
create pluggable database testpdb from testpdb@clone_link
file_name_convert = ('/u01/app/oracle/oradata/', '/testpdb/')
Error report -
ORA-65169: error encountered while attempting to copy file /u01/app/oracle/oradata/testpdb/testpdb_index.dbf
ORA-19504: failed to create file "/testpdb/testpdb/testpdb_index.dbf"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
65169. 00000 - "error encountered while attempting to copy file %s "
*Cause: An error was encountered while attempting to copy the file
while creating a pluggable database.
*Action: Check additional error messages for the cause of the failure to
copy the file, and resolve the issue accordingly.
in alert log i see only :
Undo Create of Pluggable Database TESTPDB with pdb id - 7.
**************************************************************
ORA-65169 signalled during: create pluggable database testpdb from testpdb@clone_link
file_name_convert = ('/u01/app/oracle/oradata/', '/testpdb/')...
i am not sure what permissions need to be set
Steps needed to alleviate this issue: This is a permissions issue and you need the /oradata/ directory to have permissions. Follow the steps below or better yet, create a script from the procedure below to resolve the issue:
So I updated the permissions on the file. It needs to have group write permissions:
Then it will work:
After creating, you can switch the permissions back to before. Although, this is a workaround, if you add it to a script, it works like magic!