Category: RAC & ASM

Jul 02 2020

Oracle Database Software Installation and Create Database on RAC

In this topic I will describe how to install Oracle Database Software. There is no difference between installation on Non-Exadata and Exadata for RAC environment.

Continue reading

Jul 01 2020

Grid Infrastructure (11.2.0.4) Installation

In this topic, I will show how to install Oracle Grid Infrastructure on Computer Node using Exadata Storage Server.

Continue reading

Jun 12 2020

Configure Oracle 12c RAC to RAC Data Guard (DR) on Linux

We will discuss how to configure RAC to RAC Data Guard on Linux. If you follow all below steps you will able to configure the two node (or multi node) DR. Overview: A Data Guard configuration consists of one production database and one or more standby databases. The databases in a Data Guard configuration are connected by Oracle …

Continue reading

May 02 2020

Automatic Storage Management (ASM)

In this topic, I will discuss how to manage ASM in Oracle including following items. Important queries to manage or monitor ASM. Create ASM DISKGROUP Manage Existing Diskgroup (add / drop disk) Tuning I/O Performance in Oracle ASM Mapping ASM Disk with Physical DISK ASM REDUNDANCY Level: NORMAL REDUNDANCY – Two-way mirroring, requiring two failure groups. …

Continue reading

Apr 14 2020

Oracle Database 12c R1 (12.1) RAC installation

Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability. Below high level steps will perform to configure / install Oracle RAC: Configure 2 Virtual Machine (VM) for 2 Nodes RAC Install Oracle Linux 5.7 Install GI (Grid Infrastructure) Configure ASM Install Oracle Database Binary Create Database …

Continue reading

Apr 12 2020

USABLE_FILE_MB is showing negative values in V$ASM_DISK View

REQUIRED_MIRROR_FREE_MB value in V$ASM_DISKGROUP indicates how much free space is required in an ASM disk group to restore redundancy after failure of an ASM disk or ASM failure group. USABLE_FILE_MB value indicates how much space is available in an ASM disk group considering the redundancy level of the disk group. We need 3614 MB space …

Continue reading

Mar 15 2020

Oracle Database 12c RAC on Oracle Linux 6.5

Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability. Below high level steps will perform to configure / install Oracle RAC: Configure 2 Virtual Machine (VM) for 2 Nodes RAC Install Oracle Linux 6.5 Install GI (Grid Infrastructure) Configure ASM Install Oracle Database Binary Create Database …

Continue reading

Dec 12 2019

Oracle Database 11g Release 2 RAC On Oracle Linux 7.1

Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability. Below high level steps will perform to install/configure Oracle RAC: Configure 2 Virtual Machine (VM) for 2 Nodes RAC. Install Oracle Linux 7.1. Oracle Installation Prerequisites. Additional Setup. Create Shared Disk. Clone the Virtual Machine for Node2. …

Continue reading