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