This is last part of my RAC lab series. I will show you step by step how to create simple container database.

RAC lab Part 1 – Installing the Ubuntu 16.04 desktop
RAC lab Part 2 – Virtualbox installation and configuration
RAC lab Part 3 – VMs configuration
RAC lab Part 4 – Installing the Openfiler software
RAC lab Part 5 – Installing OEL 7.x on VM
RAC lab Part 6 – OEL 7.x configuration for Oracle 12c GI & RAC DB installation
RAC lab Part 7 – Openfilers configuration and cloning
RAC lab Part 8 – OEL 7.x prepare storage
RAC lab Part 9 – Clone first RAC node as 2nd node and prepare config.
RAC lab Part 10 – Installing Grid Infrastructure
RAC lab Part 11 – Installing Database Software
RAC lab Part 12 – Creating a Container Database

 
 
Oracle 12c documentation
 
 
 
Create simple CDB
 
  • Run DBCA tool
[oracle@oel7rac1n1 database]$ /u01/app/oracle/product/12.1.0/dbhome_1/bin/dbca
 
  • Choose “create database”

1-step-1-screenshot-from-2016-12-05-16-07-45

  • Advanced mode to tweak settings

2-step-2-screenshot-from-2016-12-05-16-07-55

  • Custom database – we want dbca to generate db from scratch.

3-step-3-screenshot-from-2016-12-05-16-08-10

  • Set CDB name and choose to create PDB1 as single tenant

4-step-4-screenshot-from-2016-12-05-16-08-49

  • Select to run the db on all cluster nodes

5-step-5-screenshot-from-2016-12-05-16-08-59

  • Enable cluster verification utility to run from time to time

6-step-6-screenshot-from-2016-12-05-16-09-18

  • Set passwords for administrative users

7-step-7-screenshot-from-2016-12-05-16-10-50

  • Configure storage for database

8-step-8a-screenshot-from-2016-12-05-16-11-31

  • Ingore FRA warning, but first set recovery size to 3000, it should be enough for tests.

9-step-8b-screenshot-from-2016-12-05-16-11-56

  • We can’t disable any options so proceed

10-step-9-screenshot-from-2016-12-05-16-12-02

  • Disable Database Vault and Label security

11-step-10-screenshot-from-2016-12-05-16-12-14

  • Set memory for SGA and PGA (remember we don’t use AMM)

12-step-11a-screenshot-from-2016-12-05-16-19-20

  • Set number of processes and block size

13-step-11b-screenshot-from-2016-12-05-16-12-44

  • Set charset and national charset for your new DB.

14-step-11c-screenshot-from-2016-12-05-16-12-54

  • Dedicated server mode

15-step-11d-screenshot-from-2016-12-05-16-12-58

  • Create database

16-step-12-screenshot-from-2016-12-05-16-19-34

  • Check warnings, if not applicable ignore them

17-step-13-screenshot-from-2016-12-05-16-24-12

  • Summary screen

18-step-14-screenshot-from-2016-12-05-16-24-48

  • Creation process progress

19-step-15-screenshot-from-2016-12-05-16-31-59

  • Database successfully created.

20-step-16-screenshot-from-2016-12-05-19-33-27

 
 
What do you think?? Please post your comments :)
Source: My experience and WorlWideWeb

About the author

 
maciej tokar
Maciej Tokar

An Oracle technology geek and crazy long distance runner, DBA24 Owner
Senior Oracle DBA / Consultant / [OCP10g, OCP12c, OCE RAC 10g] / [experience: 9y+]
Currently working for Bluegarden (Oslo Norway) by Miratech Group
Past: Mastercard / Trevica by Britenet, Citi International PLC, PZU

 
View Maciej Tokar's profile on LinkedIn         logoDB4
LinkedIn Auto Publish Powered By : XYZScripts.com