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.
Category: Oracle Database 11g
Oct 04 2020
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.
Jul 03 2020
Create Oracle RAC Database Using DBCA
Jun 20 2020
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 …
May 27 2020
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 …
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 …
Mar 01 2020
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.
Dec 12 2019
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. …
Nov 04 2019
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.
About Me
- Bachelor of Science in Computer Science, Dhaka, Bangladesh
- Master of Science in Data Warehousing & Data Mining, London, UK
- Master of Science in Computer Science, MIU, IA, USA
- Oracle Cloud Infrastructure Architect Professional
- Oracle OCP 9i-12c
- Oracle OCE RAC and GRID 11g
- Oracle OCS Security 11g
- Oracle PL/SQL OCA 10g
- Red Hat Enterprise Linux 6 RHCE
