ORACLE HANG ANALYZE

How to generate Hang Analyze Report when Database Hanged?

Sometimes database hangs due to multiple reasons and company higher managements always looks for RCA. This is very important to have all trace file to find the issue for hanging the database or fine the RCA. Otherwise Oracle Support will say sorry!!!

Get a hang analyze report by running below commands when you notice that the database is hanged.

Continue reading

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:

Continue reading

Connect VM using Putty from Local Computer

For a DBA, this is very important to connect Oracle Database using putty to run command very easily. In real life/working place, most of Oracle DBA use putty to manger oracle databases.

Follow below two very simple steps.

Continue reading

Configure Network between two Physical Machines for VM Setup

Configure network in two laptops / PC:

Connect two physical machine with network cross cable. Then setup network:

Install VM on Oracle Linux : https://www.virtualbox.org/ticket/14716

Continue reading

DBA Scripts

Monitoring:

Oracle Database 12c, 18c & 19c Product Versions and Upgradation Path

As you may know Oracle introduced a new versioning formation from 18c. Until 12.2.0.1 Oracle was releasing versions like 10g, 11g, and 12c. Oracle announced to release a version every year from 2018 and it could be like Oracle Database 18c, 19c and 20c.

Oracle Database 12c: Oracle database 12c consider all version from 12c R1(12.1.0.2) to 12c R2 (12.2.0.1) .

Continue reading

Install Oracle Linux 5.8

Install Linux OS on VM

  • Oracle Linux (OS) install on VM
  • Oracle GI and Database Installation Prerequisites
  • Configure ASM Disk For RAC
Continue reading

Configure Virtual Machine for RAC

I will discuss here step by step how to configure a Virtual Machine with Linux OS using VM VirtualBox Manager.

  1. Virtual Machine Setup
  2. Install Linux OS on VM
  3. Oracle GI and Database Installation Prerequisites
  4. Configure Shareable Disk for ASM (for RAC setup)
  5. Clone VM and prepare another VM for Clusterware Node

Configure Server on VM:

Click ‘New’ on toolbar and provide the Name and select appropriate OS type and version.

Continue reading

Oracle Database 11g R2 (11.2) Installation On Oracle Enterprise Linux 7 (OEL7)

This article describes the installation of Oracle Database 11g R2 (11.2.0.4) 64-bit on Oracle Linux 7 (OL7) 64-bit.

Continue reading

Important Link About Oracle

There are number of important video link provided in below. It may helps.

Continue reading