Category: Oracle Database

Oct 26 2023

Recover a Table From a Drop/Truncate/Delete By RMAN

User may drop or truncate a table or delete records accidently which need to recover. Even sometimes we may need to recover the data for a table for corrupted data. This is very difficult to restore the full DB if database size is huge like Terabytes. I will demonstrate with this Article how we can recover …

Continue reading

Oct 16 2020

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

Oct 06 2020

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

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.

Continue reading

Oct 02 2020

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

Sep 19 2020

V$ View & Data Dictionary View on Oracle

Dynamic Performance (V$) Views: The Oracle Server contains a set of underlying views that are maintained by the server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously updated while a database is open and in use, and their contents relate primarily to performance. Data Dictionary View: …

Continue reading

Aug 30 2020

Oracle Database 19c Installation On Oracle Linux 7.1

I will describe the installation process of Oracle 19c (19.3) Database on Oracle Linux 7.1 on VM. 1. Create VM. 2. Software Download. 3. Install Oracle Linux 7.1 on VM. 4. Oracle Database Installation Prerequisites. 5. Oracle Database Software Installation. 6. Create a Container Database Using DBCA. 7. Create a Non-container Database Using DBCA. 8. …

Continue reading

Jul 03 2020

Create Oracle RAC Database Using DBCA

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

Continue reading

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 …

Continue reading

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 …

Continue reading