I was creating a CDB database when I got the following error:
Why did I get this error? Because I forgot to add the enable_pluggable_database parameter with the value to TRUE in the parameter file. Therefore, Oracle understood that I was creating a NON-CDB database instead of a CDB. After I added the parameter in the parameter file, it was possible to continue with the creation of the CDB database.
- enable_pluggable_database parameter with the value to TRUE
- Restating the instance with the new parameter:
- Creating the CDB database again:
- Run the catcdb.sql SQL script. This script installs all of the components required by a CDB.
Enter the following in SQL*Plus to run the script:
Estava criando um banco de dados CDB quando recebir o seguinte erro:
Por que recebi este erro? Porque esqueci de acrescentar o parâmetro enable_pluggable_database com o valor de TRUE no parameter file. Com isso, o Oracle entendeu que eu estava criando um banco de dados NON-CDB ao invés de um CDB. Após eu acrescentar o parâmetro no banco parameter file, foi possível continuar com a criação do banco de dados CDB.
- Configure o valor TRUE para o parâmetro enable_pluggable_database no parameter file.
- Reinicialize a instância com o novo parâmetro:
- Crie o banco de dados CDB de novo:
- Este script install todos os componentes que um banco de dados do tipo CDB requer.
*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.