In this Article we will Create RAC Database with PDBS using DBCA.

Step 1 : Once you use dbca , first screen that will open is as below select Create Database and click  next:

Step 2 : Select Advanced Mode and click Next

Step 3 : Select RAC database as database type and Admin Managed as Configuration type.

Step 4 : Give Global Database Name with No of PDBS you want and Prefix name for pdbs :

Step 5 : Select No of nodes for your RAC CDB :

Step 6 : Specify Management option for your database :

Step 7 : Specify Storage for all database files and recovery area as ASM .

Step 8 : Database vault option , click next .

Step 9 : Specify Memory option .I have used Automatics Memory Management.

Step 10 : Create Database , click next

Step 11 : It will display pre-requisites check .

There is warning so , I am ignoring ,click on ignore all and click next.

Step 12 : Check Summary of Database , It shows Global database name , Node list on which your rac database will be created , SID list – cdb11 and cdb12 and etc.

Step 13 : Check Progress of Container and Pluggable database creation.

Once , it is completed click on finish.

Step 14 : Connect to sqlplus with cdb11 sid and check details of pdbs and active instances .

[oracle@rac1 ~]$ export ORACLE_SID=cdb11
[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Mar 30 16:13:56 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME	  OPEN_MODE
--------- --------------------
CDB1	  READ WRITE

SQL> select * from v$active_instances;

INST_NUMBER INST_NAME
----------- ------------------------------------------------------------
    CON_ID
----------
	  1 rac1.localdomain:cdb11
	 0

	  2 rac2.localdomain:cdb12
	 0


SQL> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 DB1				  READ WRITE NO
	 4 DB2				  READ WRITE NO
SQL>

We can see here , cdb1 container database created with db1 and db2 pdbs and  RAC1 and RAC2 as active instances of database.

Stay tuned for More articles on Oracle RAC

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel : https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.