Install the Patch on the Database Tier

After you transfer and extract the contents of the patch set file (p37171708_82040_Generic.zip), you can install the patch on the database tier. Also, you extract the contents of hdr8204_artifacts.zip file to a directory on the database tier.

Ensure that you do the following before you install the patch on the database tier:

• Have read and write permissions to the directories, subdirectories, and their files where you extracted the hdr8204_artifacts.zip file on database tier.
• ORACLE_HOME environment variable is configured on the database tire.
• ORACLE_HOME/bin directory is configured in the PATH on the database tier.

To install the patch on the database tier:

1. Before you apply the patch, take a backup of the HCT schema.
2. Navigate to a database directory from the directory where hdr8204_artifacts.zip is extracted.
3. Run chmod 700 on run_dt_patch.sh.
4. From the patch database directory run also chmod 700 hct/hct.sh.
5. Run ./run_dt_patch.sh.
   The run_dt_patch.sh script prompts you to enter HDR DB Host Name, HDR DB Port number, HDR DB service name and HCT User DB password, provide valid values and hit enter.
6. Once the patch script (run_dt_patch.sh) completes successfully on the database tier, run the ./update_dt_patch_release_info.sh script to update the HDR 8.2.0.4 patch release information in the HDR_RELEASE_INFO table for the database tier.
7. Run chmod 700 on update_dt_patch_release_info.sh and ctb/ctb.sh.
8. Run ./update_dt_patch_release_info.sh.
   The update_dt_patch_release_info.sh script prompts you to enter HDR DB Host Name, HDR DB Port number, HDR DB service name, and CTB User DB password. Provide valid values and select enter.