Oracle 12c introduced a new utility which replaces the need to run post installation SQL scripts after a database patch is applied.
This new utility is called “Datapatch” and it is shipped with 12c binaries as a component of OPatch distribution.
“Datapatch” is very useful in multitenant environments where multiple PDBs (Pluggable Databases) must be patched together.
This article will be discussing a new feature of Oracle 12c Database, the pluggable database, which builds on the container database concepts, found here. We will be discussing why it is needed, what it solves, its benefits and some examples of it.
This article will be discussing a new feature of Oracle 12c Database, Oracle Multitenant Architecture, which enables an Oracle Database to act as multitenant Container Database (CDB). A CDB includes one or many pluggable databases (PDBs). One default PDB, the seed PDB, is provided by Oracle in every CDB. Users cannot make changes to the seed PDB, but user can create additional PDBs using this default PDB. A CDB can contain 253 PDBs.