Mohammad Samad

Author's posts

Dec 15 2019

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 …

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

Nov 20 2019

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

Nov 15 2019

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

Nov 13 2019

DBA Scripts

Monitoring: Load by Users Generate Kill Sessions from query List Privilege Load by Users Process Details Schema Size Tables Record Count

Nov 09 2019

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 …

Continue reading

Nov 06 2019

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

Nov 05 2019

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. Virtual Machine Setup Install Linux OS on VM Oracle GI and Database Installation Prerequisites Configure Shareable Disk for ASM (for RAC setup) Clone VM and prepare another VM for Clusterware Node Configure Server on VM: …

Continue reading

Nov 04 2019

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. 1. Install Oracle Enterprise Linux 7. 2. Oracle Installation Prerequisites. 2.1 Automatic Setup 2.2 Manual Setup 3. Additional Setup 4. Oracle Database 11gR2 Software Installation. 5. Oracle Database Creation using DBCA.

Continue reading

Nov 01 2019

Important Link About Oracle

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

Continue reading