0

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

Viktorbs
  • 1
  • 1
  • 2
  • 1
    `Error: 13: Permission denied` – Mat Apr 02 '20 at 10:06
  • thank you, but i need to know what Permission needs to be set – Viktorbs Apr 02 '20 at 10:19
  • 1
    Compare the owner/group/privs on `u01/app/oracle/oradata` and `/testpdb`. The Oracle OS account (running the DB processes) has to be able to read/write that directory (on all RAC nodes). – Alex Poole Apr 02 '20 at 10:20
  • looks like it is the same drwxr-x--- 2 oracle oinstall 4096 apr 2 11:54 testpdb/ drwxr-x--- 13 oracle oinstall 4096 apr 2 09:28 oradata/ – Viktorbs Apr 02 '20 at 10:24
  • What about other directories in the path: `/testpdb`, `/testpdb/testpdb` and any existing files under `/testpdb/testpdb/` ? – Alex Poole Apr 02 '20 at 10:35
  • so the issue was in file_name_convert = ('/u01/app/oracle/oradata/', '/testpdb/'); i was trying to convert oracle files into root .. :( – Viktorbs Apr 07 '20 at 08:31

1 Answers1

0

Its working for me in CDB

alter system set "_exadata_feature_on" =true scope=spfile;
shutdown immediate;
startup;
dmitryaivanov
  • 31
  • 3