dbasamad – Page 9

Mar 24 2020

Control System Privileges (Truncate or Drop) in Oracle Database

By dbasamad in Database Maintenance

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 …

Mar 21 2020

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

By dbasamad in OCM Preparation, OEM, Oracle Database 12c

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 …

Mar 21 2020

Install Agent on OEM using GUI

By dbasamad in OCM Preparation, OEM

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 …

Mar 20 2020

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

By dbasamad in OCM Preparation, OEM

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.

1 comments

Mar 15 2020

Oracle Database 12c RAC on Oracle Linux 6.5

By dbasamad in OCM Preparation, Oracle Database 12c, RAC & ASM

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 configure / install Oracle RAC: Configure 2 Virtual Machine (VM) for 2 Nodes RAC Install Oracle Linux 6.5 Install GI (Grid Infrastructure) Configure ASM Install Oracle Database Binary Create Database …

Mar 07 2020

Install Oracle Linux 5.9 on VM

By dbasamad in Unix, VitualBox Manager

In this topic, will discuss how to install Oracle Linux 5.9 on Virtual Machine.

Mar 07 2020

Administration Database Users including Roles and Privileges on Multitenant

By dbasamad in OCM Preparation, Oracle Database 12c

This topic describes how to create and manage a user in Multitenant database. There are two types of users in Multitenant Database: Common User: User exists in all containers (root container and all PDBS). Local User: User exists on particular PDB only. Similarly, Two types of role are available in Multitenant Database: Common Role: Role …

Mar 06 2020

Managing a Pluggable Database

By dbasamad in OCM Preparation, Oracle Database 12c

Change the PDB State. Unplug the PDB. Set default tablespace. Set default temporary tablespace. Enable (disable) logging. Change status of datafile (online/offline).

Mar 05 2020

Creating a Pluggable Database

By dbasamad in OCM Preparation, Oracle Database 12c

In this topic, I will show how to Create and manage PDB: Create a PDB from SEED. Clone a PDB with No Data. Clone a PDB from existing local PDB. Clone a PDB from existing remote PDB. Clone a PDB from existing remote Non-CDB. Clone a PDB from non-CDB using DBMS_PDB Package. Plugging In an …

Mar 04 2020

Creating Container and Pluggable Database Using CREATE DATABASE SQL Command

By dbasamad in OCM Preparation, Oracle Database 12c

In Oracle OCM exam, You may need to create database using command line. Even in real life, You may no have the option to use the software for GUI. I will show how to create a CDB and PDB using SQL Command. Create required directories. Set Environment Variables. Create Password File. Create a pfile and …

Mohammad Samad

Author's posts