How to Create RAC Database 12cR2

Step by Step instruction to Create 12c RAC Database

Once you are done with Grid Infrastructure Installation and Oracle DB Binary Installation you are ready create your first RAC database.

Step1: Execute DBCA from ORACLE_HOME/bin and follow the GUI instruction as shown below

cd /u01/app/oracle/product/12.2.0.2/db1

./dbca

choose create database and click Next

Choose advanced Configuration and click Next

Click Next

Select all the nodes on which you want to create the database and click Next

Choose appropriate (As per your requirement)Value for each field and Click Next

Choose the Appropriate Disk Group (in my case it is DATA) and click Next

You can enable the archivelog and specify the FRA (Flash Recovery Area) Location and Size. In this example I kept the archiving disabled. If left disabled you can enable it later

 Choose appropriate Memory Options and define the required charaterset from Character Set Tab and click Next

if you do not want to configure EM Express then untick it and click Next

Enter the Password and click Next

Click Next

Click finish to create the database

Post successfull database creation validate the log files under $ORACLE_BASE/ cfgtoollogs/dbca/  (in my case /u01/app/oracle/cfgtoollogs/dbca/orcl)  and ensure there is no error.

Check the Status of the Database

Check the availibility of the database

$ srvctl status database -d orcl
Instance orcl1 is running on node node1
Instance orcl2 is running on node node2

check the configuration of the database

[oracle@node1 orcl]$ srvctl  config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/12.2.0.2/db1
Oracle user: oracle
Spfile: +DATA/ORCL/PARAMETERFILE/spfile.272.947351843
Password file: +DATA/ORCL/PASSWORD/pwdorcl.256.947351319
Domain: oracle.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances: ORCL1,ORCL2
Configured nodes: node1,node2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed