Mohammad Samad

Author's posts

Apr 07 2020

In-Database Archiving

Companies may need to keep data for longer time for compliance purposes even there is not use these data for companies. In-Database Archiving enables you to archive rows within a table by marking them as inactive. These inactive rows are in the database and can be optimized using compression, but are not visible to an application. The data in these …

Continue reading

Apr 05 2020

Temporal Validity in 12c

Temporal Validity enables you to track time periods for real world validity. Valid times can be set by users and applications for data, and data can be selected by a specified valid time, or a valid time range. Concepts that are integral to valid time temporal modeling include: Valid time: This is a user-defined representation …

Continue reading

Apr 05 2020

Clone Virtual Machine

This is always good to have a golden copy of your system. Then you don’t need to spend time to build your environment. For example, you can clone a VM after installed OS and configure network and prerequisites. Within couple of minutes you VM will be ready for any kind of R&D.

Continue reading

Apr 03 2020

Oracle Data Pump (expdp, impdp) in Oracle Database

The Data Pump feature had been introduced from Oracle 10g. Until Oracle 9i, There were a tradition export and import (exp, imp) tools for logical backup. Nowadays Data Pump (expdp & impdp) utilities are mostly use by oracle DBA. Data Pump is very useful tools to migrate database in difference version of Oracle databases or …

Continue reading

Apr 02 2020

Configure Heat Map & Automatic Data Optimization (ADO) in Oracle 12c

Nowadays Data is growing very rapidly at enterprises – various industry estimates indicate that data volume is doubling every 2-3 years. The rapid growing data is going to be challenged for IT, both in cost and performance. Although the cost of storage keeps declining, fast-growing data volumes make storage one ofthe costliest elements of most …

Continue reading

Mar 25 2020

Configure the network environment for Multitenant Database

This topic describes how to configure the network environment on Multitenant Database. Create a Service. Create a Listener. Create a Service: List of Services: Create a Service for PDB: DBMS_SERVICE package will use for creating a new service. For GI env, you may use srvctl to create and manger a service. When execute DBMS_SERVICE.CREATE_SERVICE procedure, …

Continue reading

Mar 24 2020

Control System Privileges (Truncate or Drop) in Oracle Database

There are two of privileges are available in Oracle. Object Privileges: Object privileges can be granted as Object Level. Example, You will able to provide delete privileges for particular table. User will able to delete records from that particular table only. System Privileges: System Privileges are very powerful privileges as you can’t grant at object …

Continue reading

Mar 21 2020

Install Agent on OEM 12c or 13c in Silent Mode

In this topic I will show how to add an agent using Pull method in Silent Mode. Agent Installation processes are same for 12c and 13c. OMS Server : ocmoem Target Server : ocm12c Login on OMS server using sysman and Synchronized: Get Platform Supported List: Download Agent Software from OMS: Move Agent Software to …

Continue reading

Mar 21 2020

Install Agent on OEM using GUI

In this topic I will show how to add an agent using Push method with GUI. Agent Installation processes are same for 12c and 13c. Install Agent on Target Host Discover Targets (Database, Listener) on Host Install Agent on Target Host: Navigate to the “Add Targets Manually” screen using the menu at the top-right of …

Continue reading

Mar 20 2020

OEM Cloud Control 12c Release 4 Installation on Oracle Linux 6.5

In this article I will describe the installation of Oracle Enterprise Manager (OEM) Cloud Control 12c Release 4 on 6.5. Prepare a VM Required Software Install Oracle Linux 6.5 Install Oracle Database 12.1.0.2. Install Oracle OEM 12cR4. Post Installation. Stop / Start OMS and Agent.

Continue reading