Upgrading the Database

The upgrade process is irreversible. Before beginning this procedure, ensure that you back up the database. Also, be patient as the Database upgrade might take time to complete. The Database might need time to create indexes and complete upgrade tasks. The Database upgrade might appear to be complete; however, if you start the product before the Database upgrade is complete, you might experience errors and performance issues.

Follow the Checklist: Upgrading Your Environment to ensure a successful upgrade.

If the installation is passwordless, you need to generate the ssh public key using the command- ssh-keygen.

Log in to the master node where you downloaded the files.
Copy the {unzipped-installer-dir}/installers/database/db-installer_x.x.x-x.tar.gz file to the Database cluster node 1.
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 (default is /opt/arcsight-db-tools). The files in /opt/arcsight-db-tools will be upgraded by the database upgrade tool.

Change to the directory.
```
cd {unzipped-db-installer-dir}
```
Extract (untar) the db-installer_x.x.x-x.tar.gz file into the directory using the following command:
```
tar xvfz  db-installer_x.x.x-x.tar.gz
```

Execute the following command to start the upgrade.

./db_upgrade -c upgrade-utilities

The output of the command will look similar to the following:

Please ignore the output message of, cannot concatenate 'str' and 'NoneType' objects Property File is missing, File: /opt/arcsight-db-tools/config/db_credentials_default.properties

Upgrade related changes cannot be rolled back, do you want to continue with the upgrade (Y/N): y
Starting upgrade...

********************* Start of Database Upgrade ******************
Enter previous installed location (/opt/install-db):/opt/arcsight-db-tools
cannot concatenate 'str' and 'NoneType' objects
Running Pre-Upgrade checks
Checking all database nodes are UP
All database nodes are UP
cannot concatenate 'str' and 'NoneType' objects
Replacing files in installed location
Upgrading script and config files.
Creating backup directory: /opt/arcsight-db-tools/oldVersion
Backing up: /opt/arcsight-db-tools/db_ssl_setup
...
Upgrading: /opt/arcsight-db-tools/db_ssl_setup
...
Property File is missing, File: /opt/arcsight-db-tools/config/db_credentials_default.properties
Version specific upgrade methods
********************* Database Upgraded Complete. Version is 3.4.0 ******************

Change to the directory you provided when answering the prompt Enter previous installed location (/opt/install-db): in the previous step:

cd /opt/arcsight-db-tools

If OS has been upgraded, the file /etc/pki/tls/cert.pem will be reset during the upgrade, requiring the schema registry setup to be invalidated.

To correct this, run the following command:

If you need help locating the issue_ca.crt file for your database node, see Completing the Database Setup.

./schema_registry_setup <FQDN of ArcSight Platform Virtual IP for HA or single master node> issue_ca.crt

Run the following command:
```
./db_upgrade -c upgrade-db-rpm
```

Database server's root password may be asked during the process.

Follow the output instructions to complete the upgrade, which will include starting the database and starting the database event consumer.
(Optional) Start the firewall service.