“ORA-65011: Pluggable database does not exist” while cloning a NON-CDB into a PDB

I was cloning an Oracle NON-CDB database to a PDB when I get the following error:

SQL> CREATE PLUGGABLE DATABASE PDB_ORCL2 FROM NON$CDB@link_orcl2 CREATE_FILE_DEST=’/u01/app/oracle/oradata/dbc2/pdb2_2′;
CREATE PLUGGABLE DATABASE PDB_ORCL2 FROM NON$CDB@link_orcl2 CREATE_FILE_DEST=’/u01/app/oracle/oradata/dbc2/pdb2_2′
*
ERROR at line 1:
ORA-17628: Oracle error 65011 returned by remote Oracle server
ORA-65011: Pluggable database does not exist.

I checked and the connection to the DB_LINK created to access the NON-CDB was OK:

SQL> select * FROM dual@link_orcl2;

D
–
X

N

This error happens because you are probably trying to clone a CDB database to a PDB and this can be queried using SQL below:

SQL> select cdb, open_mode, name from v$database;

CDB OPEN_MODE NAME
— ——————– ———
YES READ WRITE ORCL2

When a database is created as a CDB it can not be a PDB and vice versa. So, I suggest creating a new database, really a NON-CDB, and do the operation again.

Eu estava clonando um banco de dados Oracle NON-CDB para um PDB quando recebir o seguinte erro:

SQL> CREATE PLUGGABLE DATABASE PDB_ORCL2 FROM NON$CDB@link_orcl2 CREATE_FILE_DEST=’/u01/app/oracle/oradata/dbc2/pdb2_2′;
CREATE PLUGGABLE DATABASE PDB_ORCL2 FROM NON$CDB@link_orcl2 CREATE_FILE_DEST=’/u01/app/oracle/oradata/dbc2/pdb2_2′
*
ERROR at line 1:
ORA-17628: Oracle error 65011 returned by remote Oracle server
ORA-65011: Pluggable database does not exist.

Verifiquei e a conexão com o DB_LINK criado para acessar o NON-CDB estava OK:

SQL> select * FROM dual@link_orcl2;

D
–
X

N

Este erro acontece porque provavelmente você está tentando clonar um banco de dados CDB para um PDB e isso pode ser consultado utilizando o SQL abaixo:

SQL> select cdb, open_mode, name from v$database;

CDB OPEN_MODE NAME
— ——————– ———
YES READ WRITE ORCL2

Quando um banco de dados é criado como um CDB ele não pode ser um PDB e vice-versa. Sendo assim, sugiro criar um novo banco de dados só que realmente um NON-CDB e refazer a operação.

Related posts

Leave a Comment