Creating Application PDB and Syncing with Application Root

In a previous post, we have seen creation steps of Application Container and Installation of Application in the Application container.

In this article, we will see Creation Steps of Application PDB and synchronization of Application PDB with Application Container.

Create application PDB:

Step1: Connect to application root :

[oracle@localhost oradata]$ sqlplus sys/oracle@app_pdb as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 29 01:32:29 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

Step 2: Create application pdb

SQL> CREATE PLUGGABLE DATABASE app_sal admin user adm_sal identified by oracle;

Pluggable database created.

Step 3: Open pluggable database

SQL> ALTER PLUGGABLE DATABASE APP_SAL OPEN;

Pluggable database altered.

Step 4: Change current container as application pdb

SQL> ALTER SESSION SET CONTAINER=APP_SAL;

Session altered.

Step 5: Sync application pdb with application root :

SQL> ALTER PLUGGABLE DATABASE APPLICATION APP_PDB SYNC;

Pluggable database altered.

Step 6: Check table we have created in the application root

SQL> COL NAME FORMAT A20
SQL> COL DESCRIPTION FORMAT A50
SQL> SELECT * FROM SAL_USR.SAL_MST;

NAME		     DESCRIPTION
-------------------- --------------------------------------------------
ID001		     THIS IS TEST ENTRY

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