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.
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.