Mohammad Samad

Author's posts

Mar 03 2020

Install Oracle 12.1 Software and Create database in Silent Mode

In this Topic, I will show how to install Oracle 12.1.0.2 Software only and Create database using DBCA by silent mode. Oracle Installation Prerequisites Install Oracle 12c Software in Silent Mode: Create Database Using DBCA with Silent Mode: Oracle Installation Prerequisites: Add following kernel parameters on /etc/sysctl.conf. Run following command to verify and output will …

Continue reading

Mar 02 2020

Permission changed for all directories including files in Oracle Home (RAC)

Sometime user (os admin or dba) make mistake to change or provide the permission in Oracle Binary. User might requested for changing the particular file or directory permission but admin might run with recursively. Example: To change owner for patch directory (/u01/patch) including all files on patch. But by mistake run below command

Continue reading

Mar 02 2020

OCM 12c Preparation: Prepare Exam Environments

Oracle Certified Master is one of the prestigious exam in database world. Most of the Oracle DBA have a dream to be OCM certified. This certification will distinguish you from others in Market. Prerequisites to be OCM Certified: Details Oracle 12c OCM exam is based on Oracle Database 12c Release 1 and includes the use …

Continue reading

Mar 01 2020

Move or Rename Oracle Files

DBA needs to rename or move oracle file from one filesystem or ASM DISKGroup to another. Move Datafiles Using ALTER DATABASE MOVE DATAFILE command – 12c and onward Moving Datafile Using RMAN with offline option – 10g or 11g Prerequisites: Database should be configured archive log mode.

Continue reading

Mar 01 2020

OCM 12c Preparation

Oracle Certified Master is one of the prestigious exam in database world. Most of the Oracle DBA have a dream to be OCM certified. This certification will distinguish you from others in Market. Prerequisites to be OCM Certified: Details Oracle 12c OCM exam is based on Oracle Database 12c Release 1 and includes the use …

Continue reading

Feb 23 2020

Setup Password less connection using SSH for User Equivalence on Linux

Setup SSH (Key-Based Authentication) Password less connectivity is required for RAC setup. Sometimes need to send files from one server to another using script with scheduler job. For this kind of tasks, password less connectivity is required. Password less connectivity can setup one direction (from server A -> B) or both directions (From Server A …

Continue reading

Feb 15 2020

Add a New Disk to an Existing Linux Server

In this article describes how to add a file system on exiting Linux OS. As OS is running on VM, First will show how to add a disk on VM then Create a Filesystem on OS Level.

Continue reading

Feb 11 2020

Step by Step of Installation Oracle Enterprise Manager (OEM) 13c (13.2.0.0) on RAC

Oracle Enterprise Manage (OEM) is a great tools to monitor and manage all kind of oracle software including Oracle Databases and Server. Create Database Install OEM Software Install Agent

Continue reading

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