Preparing the ArcSight Database for Upgrade

Applies to on-premises, AWS, and Azure upgrades that involve the ArcSight Database.

In releases before ArcSight Platform 23.1.0, the back up tool for the ArcSight Database contained a defect that could cause the back up to fail under some conditions. To remediate this issue, you must apply a fix to the backup tool before you can back up the database as part of the upgrade process. Complete the following procedure to fix the tool. (Defect Tracking ID: OCTCR33I570016)

Log in to the master node where you downloaded the files.
Copy the db-installer_x.x.x-x.tar.gz file to the Database cluster node 1.

The file is located by default in the {unzipped-installer-dir}/installers/database/ directory where {unzipped-installer-dir} represents the folder that contains the downloaded installation files.
Log in to Database cluster node 1.
Create a directory to extract the db-installer_x.x.x-x.tar.gz file into. We will refer to this directory as {unzipped-db-installer-dir}.

Do not use the directories /root, /opt/vertica, or the existing database installer directory which is located by default at /opt/arcsight-db-tool. The files in /opt/arcsight-db-tools will be upgraded by the database upgrade tool.

To change to the directory, run the following command:
```
cd {unzipped-db-installer-dir}
```
To extract (untar) the db-installer_x.x.x-x.tar.gz file into the directory, run the following command:
```
tar xvfz  db-installer_x.x.x-x.tar.gz
```
To copy the upgrade file to the /opt/arcsight-db-tools/scripts directory, run the following command:
```
cp scripts/patch_vbr.sh /opt/arcsight-db-tools/scripts
```
To change to the scripts directory, execute the following command:
```
cd /opt/arcsight-db-tools/scripts
```
Grant execution rights to the following scripts, and then execute them in the following order:
```
chmod +x patch_vbr.sh
./patch_vbr.sh
```
Continue to the next task in the Checklist for upgrading your environment.