by Maciej Tokar | Jul 13, 2016 | Enterprise Edition, Multitenancy, Oracle 12c R1, Oracle Database
I would like to gather here in this document some specific traits of the Container Databases of Oracle 12c (Multitenancy) – the traits the are not broadly known. The list will be extended when some interesting characteristic of CDBs/PDBs pops up. RMAN...
by Maciej Tokar | Jul 7, 2016 | Enterprise Edition, Multitenancy, Oracle 12c R1, Oracle Database
Playing lately with PDBs and CDBs I have encountered interesting problem. While doing some investigations I found out that it is possible to affect the CDB$ROOT parameters from the PDB level what shouldn’t be possible in my humble opinion. Let’s go...
by Maciej Tokar | May 1, 2016 | Enterprise Edition, Multitenancy, Oracle 12c R1, Oracle Database
Requirements: The source must be opened in read-only mode. CDB that is to accommodate the remote PDB must have the database link defined to the remote database. It can point either to the CDB that the source PDB belongs to or directly to the source PDB. User in the...
by Maciej Tokar | May 1, 2016 | Enterprise Edition, Multitenancy, Oracle 12c R1, Oracle Database
This is an example based on Oracle 12c 12.1.0.2 with PSU July 2015 Single PDB configuration. I found last week some objects in my PDBs related to the auditing that were not compiled and in INVALID state. OBJECT_TYPE OWNER OBJECT_NAME -------------- ------- -----------...
by Maciej Tokar | Apr 21, 2016 | Books, Enterprise Edition, Multitenancy, Oracle 12c R1, Other
Franck Pachot @FranckPachot announced a new great book on Multitenancy: “Oracle Database 12c Release 2 Multitenant 1st Edition”. Franck is coauthor of that book. This is a MUST HAVE for all fans of the Multitenancy option. You can read more or buy a...
by Maciej Tokar | Apr 5, 2016 | Multitenancy, Oracle 12c R1
I was very surprised when I saw it was impossible to uncheck options during container database creation proces in DBCA. I am running Oracle 12.1.0.2.4 Standalone installation. The reason is that Oracle generally recommends that a CDB should have all options installed...