Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Create 12c CDB Database with DBCA

The database configuration assistant is the preferred tool for creating and configuring databases. It has been available for years and with every database version, it’s getting better and better. With the new multitenant architecture there are several new options with the DBCA wizard. In this article we will look at creating and configuring the CDB, using the DBCA.

Create 12c CDB Database with DBCA

The process of creating a CDB is very straightforward. The installation screens are pretty much the same as in the previous versions except for checking off a checkbox to let the DBCA know that database being created is a container database. When you are creating a CDB using OUI, you can only create one PDB – though you can add more later. Alternatively when you invoke DBCA separately after the installation, you can create multiple PDBs in one go.

Configuring CDB Database

Once the CDB has been created, it doesn’t mean that everything has been set and done. You can configure several options later on if you wish to. To configure a CDB you invoke the DBCA and following screen is presented.
Configure CDB 1

Choose the Configure database options and click Next.
Configure CDB 2
Choose the database that you want to configure, provide administrator credentials and click Next.
Configure CDB 3

Select the standard missing components if you want to install any of them. In our case all were installed already. Click Next.
Configure CDB 4

Select the additional options that you may want to configure like Label Security, Database Vault etc. Click Next when done.
Configure CDB 5

If you want to change the mode of the database then you can do it here. Click Next.
Configure CDB 6

If you are OK with the Summary screen, click on Finish. The DBCA will now configure the database for selected options.
Configure CDB 7

Once configuration is completed, click the OK button and the click on the Close to Exit the DBCA.


Popular posts from this blog

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

7 Steps to configure BDR replication in postgresql

Postgres Streaming Replication Configuration

vacuumlo - removing large objects orphans from a database PostgreSQL