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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)