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 will be kept as a gold copy and recommended to not to use for any other purpose.
Application Template PDB can have one common schema which will be cloned to create further databases.
The script (Application_Template_PDB_Creation.sql )will create the Application Template PDB with required grants under the CDB. DBA rights are required to perform this step.

Input sample for the script:

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

Parent topic: Steps to be followed