PDB

18c PDB switchover

By Franck Pachot . In multitenant, the recovery and availability are at CDB level. But customers asked for a switchover at PDB level so Oracle has done that in 18c, based on refreshable PDBs. For this test I have two(…)

18c, Cloud First and Cloud Only features: think differently

By Franck Pachot . Remember the times when the Oracle Software features were the same on all platforms? Where Oracle databases could be ported to any relevant platform? Where we were able to try any feature, freely, by downloading 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(…)

Unplug an Encrypted PDB (ORA-46680: master keys of the container database must be exported)

By Franck Pachot . In the Oracle Database Cloud DBaaS you provision a multitenant database where tablespaces are encrypted. This means that when you unplug/plug the pluggable databases, you also need to export /import the encryption keys. You cannot just(…)

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(…)

Drop PDB including datafiles may keep files open

By Franck Pachot . I like that Oracle drops the datafiles from the operating system when we remove them from the database (with drop tablespace or drop pluggable database) because I don't like to have orphean files remaining in the(…)

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,(…)