3.1.2.1 Application Template PDB Creation

• User has to login into CDB as a sys user.
• Application Template PDB has to be created under the CDB.
• This Application Template PDB is kept as a gold copy and recommended to not to use for any other purpose.
• Application Template PDB can have one common schema which is cloned to create further databases.

Below script creates the Application Template PDB with required grants under the CDB. DBA rights are required to perform this step.

Refer Application PDB and Appseed codes

Input sample for the script:

Table 3-1 PDB Creation

PDB Creation	Values
CDB Schema User Name	Sys
CDB Schema Password	Sys
CDB Host	1.1.1.1
CDB Port	1524
CDB Name	FC142CDB
DB Mounted Path	/scratch/db1800dat
Template PDB Name	Templatepdb
Common User Name	CMNUSER
Common User Password	CMNUSER