Category: Oracle Database 11g

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

Create Oracle RAC Database Using DBCA

Run DBCA utility from oracle user. You have to set ORACLE_HOME AND ORACLE_SID

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 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

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

Oracle Database 11g Release 2 RAC On Oracle Linux 7.1

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 install/configure Oracle RAC: Configure 2 Virtual Machine (VM) for 2 Nodes RAC. Install Oracle Linux 7.1. Oracle Installation Prerequisites. Additional Setup. Create Shared Disk. Clone the Virtual Machine for Node2. …

Continue reading

Oracle Database 11g R2 (11.2) Installation On Oracle Enterprise Linux 7 (OEL7)

This article describes the installation of Oracle Database 11g R2 (11.2.0.4) 64-bit on Oracle Linux 7 (OL7) 64-bit. 1. Install Oracle Enterprise Linux 7. 2. Oracle Installation Prerequisites. 2.1 Automatic Setup 2.2 Manual Setup 3. Additional Setup 4. Oracle Database 11gR2 Software Installation. 5. Oracle Database Creation using DBCA.

Continue reading