Close Menu
  • Home
  • Oracle
    • ASM
    • Data Guard
    • OEM
    • RAC
  • MongoDB
  • Performance
  • Python
  • Shell Script
  • Tools
  • Troubleshooting
Search

Oracle SQL Patch: Inject Optimizer Hints Without Changing Code

2026-06-13 Performance By Henrique

Oracle ACCOUNT_STATUS: What Each Value Means

2026-06-04 Oracle By Henrique

Oracle RAC 12.2 on VMware Workstation- Post 5: Final Validation and Quick Reference

2026-05-11 Oracle By Henrique
YouTube LinkedIn RSS
  • Home
  • About
  • Contact
  • Legal
    • Cookie Policy
    • Disclaimer
    • Privacy Policy
    • Terms of Use
  • RSS
  • English
    • Portuguese (Brazil)
Execute StepExecute Step
YouTube LinkedIn RSS
  • Home
  • Oracle
    • ASM
    • Data Guard
    • OEM
    • RAC
  • MongoDB
  • Performance
  • Python
  • Shell Script
  • Tools
  • Troubleshooting
Execute StepExecute Step
Home » Oracle RAC 12.2 on VMware Workstation – Post 4: Oracle Database Installation and DBCA
Oracle RAC

Oracle RAC 12.2 on VMware Workstation – Post 4: Oracle Database Installation and DBCA

HenriqueBy Henrique2026-05-11Updated:2026-05-184 Comments4 Mins Read
Share
Facebook Twitter LinkedIn Pinterest Email Telegram WhatsApp

This post is also available in: Português (Portuguese (Brazil))

Series: Oracle RAC 12.2- Complete Installation on VMware Workstation


📌 About this series: This guide covers Oracle RAC 12c, which is out of support. The goal is to document learning and revisit concepts- not to recommend this version for production. Read the full context in the series overview →

📋 This series- Oracle RAC 12.2 on VMware Workstation:

Series posts
Series Overview- RAC architecture, environment, and software
Post 1- VMware Setup and targetcli iSCSI Storage
Post 2- Oracle Linux Configuration and iSCSI Initiator
Post 3- Grid Infrastructure 12.2 Installation
Post 4- Oracle Database Installation and DBCA ← this post
Post 5- Final Validation and Quick Reference

⚙️ Prerequisite: Post 3 completed – Grid Infrastructure installed and cluster with two active nodes (crsctl stat res -t clean).


Install Oracle Database Software 12.2

Prepare the Installer

cd /u01/stage
unzip -q /u01/stage/linuxx64_12201_database.zip

After unzipping, the /u01/stage/database/ directory is created with the installer.

orclrac2 doesn’t need to unzip – the OUI copies binaries automatically over SSH.

Run the Database OUI

ssh -X [email protected]

su - oracle
db_env
cd /u01/stage/database
./runInstaller

Step 1- Configure Security Updates

  • Uncheck update notifications – click Next and confirm

Step 2- Installation Option: Install database software only

Step 3- Grid Installation Options: Oracle Real Application Clusters database installation

Step 4- Nodes Selection: check orclrac1 and orclrac2

Step 5- Database Edition: Enterprise Edition

Step 6- Installation Location:

FieldValue
Oracle Base/u01/app/oracle
Software Location/u01/app/oracle/product/12.2.0/dbhome_1

Step 7- Operating System Groups:

GroupValue
OSDBAdba
OSOPERoper
OSBACKUPDBAbackupdba
OSDGDBAdgdba
OSKMDBAkmdba
OSRACDBAracdba

Step 8- Prerequisite Checks– see Known Errors section

Step 9- Summary → Install

Run root.sh

Can be run on both nodes simultaneously:

/u01/app/oracle/product/12.2.0/dbhome_1/root.sh

Create the RAC Database (DBCA)

ssh -X [email protected]

su - oracle
db_env
dbca

All 16 DBCA Screens

Step 1- Database Operation: Create a database

Step 2- Creation Mode: Advanced Configuration

Step 3- Deployment Type:

FieldValue
Database typeOracle Real Application Clusters (RAC) database
Configuration typeAdmin Managed
TemplateCustom Database

Admin Managed: the DBA controls which nodes run the database. Custom Database: fully manual configuration- more educational.

Step 4- Nodes Selection: orclrac1 and orclrac2

Step 5- Database Identification:

FieldValue
Global database nameorcl
SID PrefixORCL
Create as Container databaseunchecked

SID Prefix ORCL automatically generates ORCL1 on orclrac1 and ORCL2 on orclrac2.

Step 6- Storage Option:

FieldValue
Database files storage typeASM
Database files location+DATA/{DB_UNIQUE_NAME}
Use Oracle-Managed Files (OMF)✅ checked

Step 7- Fast Recovery Option:

FieldValue
Specify Fast Recovery Area✅ checked
Recovery files storage typeASM
Fast Recovery Area+FRA
Fast Recovery Area size34000 MB
Enable archiving✅ checked

34000 MB ensures the size fits within the available space of the +FRA disk group (40 GB). Archive Log Mode is configured automatically by DBCA.

Step 8- Database Options:

