Storage Provisioning for Oracle Application

 

Goal

This workflow will automate the provisioning of the 7-mode storage objects associated with an Oracle database.  In this sample, the workflow creates volumes for the Oracle data, archive logs, redo logs, exports, control and binaries.  Qtrees are created in the binary volume, and a separate database host volume (with qtrees) is created if it doesn’t already exist.  If it does exist, the workflow will skip the Database host volume creation step.

This workflow includes:

·         Creation of Oracle System ID Volumes based on the workflow inputs

·         Sizing the volumes based on the usable size provided as user input

NOTE:  This workflow is an example of what is possible for deploying the storage for an Oracle application.  The purpose of this workflow is to act as a template for you to use when creating your own specific Oracle workflow.

 

Database Input parameters:

1) Oracle SID (required)

The System ID (SID) you are using for your Oracle Database.

2) Environment (required)

This is a dropdown selection, with a default value of “dev”.  The dropdown list includes the following values: dev, stg, tst, prd.  This user input is not locked, and can you can type in a value of your choosing.

NOTE: The value specified for environment will be used in the name of the volumes created. 

                Format: <SID>_<Env>_oraVolume

 

 

 

 

 Size Input parameters:

1) Total Data Size (required)

The usable size in GB you would like for the Oracle data volume.  Valid values are from 0.5GB to 1000GB.  

2) Total Redo Size (required)

The usable size in GB you would like for the Oracle redo log volume.  Valid values are from 0.5GB to 1000GB.

3) Total Archive Size (required)

The usable size in GB you would like for the Oracle archive log volume.  Valid values are from 0.5GB to 1000GB

4) Total Export Size (required)

The usable size in GB you would like for the Oracle export volume.  Valid values are from 0.5GB to 1000GB

5) Total Control Size (required)

The usable size in GB you would like for the Oracle control volume.  Valid values are from 0.5GB to 1000GB

 

 

 

 

 

 

 Export Input parameters:

1) Root Hosts (required).  This is the list of hosts requiring root access to the storage being provisioned.  Multiple hostname or IP address entries need to be comma delimited.

2) Read-Write Hosts (required).   This is the list of hosts requiring read-write access to the storage being provisioned.  Multiple hostname or IP address entries need to be comma delimited.

Result

The workflow will result in creating the 7-mode volumes & qtrees required for an Oracle database.

 

Error Handling

1)       An error message is displayed if there is no storage controller or aggregate with enough capacity to fulfill the storage provisioning request.