How to Build 18c RAC – 4 of 4 – Creating a RAC Database

  • by

Create a RAC Database

Check All Grid Services

Make sure everything is ready on grid-level.

[grid@primary01 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
ora.DATA.GHCHKPT.advm
               OFFLINE OFFLINE      primary01                STABLE
               OFFLINE OFFLINE      primary02                STABLE
ora.DATA.dg
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
ora.FRA.dg
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
ora.chad
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
ora.data.ghchkpt.acfs
               OFFLINE OFFLINE      primary01                STABLE
               OFFLINE OFFLINE      primary02                STABLE
ora.helper
               OFFLINE OFFLINE      primary01                IDLE,STABLE
               OFFLINE OFFLINE      primary02                IDLE,STABLE
ora.net1.network
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
ora.ons
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
ora.proxy_advm
               ONLINE  ONLINE       primary01                STABLE
               ONLINE  ONLINE       primary02                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       primary02                STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       primary01                STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       primary01                STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       primary01                169.254.13.192 192.1
                                                             68.24.11,STABLE
ora.asm
      1        ONLINE  ONLINE       primary01                Started,STABLE
      2        ONLINE  ONLINE       primary02                Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       primary01                STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       primary01                Open,STABLE
ora.primary01.vip
      1        ONLINE  ONLINE       primary01                STABLE
ora.primary02.vip
      1        ONLINE  ONLINE       primary02                STABLE
ora.qosmserver
      1        ONLINE  ONLINE       primary01                STABLE
ora.rhpserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       primary02                STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       primary01                STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       primary01                STABLE
--------------------------------------------------------------------------------

Database Configuration Assistant

Use DBCA to create a RAC database.

[oracle@primary01 ~]$ dbca
Oracle 18c DBCA - Create a RAC Database - Select Database Operation

Oracle 18c DBCA – Create a RAC Database – Select Database Operation

Oracle 18c DBCA - Create a RAC Database - Select Database Creation Mode

Oracle 18c DBCA – Create a RAC Database – Select Database Creation Mode

Oracle 18c DBCA - Create a Database - Select Database Deployment Type

Oracle 18c DBCA – Create a RAC Database – Select Database Deployment Type

Oracle 18c DBCA - Create a RAC Database - Select List of Nodes

Oracle 18c DBCA – Create a RAC Database – Select List of Nodes

Oracle 18c DBCA - Create a RAC Database - Specify Database Identification Details

Oracle 18c DBCA – Create a RAC Database – Specify Database Identification Details

Oracle 18c DBCA - Create a RAC Database - Select Database Storage Option

Oracle 18c DBCA – Create a RAC Database – Select Database Storage Option

Oracle 18c DBCA - Create a RAC Database - Select Database Storage Option - File Location Variables

Oracle 18c DBCA – Create a RAC Database – Select Database Storage Option – File Location Variables

Oracle 18c DBCA - Create a RAC Database - Select Database Storage Option - Click Next

Oracle 18c DBCA – Create a RAC Database – Select Database Storage Option – Click Next

Oracle 18c DBCA - Create a RAC Database - Select Fast Recovery Option

Oracle 18c DBCA – Create a RAC Database – Select Fast Recovery Option

Oracle 18c DBCA - Create a RAC Database - Select Oracle Data Vault Config Option

Oracle 18c DBCA – Create a RAC Database – Select Oracle Data Vault Config Option

Oracle 18c DBCA - Create a RAC Database - Specify Configuration Options - Memory

Oracle 18c DBCA – Create a RAC Database – Specify Configuration Options – Memory

Oracle 18c DBCA - Create a RAC Database - Specify Configuration Options - Sizing

Oracle 18c DBCA – Create a RAC Database – Specify Configuration Options – Sizing

Oracle 18c DBCA - Create a RAC Database - Specify Configuration Options - Character Sets

Oracle 18c DBCA – Create a RAC Database – Specify Configuration Options – Character Sets

Oracle 18c DBCA - Create a RAC Database - Specify Configuration Options - Connection Mode

Oracle 18c DBCA – Create a RAC Database – Specify Configuration Options – Connection Mode

Oracle 18c DBCA - Create a RAC Database - Specify Configuration Options - Sample Schemas

Oracle 18c DBCA – Create a RAC Database – Specify Configuration Options – Sample Schemas

Oracle 18c DBCA - Create a RAC Database - Specify Management Options

Oracle 18c DBCA – Create a RAC Database – Specify Management Options

Oracle 18c DBCA - Create a RAC Database - Specify Database User Credentials

Oracle 18c DBCA – Create a RAC Database – Specify Database User Credentials

Oracle 18c DBCA - Create a RAC Database - Specify Database User Credentials - DBT-06208

Oracle 18c DBCA – Create a RAC Database – Specify Database User Credentials – DBT-06208

Oracle 18c DBCA - Create a RAC Database - Select Database Creation Option

Oracle 18c DBCA – Create a RAC Database – Select Database Creation Option

Oracle 18c DBCA - Create a RAC Database - Select Database Creation Option - Customize Storage Locations - Control Files

Oracle 18c DBCA – Create a RAC Database – Select Database Creation Option – Customize Storage Locations – Control Files

Oracle 18c DBCA - Create a RAC Database - Select Database Creation Option - Customize Storage Locations - Redo Log Groups

Oracle 18c DBCA – Create a RAC Database – Select Database Creation Option – Customize Storage Locations – Redo Log Groups

Oracle 18c DBCA - Create a RAC Database - Select Database Creation Option - Customize Storage Locations - Add Redo Log Group

Oracle 18c DBCA – Create a RAC Database – Select Database Creation Option – Customize Storage Locations – Add Redo Log Group

Oracle 18c DBCA - Create a RAC Database - Select Database Creation Option - Customize Storage Locations - Redo Log Groups - Change All Size to 1GB

Oracle 18c DBCA – Create a RAC Database – Select Database Creation Option – Customize Storage Locations – Redo Log Groups – Change All Size to 1GB

Oracle 18c DBCA - Create a RAC Database - Select Database Creation Option - Customize Storage Locations - Redo Log Groups - Apply All Size to 1GB

Oracle 18c DBCA – Create a RAC Database – Select Database Creation Option – Customize Storage Locations – Redo Log Groups – Apply All Size to 1GB

Oracle 18c DBCA - Create a RAC Database - Select Database Creation Option - Customize Storage Locations - Redo Log Groups - New Size Saved

Oracle 18c DBCA – Create a RAC Database – Select Database Creation Option – Customize Storage Locations – Redo Log Groups – New Size Saved

Oracle 18c DBCA - Create a RAC Database - Select Database Creation Option - Click Next

Oracle 18c DBCA – Create a RAC Database – Select Database Creation Option – Click Next

Oracle 18c DBCA - Create a RAC Database - Perform Prerequisite Checks

Oracle 18c DBCA – Create a RAC Database – Perform Prerequisite Checks

Oracle 18c DBCA - Create a RAC Database - Summary - 1 of 3

Oracle 18c DBCA – Create a RAC Database – Summary – 1 of 3

Oracle 18c DBCA - Create a RAC Database - Summary - 2 of 3

Oracle 18c DBCA – Create a RAC Database – Summary – 2 of 3

Oracle 18c DBCA - Create a RAC Database - Summary - 3 of 3

Oracle 18c DBCA – Create a RAC Database – Summary – 3 of 3

Oracle 18c DBCA - Create a RAC Database - Summary - Save Response File

Oracle 18c DBCA – Create a RAC Database – Summary – Save Response File

Oracle 18c DBCA - Create a RAC Database - Summary - Click Finish

Oracle 18c DBCA – Create a RAC Database – Summary – Click Finish

Oracle 18c DBCA - Create a RAC Database - Creation is Progressing

Oracle 18c DBCA – Create a RAC Database – Creation is Progressing

Oracle 18c DBCA - Create a RAC Database - Database Creation Complete

Oracle 18c DBCA – Create a RAC Database – Database Creation Complete

Leave a Reply

Your email address will not be published. Required fields are marked *