Provisioning the Oracle 19C database

Procedure

Perform the following steps to provision Oracle 19c database VDB.

Refresh the Target DB environment from Manage > Environments so that the Listener brought up during DBTechstack provision gets discovered and the Installation Home to be listed in dropdown during Database provision. If the Target DB environment is not refreshed, you will see `This environment has no compatible Oracle Installation Homes` in the Installation Home dropdown in the Database provision.
Provision the EBS database to the target dbTier environment by following the steps outlined in Provisioning an Oracle VDB. For Oracle EBS database for 19c MT, provision the database by following the steps outlined in Provisioning an Oracle Virtual Pluggable Database (vPDB)
Note: Snapshot conflicts: when Snapshot is running against the DBTechstack, database, or AppsTier, the Delphix Continuous Data Engine also executes pre-clone logic to ensure the latest configuration is staged in the captured snapshots. Unfortunately, if multiple Snapshots are running against the same EBS instance concurrently, this pre-clone logic may fail and produce bad snapshots.
To avoid SnapSync conflicts, spread out your SnapSync policies for an EBS instance by one hour or more.
Select the correct Installation Home.
This should be the virtual DBTechstack you just added to the Delphix Continuous Data Engine.
Select an Environment User. This user should be the oracle user-outlined in Preparing Target EBS R12.2 Environments for Provisioning.
For the Container Database option, select the checkbox next to Create a New Container Database, and click Next.
Select a Target Group for the VDB.
In the vPDB Configuration section, provide the Target PDB name given during DBTechstack provision in the Oracle Pluggable Database Name field and provide any unique user-defined name in vPDB Name to be displayed in the Delphix Continuous Data Engine.
In vCDB CONFIGURATION section, provide the Target DB/CDB SID name given during DBTechstack provision in the Database Name field and SID and provide any unique user-defined name in the vCDB Name and Database Unique Name field, and click Next.
Click Advanced.
Select the correct Oracle Node Listeners value.
This should be the listener corresponding to the virtual DBTechstack you just added to the Delphix Continuous Data Engine.
(Optional) Add the EBS R12.2 dbTier environment file as a Custom Environment Variables entry.
This file can be specified as an Environment File with Path Parameters of $ORACLE_HOME/<CONTEXT_NAME> .
Replace <CONTEXT_NAME> with the virtual EBS instance's context name. The Delphix Continuous Data Engine will expand the $ORACLE_HOME variable at runtime.
For more information, see Customizing Oracle VDB environment variables

Note: To complete the DB Provisioning operation, you must provide content to configure clones and pre-snapshot hooks. You must either follow step 12 to use the hooks utility feature OR proceed with the conventional way by following steps 13-18.

To complete the DB Provisioning operation, you must provide content to configure clones and pre-snapshot hooks. The following are the content for both the hooks:
1. Configure Clone hook will be <DBTechstack Mount point>/hooksUtil/hooksRunner --operation configure . You must set a hooks environment variable DLPX_SOURCE_APPS_PASSWORD for providing the source apps schema password and DLPX_SYS_PASSWORD for SYSTEM schema password.
2. Pre-Snapshot hook :<DBTechstack Mount point>/hooksUtil/hooksRunner --operation pre-snapshot. You must set a hooks environment variable DLPX_SOURCE_APPS_PASSWORD for providing the source apps schema password. In case the apps password change is required in target VDB, you can set hook environment variables DLPX_TARGET_APPS_PASSWORD for providing the target apps schema.
  Note:
  For versions 19.3 or later, follow the below guidelines if you see any of the following error:
  1. ORA-01017: invalid username/password logon denied
  2. ORA-28040 During cloning: No Matching Authentication Protocol
  Occasionally, it is necessary to restart the database to resolve connectivity to the database. This is atypical but may be necessary in certain cases.
  On target container database, run the following command:
  alter system set SEC_CASE_SENSITIVE_LOGON=FALSE scope=both;
  The above ALTER command should run as a first configure clone hook.
  CODE
```
. "${ORACLE_HOME}/${ORACLE_SID}_${HOSTNAME}.env";
sqlplus -s "/ as sysdba" <<EOF
alter system set SEC_CASE_SENSITIVE_LOGON=FALSE scope=both;
EOF
```

Warning: EBS application database user accounts created in the earlier release uses a case-insensitive password version from an earlier release authentication protocol, such as the 10G password version. If your release user account passwords have not been reset and the following conditions persists, then take the action as described below:
On source, the database server has been configured with SEC_CASE_SENSITIVE_LOGON set to FALSE, so that it can only authenticate users who have a 10G case-insensitive password version. Then, on the target container VDB, it becomes necessary to set the SEC_CASE_SENSITIVE_LOGON to FALSE, to make authentication of users successful.

Note: To take advantage of the password protections introduced in Oracle Database 19c, users must change their passwords.

Add a Run Bash Shell Command operation to the Configure Clone hook to ensure that adcfgclone utility is run against the newly provisioned database for a high privileged user, as shown in the script below.

Note: You can pass the credentials securely to Hook Operations by setting up the base variables. See Other hook operations for more details.

Note: It is mandatory to set a hooks environment variable DLPX_SOURCE_APPS_PASSWORD for providing the source apps schema password. In case the apps password change is required in target VDB, you can set hook environment variables DLPX_TARGET_APPS_PASSWORD and DLPX_SYS_PASSWORD for providing the target apps schema and system schema passwords in respective hooks. The variables will be declared in the Credential Environment Variables hook sectionYou can pass the credentials securely to Hook Operations by setting up the base variables. See Other hook operations for more details.

For more information, refer to the Oracle EBS Database Hooks in OCI ExaCC or ExaCS page.