Category: Oracle Database 12c

Oracle Database 12c R2 (12.2) RAC On Oracle Linux 7

Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability. In this article, I will show how to install Oracle RAC (12.2.0.1) on Oracle Enterprise Linux 7.1. Below high level steps will perform to install/configure Oracle RAC: Configure 2 Virtual Machine (VM) for 2 Nodes RAC. Install …

Continue reading

Manually Upgrade Oracle Database from 11gR2 to 12cR2

This article provides an overview of upgrading an existing non-CDB database from Oracle 11.2.0.4 to Oracle 12.2.0.1. Upgrades can be very complicated, so this is highly recommended to read the oracle provided manual and test thoroughly before considering an upgrade of a production environment.

Continue reading

Upgrade Oracle Database from 11gR2 to 12cR2 Using DBUA

This article provides an overview of upgrading an existing non-CDB database from Oracle 11.2.0.4 to Oracle 12.2.0.1. Upgrades can be very complicated, so this is highly recommended to read the oracle provided manual and test thoroughly before considering an upgrade of a production environment.

Continue reading

Oracle Database Upgrade Manually from 12.1 to 19.3

This article provides an overview of upgrading an existing non-CDB database from Oracle 12c to Oracle 19c. Upgrades can be very complicated, so this is highly recommended to read the oracle provided manual and test thoroughly before considering an upgrade of a production environment. Oracle Database Upgradation Manual – Read More. Upgrade Path for Oracle …

Continue reading

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 …

Continue reading

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 …

Continue reading

Oracle Database 12c R1 (12.1) RAC installation

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 5.7 Install GI (Grid Infrastructure) Configure ASM Install Oracle Database Binary Create Database …

Continue reading

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