Oracle Multitenant

Unplug/Plug PDB in TDE Environment

By Mouhamadou Diaw In an oracle environment with Transparent Data Encryption (TDE) the transfer of PDB may require additional steps. In this blog we will see some steps which may be required when doing Unplug(…)

How to create an Oracle GoldenGate EXTRACT in Multitenant

Create an EXTRACT process into container database has some specificity : From the CDB$ROOT, create a common user and configure the database to be ready to extract data via GoldenGate: SQL> create user c##gg_admin identified by "*****" default tablespace goldengate(…)

Magic Upgrade to 21c with Replay Upgrade Feature

Last week I did some upgrade tests from 19c to 21c. The plan was to copy a 19c PDB to a CDB 21c using Online Clone and then upgrade it to 21c. I have done this many times for 19c(…)

Oracle disables your multitenant option when you run on EC2

I have installed Oracle 19.6 on an EC2 for our Multitenant Workshop training. And of course, during the workshop we create a lot of PDBs. If you don't have paid for the Enterprise Edition plus the(…)

Multitenant, PDB, ‘save state’, services and standby databases

By Franck Pachot . Creating - and using - your own services has always been the recommendation. You can connect to a database without a service name, though the instance SID, but this is not what you should do. Each(…)

12c Multitenant internals: PDB_PLUG_IN_VIOLATIONS

By Franck Pachot . In the previous post https://www.dbi-services.com/blog/12c-multitenant-internals-pdb-replay-ddl-for-common-users I've done some DDL on a common user to show how this is replayed later for PDBs that were not opened at that time. But what happens(…)

12c Multitenant internals: PDB replay DDL for common users

By Franck Pachot . In multitenant, you can create common Users, Roles, and Profiles. You create them in CDB$ROOT, with the CONTAINER=ALL clause (which is optional because it is the only possible value when connected to CDB$ROOT) but they are(…)

12c Multitenant Internals: compiling system package from PDB

By Franck Pachot . When I explain the multitenant internals, I show that all metadata about system procedures and packages are stored only in CDB$ROOT and are accessed from the PDBs through metadata links. I take an example with(…)

Multitenant internals: INT$ and INT$INT$ views

By Franck Pachot . This month, I'll talk - with lot of demos - about multitenant internals at DOAG conference. The multitenant dictionary architecture starts with a simple idea: system metadata and data are(…)

Multitenant dictionary: what is consolidated and what is not

By Franck Pachot . The documentation says that for Reduction of duplication and Ease of database upgrade the Oracle-supplied objects such as data dictionary table definitions and PL/SQL packages are represented only in the root. Unfortunately,(…)