Jul 05 2020

Install Oracle Linux 7 on VM

This article describes the installation process of Oracle Linux 7.1 on VM. Installation process will be same for any version of Linux 7.

Continue reading

Jul 05 2020

Create Virtual Machine (VM) for Exadata Storage Server

Continue reading

Jul 04 2020

Oracle Cloud Infrastructure (OCI)

Oracle Cloud Infrastructure OCI

Details are coming soon…

Jul 03 2020

Create Oracle RAC Database Using DBCA

Run DBCA utility from oracle user. You have to set ORACLE_HOME AND ORACLE_SID

[oracle@exadb01 dbhome]$ . oraenv
ORACLE_SID = [oracle] ? ORCL
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/11.2.0/dbhome/
The Oracle base has been set to /u01/app/oracle
[oracle@exadb01 dbhome]$ dbca
Continue reading

Jul 02 2020

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

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