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
