CLI cookbook: provisioning a single instance non-multitenant Oracle VDB

This topic describes how to provision a single instance non-multitenant Oracle VDB using the Delphix Engine command-line interface.

Prerequisites

You will need the following information:

The name of the VDB you want to create
The group in which to create the VDB
The Oracle database name
The Oracle database unique name
The Oracle database instance number
The Oracle database instance name
The source dSource or VDB from which you wish to provision. This will be referenced as the "container" in the "defaults" command below.
The semanticLocation, SCN, or timestamp of the point you want to provision from. You can run these commands to get the list of snapshots or Timeflow ranges:
```
snapshot list database=dexample
timeflow "dexample" timeflowRanges; commit
```
The base mount point on the target server where VDB data should be mounted
The source repository (oracle install) in which to create the VDB. These can be listed with the /repository list command.
If you are using a VDB template, the name of the template to use.

Procedure

Execute the database provisioncommand.
```
delphix> database provision
```
Execute the defaults command. Once you commit this command, it will return a partially constructed provision parameters object.
```
delphix database provision> defaults
```

Set the Timeflow point source Timeflow and location.

delphix database provision defaults *> set type=TimeflowPointSemantic
delphix database provision defaults *> set container=dexample
delphix database provision defaults *> set location=LATEST_SNAPSHOT

Commit the operation to populate the defaults, as provided by the browser interface. At this point, the operation can be committed, though you will likely need to change the defaults to match the information.
```
delphix database provision defaults *> commit
```

Set the name and group for the new VDB

delphix database provision *> set container.name=vexample
delphix database provision *> set container.group=""

Set the base mount point.

delphix database provision *> set source.mountBase=/mnt

Set the source config type to be a single instance non-multitenant Oracle, and set the database name and database unique name. When provisioning from a RAC or single instance non-multitenant oracle source, the default type will match that of the repository selected by the defaults operation.
```
delphix database provision *> set sourceConfig.type=OracleSIConfig
delphix database provision *> set sourceConfig.databaseName=vexample
delphix database provision *> set sourceConfig.uniqueName=vexample123
```

Set the instance name and number.

delphix database provision *> edit sourceConfig.instance
delphix database provision sourceConfig.instance *> set instanceNumber=1
delphix database provision sourceConfig.instance *> set instanceName=vexample
delphix database provision sourceConfig.instance *> back

Set the target repository.

delphix database provision *> set sourceConfig.repository='/env/opt/oracle'

Configure the Oracle database parameters. If you are using manually specified parameters, you can set the contents of source.configParams. If you want to use a template, you can set source.configTemplate.

(Optional) Configure customer environment variables.
Setting Environment Pair Values

delphix database provision *> edit customEnvVars
delphix database provision source.customEnvVars *> add
delphix database provision source.customEnvVars 0 *> set type=OracleCustomEnvVarSIPair
delphix database provision source.customEnvVars 0 *> set varName=MYVAR1
delphix database provision source.customEnvVars 0 *> set varValue=Value1
delphix database provision source.customEnvVars 0 *> back
delphix database provision source.customEnvVars 1 *> set type=OracleCustomEnvVarSIPair
delphix database provision source.customEnvVars 1 *> set varName=MYVAR2
delphix database provision source.customEnvVars 1 *> set varValue=Value2
delphix database provision source.customEnvVars 1 *> back

Note:

OracleCustomEnvVarSIFile file should be in the following format.

export VARNAME1=VARVALUE1export VARNAME2=VARVALUE2

When provisioning to a RAC target, use the type as OracleCustomEnvVarRACPair or OracleCustomEnvVarRACFile.

delphix database provision source.customEnvVars 0 *> set type=OracleCustomEnvVarRACPairdelphix database provision source.customEnvVars 0 *> set clusterNode=targetnode1delphix database provision source.customEnvVars 0 *> set varName=MYVAR1delphix database provision source.customEnvVars 0 *> set varValue=Value1delphix database provision source.customEnvVars 0 *> back

Commit the result.

delphix database provision *> commit