Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step
Today I start with first 20c database creation and would like to share how its look like the entire process for create of new CDB database
This will be the first step to test upgrade from 12.2 to 20c which will be available here very soon
Create a database
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_01.png/fit-1280x720.png?mtime=1581896393)
Advanced Configuration
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_02.png/fit-1280x720.png?mtime=1581896393)
Oracle Single Instance Database, General Purpose
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_03.png/fit-1280x720.png?mtime=1581896393)
Global Database Name,SID, Use Local Undo tablespace for PDB`s, Create a Container database with one or more PDB`s, Number of PDB`s =1, PDB name = PDB20C
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_04.png/fit-1280x720.png?mtime=1581896393)
Use following for the database storage location, file system, Database files location, Use Oracle-Managed files (OMF)
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_05.png/fit-1280x720.png?mtime=1581896393)
Specify Fast Recovery Area, Recovery Area location
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_06.png/fit-1280x720.png?mtime=1581896393)
Select Listener or create a new one
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_07.png/fit-1280x720.png?mtime=1581896393)
You can configure Database Vault, Label Security
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_08.png/fit-1280x720.png?mtime=1581896394)
Keep the default memory allocation, in case of need you can change the type and allocation
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_10.png/fit-1280x720.png?mtime=1581896394)
You cannot change block size, but you can add a bigger number of process in case of needs
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_11.png/fit-1280x720.png?mtime=1581896394)
Keep the default
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_12.png/fit-1280x720.png?mtime=1581896394)
Keep the default
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_13.png/fit-1280x720.png?mtime=1581896394)
If you need sample schema you can tick on this option
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_14.png/fit-1280x720.png?mtime=1581896394)
Configure Enterprise Manager (EM) Database Express - add a port number of keep default
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_15.png/fit-1280x720.png?mtime=1581896394)
Add a password for all users
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_16.png/fit-1280x720.png?mtime=1581896394)
This is all listed Parameters if you need you can change here
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_17.png/fit-1280x720.png?mtime=1581896394)
You can review all location and creation or tablespace and redo logs etc
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_18.png/fit-1280x720.png?mtime=1581896394)
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_19.png/fit-1280x720.png?mtime=1581896395)
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_20.png/fit-1280x720.png?mtime=1581896395)
Generate Database Creation Scripts - yes
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_21.png/fit-1280x720.png?mtime=1581896395)
Overview of all configuration - Finish
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_22.png/fit-1280x720.png?mtime=1581896395)
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_23.png/fit-1280x720.png?mtime=1581896395)
Process of DB creation starts and you have to wait for a few minutes
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_24.png/fit-1280x720.png?mtime=1581896395)
Done
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_25.png/fit-1280x720.png?mtime=1581897608)
Open the web browser and try to access DB express https://<hostname>:5501/em
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_26.png/fit-1280x720.png?mtime=1581897937)
![Oracle Database 20c in the Cloud - Create Database - DBCA - Step by Step](https://blog.dba.bg/media/blogs/kkovachki/quick-uploads/p219/_evocache/oracle_20c_create_database_27.png/fit-1280x720.png?mtime=1581897937)
Have fun with newly create 20c Database