[Solved] Issue: ORA-01031: insufficient privileges creating a new PDB

Ao tentar criar o novo PDB com origem remota, via DB_LINK, me deparei com o erro abaixo:

SQL> ALTER SESSION SET CONTAINER=CDB$ROOT;
 
Session altered.
 
SQL> SHO CON_NAME CON_ID
 
CON_NAME
------------------------------
CDB$ROOT
 
CON_ID
------------------------------
1
SQL> CREATE DATABASE LINK ROOT_DBLINK CONNECT TO system IDENTIFIED BY oracle USING 'TALAMO';
 
Database link created.
 
SQL> SELECT * FROM DUAL@ROOT_DBLINK;
 
D
-
X
 
SQL> CREATE PLUGGABLE DATABASE HIPOFISE4 FROM HIPOFISE3@ROOT_DBLINK;
CREATE PLUGGABLE DATABASE HIPOFISE4 FROM HIPOFISE3@ROOT_DBLINK
*
ERROR at line 1:
ORA-17628: Oracle error 1031 returned by remote Oracle server
ORA-01031: insufficient privileges

Encontrei a nota “ORA-01031: insufficient privileges creating pluggable database from a seed (Doc ID 2386084.1)“, que menciona que é necessário dar o grant de CREATE PLUGGABLE DATABASE para o usuário SYSTEM. Fazendo o processo:

SQL> ALTER SESSION SET CONTAINER=HIPOFISE3;
 
Session altered.
 
SQL> grant CREATE PLUGGABLE DATABASE to system;
 
Grant succeeded.

Disparando novamente o comando:

SQL> ALTER SESSION SET CONTAINER=CDB$ROOT;
 
Session altered.
 
SQL> CREATE PLUGGABLE DATABASE HIPOFISE4 FROM HIPOFISE3@ROOT_DBLINK;
 
Pluggable database created.

Leave a Comment Cancel Reply