When you need an empty database for a new application, you can create it with a database resource template. The template is configured to allocate resources to the database.

Verify that you have access to the organization and database group in which to create the new database.

Verify that you have Clone permission on the catalog database and Create databases permission on the database group in which you create the database.

Verify that you have Use template permission on at least one resource template, backup template.

1

Navigate to the organization in which you want to create the database.

2

Click the Manage & Monitor tab.

3

Select the database group in which you want to create the database.

4

Click the Databases tab.

5

Click the plus (+) icon to start the Create Database wizard.

6

View the summary, and click Finish.

Wizard page

Action

Creation Type

Click Create new database

General

Specify the database name, type, base database template, and database group from which to create the database.

Name

Type a name to identify the database within the Data Director user interface.

Description

(Optional) Enter a description of this database.

Database Type

Select a database type from the drop-down menu. For example, Oracle, MySQL, or vPostgres.

Base DB Template

Select a base database template from which to create the database from the drop-down menu. For example, Oracle 11g.

Database Group

If you selected a database group, this field is filled in for you.

Configuration

Specify the configuration information for this database.

Host name

(Optional) Type a host name for the database. By default this field is populated with the name you used to identify the database.

Database name

Type a name for the database. By default this field is populated with the name you used to identify the database.

Resource Template

Select a database resource template from the drop-down menu. For example, small, medium, or large.

Parameter Group

Select a parameter group for the database or accept the default parameter group. Parameter groups contain database configuration settings such as checkpoint timeout, write-ahead log buffers, encoding, and shared buffers.

Backup template

Select a backup template from the drop-down menu. You can select a backup template for specific purposes, such as development, or select no backups (Disabled).

Storage

Specify the data, log, and backup disk storage allocation for this database.

Basic Configuration

Specify storage allocation for each disk type. The values you specify are evenly divided among the available disks. For example, if your database uses three data disks, and you specify 6 GB of data disk allocation, Data Director allocates 2 GB of storage space to each data disk.

Advanced Configuration

Specify storage allocation for each disk type, and, if multiple datastores are available, choose the datastore the database should use for its virtual disks. For example, you may choose to map data disks to faster datastores to provide optimum performance, and backup disks to slower datastores where disk performance isn't of critical importance.

Administrator

Specify the database administrator user name and password.

Administrator user name

Type an administrator account for the database. Each database requires an administrator that can perform all schema management operations. The administrator account is specific to the database and cannot log in to Data Director.

Password

Type an administrator account password.

Options

Expiration

Select a date and time at which the database expires. Then select an action upon expiration, or no expiration.

Tags

(Optional) Select one or more tags for this database. Use tags to filter the list of databases that you view in an organization's Databases tab, for example, all your customer relationship databases can have a tag called CRM.

Snapshot

(Optional) Select the check box to take a snapshot backup of the database when creation and provisioning finishes.

IP Whitelist

Select Allow all connections to the database. Optionally, select Only allow connections from selected IP whitelists (next page), and select an organization IP whitelist or create a custom IP whitelist.

The database appears in the Databases List with a status of Creating. The process can take several minutes. The status changes to Running when creation finishes successfully.

You can load the database data and use the database.