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 20 2020

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

Jun 15 2020

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

Jun 13 2020

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

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 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

Jun 10 2020

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

May 27 2020

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

May 22 2020

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

May 12 2020

Database Backup Script using RMAN

A backup is a copy of data. This copy can include important parts of the database, such as the control file and datafiles. A backup is a safeguard against unexpected data loss and application errors. If you lose the original data, then you can reconstruct it by using a backup. So taking database backup is one of the most important task for DBA.

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.
  • HIGH REDUNDANCY – Three-way mirroring, requiring three failure groups.
  • EXTERNAL REDUNDANCY – In this configuration there are only primary extents and no mirrored extents.
Continue reading