1. Multi-Tenant Deployment
  2. Deployment and Installation Steps
  3. Creation of Application Template
  4. Steps to be followed
  5. Application Template PDB Creation

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 Example 8-3

Input sample for the script:

Table 3-1 Application Template PDB Creation

Input Type User Input
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