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

Step 2: Open application root database

Step 3: Save open state for this database

Step 4: Check from v$pdbs view

Step 5: View datafile and tablespace of application container :

We can see here SYSTEM, SYSAUX and UNDO tablespaces are created in application root.

Set container to application container.

Step 6: Check granted privilege to application container admin user.

Step 7: Check privilege of PDB_DBA role.

Step 8: Create tns entry for application pdb :

Step 9: Connect to application container and install the application using begin install and version

Step 10: We will create one user and create some tables and data for that user.

Step 11: Connect to that schema

Step 12: Create a table in SAL_USR schema :

Step 13: End application installation using END INSTALL :

Step 14: Check the application version from DBA_APPLICATIONS :

Stay tuned for More articles on Oracle Multitenant

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.