ORA-65169:试图复制文件时遇到的错误

Question

由于克隆PDB数据库，我试图在两个ora19数据库之间创建ora19。

这两个数据库都创建了如下用户：

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;

我想将PDB从DB2复制到DB1，所以我在DB2上关闭了想要的PDB，并打开阅读：

alter pluggable database testpdb close;
alter pluggable database testpdb open read only;

从DB1创建了clone_link并试图复制PDB (tns testpdb连接被设置为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/');

但我犯了错误：

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.

在警报日志中，我只看到：

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/')...

我不确定需要设置哪些权限。

Answer 1

它在国开行为我工作

alter system set "_exadata_feature_on" =true scope=spfile;
shutdown immediate;
startup;