远程克隆non-CDB orcl报错：ORA-17628: Oracle error 1031 returned by remote Oracle server ORA-01031: insufficient privileges...

报错信息

远程克隆non-CDB orcl报错

SYS@cdb3> create pluggable database pdb4 from non$cdb@lk_orcl file_name_convert=('/u01/app/oracle/oradata/ORCL','/u01/app/oracle/oradata/CDB3/pdb4');
create pluggable database pdb4 from non$cdb@lk_orcl file_name_convert=('/u01/app/oracle/oradata/ORCL','/u01/app/oracle/oradata/CDB3/pdb4')
*
ERROR at line 1:
ORA-17628: Oracle error 1031 returned by remote Oracle server
ORA-01031: insufficient privileges

 

解决方法

到源数据库里面针对orcl数据库，授权SYSTEM用户create pluggable database权限即可

SYS@orcl> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@orcl> startup;
ORACLE instance started.

Total System Global Area 1660940992 bytes
Fixed Size            8897216 bytes
Variable Size          973078528 bytes
Database Buffers      671088640 bytes
Redo Buffers            7876608 bytes
Database mounted.
Database opened.
SYS@orcl> select * from dba_sys_privs where GRANTEE='SYSTEM';

GRANTE PRIVILEGE                ADM COM INH
------ ---------------------------------------- --- --- ---
SYSTEM GLOBAL QUERY REWRITE            NO  YES YES
SYSTEM CREATE TABLE                NO  YES YES
SYSTEM DEQUEUE ANY QUEUE            YES YES YES
SYSTEM ENQUEUE ANY QUEUE            YES YES YES
SYSTEM SELECT ANY TABLE             NO  YES YES
SYSTEM MANAGE ANY QUEUE             YES YES YES
SYSTEM UNLIMITED TABLESPACE            NO  YES YES
SYSTEM CREATE MATERIALIZED VIEW         NO  YES YES

8 rows selected.

SYS@orcl> grant create pluggable database to system;

Grant succeeded.

SYS@orcl> select * from dba_sys_privs where GRANTEE='SYSTEM';

GRANTE PRIVILEGE                ADM COM INH
------ ---------------------------------------- --- --- ---
SYSTEM CREATE PLUGGABLE DATABASE        NO  NO    NO
SYSTEM GLOBAL QUERY REWRITE            NO  YES YES
SYSTEM CREATE TABLE                NO  YES YES
SYSTEM DEQUEUE ANY QUEUE            YES YES YES
SYSTEM ENQUEUE ANY QUEUE            YES YES YES
SYSTEM SELECT ANY TABLE             NO  YES YES
SYSTEM MANAGE ANY QUEUE             YES YES YES
SYSTEM UNLIMITED TABLESPACE            NO  YES YES
SYSTEM CREATE MATERIALIZED VIEW         NO  YES YES

9 rows selected.

SYS@orcl> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@orcl> startup mount;
ORACLE instance started.

Total System Global Area 1660940992 bytes
Fixed Size            8897216 bytes
Variable Size          973078528 bytes
Database Buffers      671088640 bytes
Redo Buffers            7876608 bytes
Database mounted.
SYS@orcl> alter database open read only;

Database altered.

再次执行，执行成功：

SYS@cdb3> create pluggable database pdb4 from non$cdb@lk_orcl file_name_convert=('/u01/app/oracle/oradata/ORCL','/u01/app/oracle/oradata/CDB3/pdb4');

Pluggable database created.