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

Latest Articles

Oracle Database 21c Installation On Fedora 37 (F37)
This article describes the installation of Oracle Database 21c 64-bit on Fedora 37 (F37).

Oracle Database 19c Installation On Fedora 37 (F37)
This article describes the installation of Oracle Database 19c 64-bit on Fedora 37 (F37).

Fedora 37 (F37) Installation
This article provides a pictorial guide for performing a basic server installation of Fedora 37 (F37).

Automation Patterns for Typical DBA Tasks
This post describes some common automation patterns I use when automating typical DBA task.

Leapp : Upgrade Oracle Linux 7 (OL7) to Oracle Linux 8 (OL8)
This article demonstrates how to upgrade an Oracle Linux 7 (OL7) installation to Oracle Linux 8 (ol8) using Leapp.

Patching : Apply a Grid Infrastructure (GI) Release Update (RU) to New ORACLE_HOMEs (Out-Of-Place Patching)
This article gives an example of applying a Grid Infrastructure (GI) Release Update (RU) to new ORACLE_HOMEs for a Real Application Clusters (RAC) installation. This is know as out-of-place patching.

Patching : Apply a Database Release Update (RU) to Existing Data Guard ORACLE_HOMEs
This article gives an example of applying a database Release Update (RU) to existing Data Guard ORACLE_HOMEs.

Patching : Apply a Grid Infrastructure (GI) Release Update (RU) to Existing ORACLE_HOMEs
This article gives an example of applying a Grid Infrastructure (GI) Release Update (RU) to existing ORACLE_HOMEs for a Real Application Clusters (RAC) installation.

Patching : Apply a Database Release Update (RU) to a New ORACLE_HOME
This article gives an example of applying a database Release Update (RU) to a new ORACLE_HOME for a simple single-instance Oracle database.

Patching : Apply a Database Release Update (RU) to an Existing ORACLE_HOME
This article gives an example of applying a database Release Update (RU) to an existing ORACLE_HOME for a simple single-instance Oracle database.

Partitioning From a Design Perspective (A Practical Guide) - By Lothar Flatz
This is a guest post by Lothar Flatz. It is an English translation of an article first published in German.

DG PDB : Oracle Data Guard per Pluggable Database in Oracle Database 21c (21.7 Onward)
DG PDB is a new feature introduced in Oracle database 21c (21.7) which allows PDB-level Data Guard protection. This article describes a basic setup of DG PDB.

Oracle REST Data Services (ORDS) : Installation on Tomcat (Windows)
Install Oracle REST Data Services (ORDS) version 22.1 onward on Tomcat running on Windows.

Oracle Linux 9 (OL9) Installation
This article provides a pictorial guide for performing a basic server installation of Oracle Linux 9 (OL9).

Ansible vs Terraform
This article compares Ansible and Terraform, explaining what roles they play in infrastructure as code.

Docker : Using JFrog Platform as a Docker Registry
This article demonstrates how to use JFrog Platform as a Docker registry, also known as a container registry.

Check out my YouTube channel here.

You can follow me on these networks:

Search Docs