Skip Headers
Oracle® Enterprise Manager Administrator's Guide for Software and Server Provisioning and Patching
11g Release 1 (
  Go To Table Of Contents
Go To Index


D Creating Templates for Oracle Database

This appendix explains how you can use Database Configuration Assistant (DBCA) to create templates for structuring newly created databases.

Note that DBCA can also be used to create scripts for creating databases using the templates. The necessary options for creating templates and scripts in the DBCA help have been highlighted in this appendix.

This appendix covers the following:


For detailed information on using DBCA to create and configure a database, see the Oracle Database 2 Day DBA Guide available at:

Creating Database and Templates Using DBCA

You can launch DBCA in interactive mode, provide details for creating a database, and in the end, instead of creating a database, you can save the specified information as a template. You can then use this template to create databases.

This section explains how you can create a database and other templates using DBCA.

Creating a Database using DBCA

Example: Create db glob - use template glob1.dbc

$ORACLE_HOME/bin/dbca -silent -createDatabase -templateName glob1.dbc -gdbname glob glob-sid -characterset AL32UTF8

Example: Create db glob with the location of datafiles - creating a database with the location where datafiles have to be placed in a given location

$ORACLE_HOME/bin/dbca -silent -createDatabase -templateName glob1.dbc -gdbname glob glob-sid-characterset AL32UTF8 -datafiledestination D: \ oracle\product\10.2.0\oradata\glob


If you want these databases to be monitored by Enterprise Manager Grid Control, then unlock the DBSNMP password of the databases.

Creating .dbt Template File from Existing Databases

template dbt dbca -silent -createTemplateFromDB -sourceDB GLOB -sysDBAUserName sys -sysDBAPassword change_on_install -templateName glob_template

Creating .dbc Template File from Existing Databases

template dbc dbca -silent -createCloneTemplate -sourceDB GLOB -sysDBAUserName sys -sysDBAPassword change_on_install -templateName glob_clone

Creating a Template File and Deleting Databases Using a Template

Creating Sample Script (template) and Databases

DBCA Command Line Help Options

dbca [-silent |-progressOnly |-customCreate] (<command> <options>) | ([<command> [options]]-responseFile <response file>) [-continueOnNonFatalErrors <true | false>]

Creating a Database

Configuring a Database

Creating a Template from an Existing Database

Creating a Clone Template from an Existing Database

Generate Scripts to Create Database

Deleting a Database

Configure ASM Disk Groups