Skip Headers
Oracle® Enterprise Manager Administrator's Guide for Software and Server Provisioning and Patching
10g Release 5 (

Part Number E14500-04
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

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:


DBCA uses patterns, or otherwise called Templates, which create either a new database with existing patterns or a pattern itself based on an existing base. The following are the template files that DBCA can create:

These templates, which are in the form of XML files, contain information about the database including database options, init.ora parameters, and storage attributes (datafiles, tablespaces, controlfiles and redologs).

The demo templates such as Data_Warehouse.dbc, General_Purpose.dbc, Transaction_Processing.dbc, and New_Database.dbt are available at the following location:

% ORACLE_HOME% /assistants/dbca/templates

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

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

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 Bases

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

Creating .dbc Template File from Existing Bases

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

Creating a Template File, Deleting Bases, Using a Template

Creating Sample Script (template) and Bases

Creating Database and Templates Without Using DBCA

dbca [-silet |-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