RAC

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

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 *