Page tree

The Manager enables you to create and manage templates for ease of provisioning and as a means of enforcing standardization across databases and clusters in your environment.

The following template types are available:

  • Create Database (Windows)
  • Remove Database (Windows)
  • Upgrade Database (Windows)

About the standard variables in templates for Oracle on Windows

The following template variables can be used to populate fields in the corresponding wizard. For example, if a database name is entered in step 2 of the wizard, the database name can appear as a selectable option or appended to an entry in another area of the wizard.

Template

Standard variable

Details

Create Oracle Database

{DB_UNIQUE_NAME}

First 8 characters of the BMC Database Automation database name.

 

{VERSION}

Specific version, for instance 10.2.0.2.

 

{SID_PREFIX}

First 8 characters of the DB_UNIQUE_NAME for single instance databases. First 7 characters of the DB_UNIQUE_NAME for clustered databases.

 

{VERSION_TAG}

General version.

 

The following rules apply for standard variables:

  • All tags can be used for any of the elements defined after the first page.
  • Except for {DB_UNIQUE_NAME}, all tags must be in either the editable or non_editable section of the template.

Example

<editable>
  <sid_prefix>{SID_PREFIX}</sid_prefix>
</editable>

Note

If you create custom fields, they can also be used as variables in templates. To add custom fields to a template, see Adding custom fields to a template.