In a previous post, we have seen how we import backup from non-cdb to pdb. Export from pdb and import into pdb In this post, we will see how we can import backup taken from the pluggable database and restore it to the non-cdb database. Step 1 : Connect to pluggable database : SQL> alter […]
Articles Tagged: Application Container
Export from pdb and import into pdb
In this post, we will see how we can take an export from one pdb and import into another pdb. Step 1: Connect to pdb from where you want to take export : SQL> alter session set container = orclpdb; Session altered. SQL> SQL> SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- […]
Unplug and plug an application container
In these posts, we will see how we can unplug the application container and plug it into different CDB. Step 1: Unplug application container. SQL> alter pluggable database app_pdb unplug into ‘/u02/app_pdb.xml’; alter pluggable database app_pdb unplug into ‘/u02/app_pdb.xml’ * ERROR at line 1: ORA-65025: Pluggable database APP_PDB is not closed on all instances. It […]
Upgrade and Patch Application in Application Container
In previous article we have seen Installing Application and Synchronizing it with Application PDB. Introduction to Application Container Application Container Creation and Installation of Application In this article, we will see upgrading Application and Patching Application. 1. Upgrade Application in Application Container : Before starting application upgrade you need to know the current version of […]
Application Container Creation and Installation of Application
In the previous article, we have seen Introduction of Application Container Introduction to Application Container In this article we will see creating Application Container, Installing Application in Container, Creating Application PDBs and syncing application PDB with application root. Step 1: Create an application root database SQL> CREATE PLUGGABLE DATABASE APP_PDB AS APPLICATION CONTAINER ADMIN USER APP_ADMIN […]
Introduction to Application Container
Application container is a new feature introduced in Oracle 12c Release 2. The main benefit of an application container in your environment is it makes application level patching and upgrade easy. Introduction of Multitenant Architecture In a product based company where you have multiple customers which are having same application running in your PDBs. We […]