Category: Multitenant

How to create PDBs with different Character Sets in the same CDB

Introduction Oracle Multitenant enables you to migrate and consolidate multiple databases as PDBs into one CDB. Starting with Oracle Database release 12.2.0.1, PDBs within the same CDB can be of different character sets, provided the CDB is created with the AL32UTF8 character set. If you are using Application Containers, then all application PDBs under the…

Create PDBs in a Data Guard Environment with TDE enabled

Introduction See what happens and how to proceed after creating or cloning a PDB in a Data Guard environment while Transparent Data Encryption (TDE) is enabled. If you are new to TDE, have a look at thisĀ blog postĀ first. The Environment I’m using Oracle Database Cloud service Enterprise Edition Extreme Performance. The database version is 19.8.…

Is the Multitenant Option mandatory in the Oracle Cloud?

No, not necessarily. All Oracle databases from version 12.1 in the Oracle Cloud are automatically deployed using the Multitenant architecture. This is probably the reason why this question is asked. Let’s have a deeper look. Database Cloud Service (DBCS) License Included Oracle provides four pre-defined software editions in the Oracle Cloud to choose from. Each…

Refreshable PDB Switchover in Standard Edition Cloud Service

Oracle Database Standard Edition in the Cloud offers additional features including: All versions: Transparent Data Encryption, which is available only for Enterprise Edition on-prem. 18c onwards: Refreshable PDB Switchover, which is available only for EE on Engineered Systems (Exadata and ODA) on-prem. Additionally, in the Cloud you benefit from Automatic Backups, one-click Restore, one-click CPU up/down Scaling, and Simplified Patching. This…