Create ASM Disk Group

In this topic I will show how to create ASM DISK Group using ASMCA tools or command line.

From grid owner (either grid or oracle user) need to set environment variable for ASM Instance and run asmca command from GUI mode.

[grid@exadb01 ~]$ . oraenv
ORACLE_SID = [grid] ? +ASM1
The Oracle base has been set to /u01/app/grid
[grid@exadb01 ~]$ asmca

Continue reading

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

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

Deinstall Oracle Software in Silent Mode

All kind of installations and configurations including de-installation of Oracle RAC or Database, we can perform using either GUI or Silent mode. GUI mode is more easier as it shows all option (with details) step by step but it may not possible for all the cases or may not support on environment. So we can use all oracle provided tools/utility with silent mode which is more faster and you will able to do this by using putty.

To run any tools with silent mode, DBA should have good understand for each parameter.

For any oracle command which runs using OS command like rman or expdp can get help with tool_name -help. So you don’t need to memorize parameters/options for these tools.

Continue reading

Patch (PSU) Automation

Applying patch is one the main maintenance task for a DBA. DBA team needs to give lots of effort to apply patch in every quarter. To minimize the manual effort I tried to make patching automation which will support following environments:

  • It will support for 11g and 12c Databases Including RAC and Standalone
  • It will support for Linux and AIX
  • Patching will support for Remote Node means don’t need to execute script from multiple Node. So this script need to run from one node in RAC Environment
  • User has flexibility to choose option
  • User don’t need to concentrate of patching each and every steps. User will able to apply patch in multiple environments as manual innervation is very minimal
  • It will support rollback also
Continue reading

Steps for PSU (Patch Set Update) Patching on RAC with Data Guard

Applying patch is one of the important task for DBA. I will discuss here how to apply PSU patch on your RAC database including DR for 12c and 11g.

Patch Set Update: A collection of proactive, stabilizing cumulative patches for a particular product version (base release or patch set). PSUs are cummulative and include all of the security fixes from SPU patches (formerly known as CPU), plus additional fixes. Oracle releases PSU every quarter [17th January, 17th April, 17th July & 17th October].

Continue reading

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:

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 Net and may be dispersed geographically. There are no restrictions on where the databases are located, provided they can communicate with each other. For example, you can have a standby database on the same system as the production database, along with two standby databases on other systems at remote locations.

Continue reading

Change Archive Log Mode in Oracle Database

In this topic, I will show how to change Archive Log Mode in Oracle Database.

Enable Archive Log Mode in RAC:

Archive Log Status:

Continue reading

Install Oracle Software in Silent Mode

All kind of installations and configurations for Oracle RAC or Database, can be performed either using GUI or Silent mode. GUI mode is more easier as it shows all option (with details) step by step but it may not possible for all the cases or may not support on environment or may need to install bulk number of databases. So we can use all oracle provided tools/utility with silent mode which is more faster and you will able to do by using putty only.

Benefits to use oracle tool/utility in silent mode:

  • Extra Software is not required to run with GUI mode
  • Faster and minimal user interaction
  • Run as script by nohup or cron job so no Internet issue between server and client
Continue reading

Creating a new file system for an existing Linux virtual machine

This article provides steps to create a new file system for an existing Linux virtual machine.

Create a partition on new disk:

Continue reading