Oracle DBA and development articles, scripts, HOWTOs and forums (8i, 9i, 10g, 11g, 12c, 13c, 18c, 19c, 21c)

Latest Articles

Oracle Database 21c Express Edition (XE) RPM Installation On Oracle Linux 7 (OL7) and 8 (OL8)
This article describes the Oracle Database 21c Express Edition (XE) RPM installation on Oracle Linux 7 (OL7) and 8 (OL8) 64-bit.

Data Pump Export (expdp) to and Import (impdp) From Cloud Object Stores in Oracle Database 21c
Data Pump supports cloud object stores as a dumpfile location for on-prem installations from Oracle 21c onward.

Data Pump Enhancements in Oracle Database 21c
This article gives an overview of the Data Pump enhancements in Oracle Database 21c.

Oracle Cloud : Autonomous Database (ADW or ATP) - Export Data to an Object Store (expdp)
This article demonstrates how to export data from an Autonomous Data Warehouse (ADW) or Autonomous Transaction Processing (ATP) service on the Oracle Cloud using the expdp utility.

Multivalue Function-Based Indexes for JSON_EXISTS in Oracle Database 21c
Multivalue function-based indexes allow us to index multiple scalar values in JSON documents stored in the JSON data type.

Oracle 21c : Upgrade Overview
An overview of the process of upgrading to Oracle database 21c, with links to more detailed articles.

Upgrade Non-CDB to Oracle Database 21c (Manual)
This article provides an overview of a manual upgrade of an existing non-CDB database to Oracle 21c.

Multitenant : Unplug/Plugin PDB Upgrade to Oracle Database 21c (AutoUpgrade)
This article provides an overview of upgrading an existing PDB to Oracle 21c on the same server using AutoUpgrade Unplug/Plugin.

Upgrade Non-CDB to Oracle Database 21c (AutoUpgrade)
This article provides an overview of upgrading a non-CDB database to Oracle 21c on the same server using AutoUpgrade.

Multitenant : Upgrade to Oracle Database 21c (AutoUpgrade)
This article provides an overview of upgrading an existing multitenant database to Oracle 21c on the same server using AutoUpgrade.

Oracle Database 21c RPM Installation On Oracle Linux 7 (OL7) and Oracle Linux 8 (OL8)
This article describes the RPM installation of Oracle Database 21c 64-bit on Oracle Linux7 (OL7) 64-bit.

Oracle Database 21c RAC On Oracle Linux 7 Using VirtualBox and Vagrant
This article describes the hands-off installation of Oracle Database 21c RAC on Oracle Linux 7 using VirtualBox and Vagrant with no additional shared disk devices.

Oracle Database 21c RAC On Oracle Linux 8 Using VirtualBox and Vagrant
This article describes the hands-off installation of Oracle Database 21c RAC on Oracle Linux 8 using VirtualBox and Vagrant with no additional shared disk devices.

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 21c
This article contains an example of setting up a physical standby database for Oracle 21c using the Data Guard Broker.

Oracle Database 21c Installation On Oracle Linux 7 (OL7)
This article describes the installation of Oracle Database 21c 64-bit on Oracle Linux 7 (OL7) 64-bit.

Oracle Database 21c Installation On Oracle Linux 8 (OL8)
This article describes the installation of Oracle Database 21c 64-bit on Oracle Linux 8 (OL8) 64-bit.

Check out my YouTube channel here.

You can follow me on these networks:

You can get an oracle-base.com t-shirt here.

Search Docs