Category: Oracle Database

Configure Resource Manager on Container Database

The following issues DBAs may face in oracle databases but we can overcome these issues by using Resource Manager: Excessive overhead: Excessive overhead results from operating system context switching between Oracle Database server processes when the number of server processes is high. Inefficient scheduling: The operating system deschedules database servers while they hold latches, which …

Continue reading

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

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

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

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

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

Oracle Database 12c RAC on Oracle Linux 6.5

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 …

Continue reading

Administration Database Users including Roles and Privileges on Multitenant

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 …

Continue reading

Managing a Pluggable Database

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

Continue reading

Creating a Pluggable Database

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 …

Continue reading