ComponentLab
Oracle JVM✅ Keep
Oracle Text✅ Keep
Oracle MultimediaOptional
Oracle OLAPOptional
Oracle SpatialOptional
Oracle Label SecurityNot needed
Oracle Application ExpressOptional
Oracle Database VaultNot needed

Step 9- Configuration Options:

Memory tab:

FieldValue
ManagementAutomatic Shared Memory Management (ASMM)
SGA Size2388 MB
PGA Size797 MB

Do not use AMM in RAC– it uses HugePages inefficiently.

Sizing tab:

FieldValue
Block size8192 bytes (8 KB)
Processes320

Block size cannot be changed after database creation.

Character sets tab:

FieldValue
Database character setAL32UTF8
National character setAL16UTF16

AL32UTF8 cannot be changed after database creation without rebuilding or migrating.

Connection mode tab: Dedicated Server Mode

Sample schemas tab: unchecked

Step 10- Management Options:

OptionValue
Run CVU checks periodically✅ checked
Configure EM database expressunchecked
Register with EM Cloud Controlunchecked

Step 11- User Credentials:

  • Use the same administrative password for all accounts
  • Password: Welcome1

Step 12- Creation Option: Create database ✅ checked

Step 13- Prerequisite Checks: see Known Errors

Step 14- Summary → Finish

Step 15- Progress Page: wait for completion

Step 16- Finish → Close


Known Errors

Swap Size / NTP / Clock Synchronization- Failed or Warning

Cause: Same checks as Grid. If swap and chrony were configured correctly in Post 2, these checks should pass. If they still fail, close the OUI, confirm chronyc sources, and reopen.

Temporary fix: Check Ignore All and proceed- does not affect database functionality.

resolv.conf overwritten after reboot

Symptom: resolv.conf Integrity check fails in the Database OUI after a reboot.

lsattr /etc/resolv.conf
chattr +i /etc/resolv.conf

[DBT-06604] Fast Recovery Area- insufficient free space

Symptom: DBCA reports that +FRA does not have enough space for the configured size.

Cause: The configured FRA size exceeds the available space in the disk group.

Fix: Reduce the Fast Recovery Area size in Step 7 to a value below the available free space in +FRA. Use 34000 MB to ensure a safe margin.


Next Up

In Post 5 we’ll validate the complete environment and have a quick reference for day-to-day commands.


asm clusterware dbca grid-infrastructure installation lab oracle-database oracle-rac
Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp
Previous ArticleOracle RAC 12.2 on VMware Workstation- Post 3: Grid Infrastructure Installation
Next Article Oracle RAC 12.2 on VMware Workstation- Post 5: Final Validation and Quick Reference

Related Posts

Performance

Oracle SQL Patch: Inject Optimizer Hints Without Changing Code

2026-06-13
Read More
Oracle

Oracle ACCOUNT_STATUS: What Each Value Means

2026-06-04
Read More
Oracle

Oracle RAC 12.2 on VMware Workstation- Post 5: Final Validation and Quick Reference

2026-05-11
Read More
0 0 votes
Article Rating
Subscribe
Login
Notify of
guest

guest

4 Comments
Oldest
Newest Most Voted
trackback
Oracle RAC 12.2 on VMware Workstation- Series Overview | Execute Step
1 month ago

[…] Oracle RAC 12.2 on VMware Workstation- Post 4: Oracle Database Installation and DBCA […]

0
Reply
trackback
Oracle RAC 12.2 on VMware Workstation- Post 3: Grid Infrastructure Installation | Execute Step
26 days ago

[…] Oracle RAC 12.2 on VMware Workstation – Post 4: Oracle Database Installation and DBCA […]

0
Reply
trackback
Oracle RAC 12.2 on VMware Workstation - Post 1: VMware Setup and iSCSI Target with targetcli | Execute Step
26 days ago

[…] Oracle RAC 12.2 on VMware Workstation – Post 4: Oracle Database Installation and DBCA […]

0
Reply
trackback
Oracle RAC 12.2 on VMware Workstation- Post 2: Oracle Linux Configuration and iSCSI | Execute Step
26 days ago

[…] Oracle RAC 12.2 on VMware Workstation – Post 4: Oracle Database Installation and DBCA […]

0
Reply
Demo
Follow Me
  • Email
  • GitHub
  • LinkedIn
  • RSS
  • YouTube

INS-06006 – Passwordless SSH Connectivity Not Set Up

2026-02-2615 Views

INS-08101- How to Fix “Unexpected Error at supportedOSCheck” When Installing Oracle Grid Infrastructure on RHEL 8

2026-03-0411 Views

ORA-29548- How to Fix “Java System Class Reported” in Oracle Database

2026-03-0510 Views
Demo
Blogroll
  • oravirt
Execute Step
YouTube LinkedIn RSS
  • Home
  • About
  • Contact
  • RSS
  • English
    • Português (Portuguese (Brazil))
© 2026 ExecuteStep. Designed by ThemeSphere.

Type above and press Enter to search. Press Esc to cancel.

wpDiscuz
Ad Blocker Enabled!
Ad Blocker Enabled!
Our website is made possible by displaying online advertisements to our visitors. Please support us by disabling your Ad Blocker.