Mohammad Samad

Author's posts

Feb 04 2020

Oracle Database Migrate Using Mixed Oracle Version

We will discuss how to use mixed version of Data Guard to upgrade upper version with minimal downtime. DBA should not take 1% risk for most critical database in a company during migration or upgradation and must have to plan to rollback option for worse case. Let say you are working in a big company …

Continue reading

Feb 01 2020

Create Duplicate Or Refresh the Database Using RMAN Backup on RAC

Create duplicate database or refresh the database from production backup for testing purpose is one of the regular activities for DBA. I will discuss and show how to create duplicate database using RMAN backup. Scenario: Production database running on two nodes RAC and need to refresh the database for testing purpose on testing environment. Production …

Continue reading

Jan 16 2020

Multiple Tables Record Count by a Single Query

Sometimes DBA need to verify or compare multiple tables record count. It is really time consuming to compare one by one table count. So, by using this query, you will able to get record count report for multiple tables in Oracle.

Continue reading

Jan 06 2020

Move Objects From One Tablespace to Another Tablespace in Oracle

Sometimes need to move objects from one Tablespace to another in Oracle Databases. We can do this multiple ways. Move a single object from Multiple Tablespace (one TBS for DATA, another for Index and LOB) to different set of Tablespace Move all objects of a schema from Multiple Tablespace (one TBS for DATA, another for …

Continue reading

Jan 05 2020

Tips to Avoid Mistake and Be a Safer DBA

There is around 33% disaster occurs on database world for user error/mistake. If you follow couple of rules, you will able to overcome lots of possible mistake.

Continue reading

Dec 22 2019

Installing Oracle Client In Silent Mode on Linux

In this article I will show how to install Oracle Client 11g, 12c, 18c and 19c in Silent Mode on Linux. Download Software. Prepare response File. Installation

Continue reading

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