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 Creation Mode
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 - 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 - File Location Variables
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 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 - Sizing
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 - Sample Schemas
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 - DBT-06208
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 - 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 - 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 - New Size Saved
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 - Summary - 1 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 - Save Response File
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 - Database Creation Complete