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

Latest Articles

Multitenant : Controlling PDB Replication in Data Guard Environments
This article describes two methods for controlling the replication of PDBs in standby databases when using Data Guard.

Multitenant : Upgrading to Oracle Database 18c
This article provides an overview of upgrading an existing multitenant database to Oracle 18c.

Multitenant : DBCA PDB Clone and DBCA CDB Duplicate in Oracle Database 18c
In Oracle 18c it's now possible to clone a pluggable database (PDB) and duplicate a container database (CDB) using the Database Configuration Assistant (DBCA).

Multitenant : PDB Lockdown Profile Enhancements in Oracle Database 18c
Oracle database 18c extends the PDB Lockdown Profiles functionality introduced in Oracle database 12.2, making it even easier to restrict the operations and functionality available from within a PDB.

Multitenant : CDB Fleet Management in Oracle Database 18c
Oracle 18c allows you to monitor multiple container databases centrally as a fleet.

Multitenant : PDB Snapshot Carousel in Oracle Database 18c
Oracle 18c introduced the concept of a snapshot carousel, which is a series of point-in-time copies, or snapshots, of a PDB.

Multitenant : Refreshable PDB Switchover in Oracle Database 18c
Oracle 18c allows you to switch the roles of a source PDB and a refreshable PDB.

Multitenant : Duplicate a Pluggable Database (PDB) to an existing Container Database (CDB) in Oracle Database 18c
Oracle 18c allows you to duplicate a pluggable database (PDB) from one container database (CDB) instance to another existing CDB instance using RMAN.

Vagrant : A Beginner's Guide
This article gives a very brief introduction to Vagrant.

Docker : Docker Swarm - Defining Clustered Multi-Container Applications
This article describes how to use Docker Swarm to create clustered multi-container applications.

Docker : Portainer - A Web-Based Management Interface for Docker
This article explains how Portainer can be used to manage a local Docker environment.

Docker : Host File System Permissions for Container Persistent Host Volumes
How do you make sure a non-root user has access to the host volumes accessed by a container? Here's one method.

Oracle REST Data Services (ORDS) : File Upload and Download (mod_plsql Style)
Upload and download files directly from the database using Oracle REST Data Services to replace the mod_plsql style upload/download functionality.

Upgrading to Oracle Database 18c (Non-CDB)
This article provides an overview of upgrading an existing non-CDB database to Oracle 18c.

Oracle Database 18c Installation On Fedora 29 (F29)
This article describes the installation of Oracle Database 18c 64-bit on Fedora 29 (F29).

Oracle Database 12c Release 2 (12.2) Installation On Fedora 29 (F29)
A brief guide to installing Oracle 12c Release 2 (12.2) on Fedora 29 (F29).