3.2.2.1 Application Root and Application Seed Creation

• Application Root

  Application Root is created from Application Template PDB through clone. Application Root holds all the DB objects as single source repository. Initially, the database sources are copied Application Template PDB. On subsequent patch set upgrade, the database sources are deployed in Application Root using upgrade mode.

• Application Seed

  After Application Root creation, Application Seed to be created by clone from Application Root. Application seed to be synched with Application Root, whenever there is DB objects deployed in Application Root. That is, Application seed has latest DB references of Application Root. Application seed is used as template to create (entity) Application PDBs.

Below script creates the Application root and Application seed. DBA rights are required to perform this step.

Refer Application PDB and Appseed codes

Input sample for the script:

Table 3-2 Application Root and Seed Creation

CDB	Values
CDB Schema User Name	Sys
CDB Schema Password	Sys
CDB Host	1.1.1.1
CDB Port	1524
CDB Name	FC142CBD
DB Mounted Path	/scratch/db1800dat
Template PDB Name	Templatepdb
Approot Name	Approot1
Pdb to app pdb path	C:\app_18c\client\user\product\18.0.0\client_1\rdbms\admin\pdb_t o_apppdb.sql
Common User Name	CMNUSER