multitenant-application-containers-12cr

multitenant-application-containers-12cr
[41]Home » [42]Articles » [43]12c » Here

Multitenant : Application Containers in Oracle Database 12c Release 2 (12.2)

Application containers are a new feature in Oracle Database 12c Release
2 (12.2) that allow you to define an application root, like a mini CDB
root container, along with dependent application container PDBs. An
application root can house one or more applications, each made up of
shared configuration, metadata and objects that are used by the
pluggable databases associated with the application root.

The examples in this article use Oracle Managed Files (OMF) so no file
name conversions are needed. You can add the appropriate
FILE_NAME_CONVERT or PDB_FILE_NAME_CONVERT settings if you need them.
* [44]Manage an Application Root
* [45]Manage Application PDBs
* [46]Manage Applications
+ [47]Install an Application
+ [48]Upgrade an Application
+ [49]Uninstall an Application
* [50]Application Common Objects
* [51]Manage an Application Seed
* [52]Application Container Views

Related articles.
* [53]Multitenant : All Articles

Manage an Application Root

Creating a new application container is similar to creating a regular
PDB, but you need to include the AS APPLICATION CONTAINER clause.
CONN / AS SYSDBA

CREATE PLUGGABLE DATABASE appcon1 AS APPLICATION CONTAINER ADMIN USER app_admin
IDENTIFIED BY Password1;
ALTER PLUGGABLE DATABASE appcon1 OPEN;

You can also create an application container by cloning an existing
PDB.

Once the application container is closed it can be dropped in the
normal way provided it has no associated PDBs.
CONN / AS SYSDBA

ALTER PLUGGABLE DATABASE appcon1 CLOSE;
DROP PLUGGABLE DATABASE appcon1 INCLUDING DATAFILES;

Basic management of the application container is similar to a regular
PDB, including cloning, unplug, plugin etc. An application container
can only be unplugged if it has no associated PDBs.

Manage Application PDBs

To create an application PDB you must be connected to an application
root, not the CDB root. The application root container in this case is
in the local instance, but it could be in a remote instance if we
defined a local proxy PDB to pointing to it.
CONN / AS SYSDBA
ALTER SESSION SET container = appcon1;

Once connected to the application root we can create a pluggable
database as normal, only this time it is an application PDB.
CREATE PLUGGABLE DATABASE apppdb1 ADMIN USER pdb_admin IDENTIFIED BY Password1;
ALTER PLUGGABLE DATABASE apppdb1 OPEN;

Once we've created a new application PDB we should sync it with all the
applications defined in the application root. We will discuss
applications later.
ALTER SESSION SET container = apppdb1;
ALTER PLUGGABLE DATABASE APPLICATION ALL SYNC;
Source .... : https://oracle-base.com/articles/12c/multitenant-application-containers-12cr2
--------------------------