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:

  CODE

  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

1. Execute the database provisioncommand.

   CODE

   delphix> database provision

2. Execute the defaults command. Once you commit this command, it will return a partially constructed provision parameters object.

   CODE

   delphix database provision> defaults

3. Set the Timeflow point source Timeflow and location.

   CODE

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

4. 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.

   CODE

   delphix database provision defaults *> commit

5. Set the name and group for the new VDB

   CODE

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

6. Set the base mount point.

   CODE

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

7. 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.

   CODE

   delphix database provision *> set sourceConfig.type=OracleSIConfig
   delphix database provision *> set sourceConfig.databaseName=vexample
   delphix database provision *> set sourceConfig.uniqueName=vexample123

8. Set the instance name and number.

   CODE

   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

9. Set the target repository.

   CODE

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

10. 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.

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

    CODE

    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.

• CODE

  export VARNAME1=VARVALUE1export VARNAME2=VARVALUE2

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

• CODE

  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

12. Commit the result.

delphix database provision *> commit