Provision the Oracle EBS DBTechstack in DCT

Perform the following steps to provision a DBTechstack VDB.

1. Log in to DCT.

2. Go to Data > Data Management > VDBs.

3. Click the Actions button in the top-right corner and select Provision VDB from the drop down menu.

4. Select the DBTechstack dSource.

5. Click the TimeFlow tab.

6. Select a dSource snapshot.

7. Click Provision. The Provision VDB wizard will open.

8. Select an Environment. This environment will host the virtual DBTechstack and be used to execute hook operations specified in step 15 in the section.

9. Select E-Business Suite R12.2 DBTechstack from the Installation dropdown.

10. Select an Environment User. This user should be the Oracle user-outlined in the Requirements for Oracle EBS target databases for provisioning.

11. Enter a Mount Path for the virtual DBTechstack files.

12. Enter the EBS-specific parameters for the virtual DBTechstack. A subset of these parameters is discussed in more detail below:

    • The Privileged OS Account (Optional) field should contain the high-privileged user when the low-privileged user is being used for provisioning.

    • The Target APPS Password is the new apps password that is required to configure virtual DBTechstack. This password is encrypted when stored within the Delphix Continuous Data Engine and is available as an environment variable to the adcfgclone process.

    • Enter source Oracle Home directory name relative to Oracle base installation directory that was provided during linking of DBTechstack in Oracle Home field.

    • Ensure that the Target DB Hostname value is the short hostname, not the fully qualified hostname.

    • Enter the Target DB/CDB SID that is the new database SID (CDB SID in case of 19c) that is required to configure the virtual DBTechstack.

    • Enter the Target PDB Name field that is added for the pluggable database to be configured for the Oracle 19c database. Leave this field empty when using the Oracle 11g/12c database.

    • Enter the Target utl_file_dir , the default value for this field will be /var/tmp. The utl_file_dir initialization parameter is deprecated in Oracle Database 12c Release 2 (12.2.0.1).

    • Enter the DISPLAY variable, the default value is hostname:0.0.

    • (Optional) Enter the Custom Database Port Number on which the database listener must run.

      Enter a numeric port value in this field only if you want to use DB port customization. Leaving this field blank automatically uses the default port based on the port pool. The custom database port number is applicable only for the Oracle 19c database.

    • To run the DBTechstack and listener on a custom DB port, it is recommended to provide Target Port Pool value either as default or 0; also the Target Port Pool valuein DBTechstack is not related to Run/Patch Edition Port Pool value in AppsTier.

    • Enter the Target Port Pool, provide an available port pool. By default, the value is 1. The range for this value is 0 to 99.

    • Enable the Disable RAC option if you want to permit the Delphix Continuous Data Engine to automatically disable the RAC option for the binaries when applicable. The Disable RAC option is ticked (enabled) by default. This option is necessary if provisioning from a dSource with RAC dbTier because the binaries are relinked with the rac_on option even after running adcfgclone. If the source binaries already have the RAC option disabled (also the case for SI dbTier), the Delphix Continuous Data Engine ignores this option.

    • Enable the Cleanup Before Provision option if you want to permit the Delphix Continuous Data Engine to automatically clean up stale EBS configuration during a refresh. This option is recommended, but only available if your Oracle Home is patched with Oracle Universal Installer (OUI) version 10.2 or above.

      • With this option enabled: the Delphix Continuous Data Engine will inspect the target environment's oraInventory prior to refreshing this virtual DBTechstack. If any Oracle Homes are already registered within the specified Mount Path, the Delphix Continuous Data Engine will detach them from the inventory prior to running adcfgclone. These homes must be detached prior to running post-clone configuration. If they are not detached, adcfgclone will fail, citing conflicting oraInventory entries as an issue.

      • Without this option enabled: Oracle Homes that conflict with the specified Mount Path will be reported in an error instead of automatically detached. For refresh to succeed, you must manually detach conflicting Oracle Homes prior to refresh.

    • (Optional) Enter Oracle OS User and Group.

13. Click Next.

14. Enter a VDB Name.

15. Select a Target Group for the VDB. If necessary, click the Plus icon to add a new group.

16. (Optional)When provisioning a new VDB in the VDB Provisioning wizard, check the Auto VDB Restart box. Reference - Automatich VDB restart on target server after reboot.

17. Select a Snapshot Policy for the VDB. If necessary, click the Plus icon to create a new policy.

18. To avoid SnapSync conflicts, spread out your SnapSync policies for an EBS instance by one hour or more.

19. Click Next.

20. (Optional) Enter any custom hook operations that are needed to help correctly manage the virtual DBTechstack files. For more information about these hooks, when they are run and how operations are written, visit the Hook scripts for automation and customization page and section.

21. The Configure Clone hook will be run after the adcfgclone.pl tool has both mounted and configured the DBTechstack.

22. Click Next.

23. Click Submit.

When provisioning starts, you can review the progress of the job in the Datasets panel, or in the Job History panel of the Dashboard. When provisioning is complete, the DBTechstack VDB will be included in the group you designated and listed in the Datasets panel. If you select the DBTechstack VDB in the Datasets panel and click the Configuration tab, you can view information about the virtual files and its Data Management settings.

Next steps

See Register the EBS DBTechstack before database provisioning