Mohammad Samad
Author's posts
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.
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 …
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 …
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 …
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 …
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:
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 …
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:
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 …
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. …
About Me
- Bachelor of Science in Computer Science, Dhaka, Bangladesh
- Master of Science in Data Warehousing & Data Mining, London, UK
- Master of Science in Computer Science, MIU, IA, USA
- Oracle Cloud Infrastructure Architect Professional
- Oracle OCP 9i-12c
- Oracle OCE RAC and GRID 11g
- Oracle OCS Security 11g
- Oracle PL/SQL OCA 10g
- Red Hat Enterprise Linux 6 RHCE
