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.
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)