8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Latest Articles

Multitenant : Copying a PDB in a Data Guard Environment in Oracle Database 18c
The STANDBY_PDB_SOURCE_FILE_DBLINK and STANDBY_PDB_SOURCE_FILE_DIRECTORY initialisation parameters make remote clones and plugin operations much simpler in Oracle 18c.

Multitenant : PDB Upgrades Using Priority Lists, Inclusion Lists and Exclusion Lists in Oracle Database 12c Release 2 (12.2)
From Oracle 12.2 onward it's possible adjust the priority in which PDBs are upgraded when running the 'catupgrd.sql' script with the parallel upgrade utility (catctl).

Multitenant : Rename Services During PDB Creation in Oracle Database 12c Release 2 (12.2)
In Oracle 12c Release 2 it is possible to rename PDB services during PDB creation to prevent clashes.

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.

Latest Videos

Check out my YouTube channel here.

Quick Links

You can follow me on these networks:

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

Search Docs

8i R3  9i R1  9i R2   
10g R1  10g R2     
11g R1  11g R2     
12c R1  12c R2  18c  19c 

Oracle Documentation

8iR3, 9iR1, 9iR2
10gR1, 10gR2, 11gR1, 11gR2
12cR1, 12cR2, 18c, 19c
ORDS 3.0, ORDS 17, ORDS 18
EM 10g, EM 11g, EM 12c, EM 13c
AS10g R2, AS10g R3,
FMW 11gR1, FMW 12cR1, FMW 12cR2
Oracle VM, VirtualBox

Oracle Resources

Oracle Developer Community, Technology Network, Oracle Support, Oracle Certification, Oracle Magazine, Ask Tom, Products, Downloads, Documentation, Forums, VirtualBox, VirtualBox Developer VMs, CPUs/PSUs/BPs/RUs/RURs