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.
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)