Category: RAC, ASM & Clusterware

RAC, ASM & Clusterware

Apr 09

Oracle RAC installation fails on Windows 2022 with INS-08109 – CRSNodeInformationUI

Installing Oracle RAC in Windows is always an adventure, specially in Windows 2022 that was released after Oracle Database 19c launched. If you are receiving this error: # For WARNING: [Apr 9, 2026 12:49:37 PM] [WARNING] [INS-08109] Unexpected error occurred while validating inputs at state ‘CRSNodeInformationUI’. CAUSE: No additional information available. ACTION: Contact Oracle Support …

Continue reading

Jul 29

Deploying a highly available MySQL Cluster with DRBD on OCI

This tutorial walks you through the process of deploying a MySQL database to Oracle Cloud Infrastructure (OCI) by using Distributed Replicated Block Device (DRBD). DRBD is a distributed replicated storage system for the Linux platform. PS: This post was based in many other articles that I’ve read over internet and I adapted them for OCI. …

Continue reading

Mar 10

Check which Hub Node is Leaf Node connected to in Oracle Flex Cluster

In this article, I will show how to detect to which Hub Node is your Leaf Node connected to in an Oracle Flex Cluster scenario where you have multiple Hub Servers. First of all, let’s check our current scenario: [oracle@oranode3 ~]$ crsctl get node role status -all Node ‘oranode1’ active role is ‘hub’ Node ‘oranode2’ …

Continue reading

Apr 29

“ORA-15040: diskgroup is incomplete” but diskgroup is mounted

Those days, I was creating a new database on a system and when I tried to create any file (spfile / pwfile / control file) on diskgroup, I started receiving the error below: ORA-15001: diskgroup “DATA” does not exist or is not mounted ORA-15040: diskgroup is incomplete Usually this error comes together with something like …

Continue reading

Apr 16

libasmclntsh12.so missing after OPatch failed in Oracle 12c

Those days, I was trying to apply the latest Oracle Grid Infrastructure PSU over my 12.1.0.2 Clusterware. During the apply phase, the OPatch failed because the gcc was not available for execution. Actually, someone gave chmod 700 to /usr/bin/gcc for protection. /grid/app/grid/product/12.1.0/grid/bin/orald: line 31: /usr/bin/gcc: Permission denied /grid/app/grid/product/12.1.0/grid/bin/orald: line 31: exec: /usr/bin/gcc: cannot execute: Permission denied make[2]: …

Continue reading