Oracle Database 19c - How to Create Container Database in VirtualBox 6.1 in Laptop

Starting in Oracle Database 12c Release 1 (12.1), you must create a database as either a multitenant container database (CDB) or as an Oracle database that is non-CDB.

A pluggable database (PDB) is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. 

PDBs can be plugged into CDBs. A CDB can contain multiple PDBs. Each PDB appears on the network as a separate database.

Every CDB has the following containers:

• Exactly one root
  The root stores Oracle-supplied metadata and common users. An example of metadata is the source code for Oracle-supplied PL/SQL packages. A common user is a database user known in every container. The root container is named CDB$ROOT.
• Exactly one seed PDB
  The seed PDB is a system-supplied template that the CDB can use to create new PDBs. The seed PDB is named PDB$SEED. You cannot add or modify objects in PDB$SEED.
• Zero or more user-created PDBs
  A PDB is a user-created entity that contains the data and code required for a specific set of features. For example, a PDB can support a specific application, such as a human resources or sales application. No PDBs exist at creation of the CDB. You add PDBs based on your business requirements.

Installed Laptop Details

• OS Windows 10 Home 
• Memory(RAM) 16GB 
• Storage 1TB SSD

Required Software's

• Red Hat Enterprise Linux 7.5 - Download here
• Oracle VirtualBox 6.1 - Download here
• Oracle Database 19c - Download here

CDB creation procedure

• Install Oracle 19c binaries and Create Database
• Run DBCA
• We get below screen

Choose "Create a database"

Either you can choose "Typical Configuration" or "Advanced configuration". In my case selected "Advanced configuration"

Select "General Purpose or Transaction Processing"

Give "Global database name" in my case "orcl1". And PDB Name as "orcl1pdb"

Choose default and Proceed

Keep default values and click "Next"

Specify Network Configuration Details. In my case default and click "Next"

Here not creating any "Database Vault"

Configuration Options

Management Options. In my case not creating "Enterprise Manager"

Database User Credentials. In my case "same administrative password for all accounts"

Database Creation Option - Create database

Summary

Progress Page

Container database "orcl1" creation completed.

[code] set linesize 256 col name format a20 select con_id, dbid, name,open_mode, restricted, to_char(open_time, 'DD-MON-YY HH:MI:SS AM' ) open_time from v$containers; [/code]

[code] export ORACLE_SID=orcl1 sqlplus / as sysdba select instance_name, status from v$instance; set linesize 256 col name format a30 col pdb format a30 select name, pdb form v$services; alter session set container=orcl1pdb; show con_name [/code]