19c - DBCA CONTAINER DATABASE INSTALLATION




In Oracle, typically we can create a database when you install the software. However if you either skipped the database creation part during installation or if you want to create one more database on the same host, then there are two ways of doing this.

  1. Database Configuration Assistant (DBCA) graphical tool.
  2. CREATE DATABASE SQL statement (Manual Method)

DBCA (database configuration assistant) is a utility provided by oracle to create and configure a database. Using DBCA we need not manually enter our steps, we can simply specify our requirements.

Step 1:Log in as the Oracle software owner.
Go to a command prompt.
Type dbca.




Step 2: Click on “create database and choose next




Step 3: Select the Advanced option.(Creation Mode)




Step 4: Optional database templates are shown below:(Database Type)
General Purpose
Data Warehouse
Custom Database
Choose “general purpose”




Step 5: A screen asks you to choose the database name. (Database Identification)

Fill in these fields:
Global Database Name:
SID
Create as container database
Select PDBName


Step 6:Select Database Storage Option as below


Step 7: Choose the below FAST RECOVERY OPTION


Step 8: in Network Configuration choose the default listener


Step 9: in DATA VAULT option deselect all selections


Step 10: Configuration Option -->choose automatic shared memory managment


Step 11: Management Option--> deselect the options


Step 12:Database User Credentials--> give the password for administrator




Step 13:Database Creation Option -->choose below option


Step 14: Summary






Step 15: Progress


Step 16: Check for progress update in trace path




Step 17: DB creation completed. Check for progress update in trace path




Step 18: Check for the list of database
“cat /etc/oratab”



Step 19: Initiating the Database, database ready for use