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