Oracle 21c Database Creation through Manual Method | Oracle 21c Database Creation Step by Step Demo!

#OracleF1 #Oracle21c #Database_Creation #CATPROC #CATALOG

In this video, I will show how you can create Oracle 21c database in your VirtualBox environment for testing and lab purposes.

How to create your 21c Oracle Database in your Oracle VirtualBox VMs:

In my previous video, I demonstrated how to install Oracle 21c RDBMS binaries through silent mode.

Now that you have successfully deployed the binaries, the next step is to create a database.

Generally speaking, you would have 3 options to go..

1. Create a RMAN backup on DBaaS and restore it on your VM.
2. Create the Database using catalog / catproc approach.
3. Create with DBCA.

So, we are only left with option 1 or 2. I will go with option 2 as I want a brand new and clean one.

The High Level Steps are:

1. Create the parameter file.
2. Create SPFILE from PFILE
3. Startup the database with NOMOUNT
4. Create the database using CREATE DATABASE syntax.
5. Run CATALOG and CATPROC scripts on CDB e PDBS though CATCON.pl script.

Please follow my blog for complete steps and logs.

Hope this helps!

Cheers!
Ramesh.

Follow Me On: