Unable to apply 15.8 MP3 update on the Enforce Server

Products

• Data Loss Prevention
• Data Loss Prevention Enforce

Issue/Introduction

15.8 MP3 update fails with the following error when it tries to update the database.

 

Msiexec logs shows following entries:

Error updating database: Java process returned exit code 1 and wrote to standard error: Aug 04, 2022 11:17:10 AM com.symantec.databasemigration.CustomJDBCPropertiesOracleDatabaseConfigurationProvider getDatabaseConfiguration
INFO: Redirecting std-error to:C:\Users\DLPADM~1.DLP\AppData\Local\Temp\UpgradeSchema.sql6252250160489034374_stderr.log
FINE: SQLPlus standard error begin
Error 6 initializing SQL*Plus
SQLPlus standard error end
Caused by: java.lang.Exception: SQLPlus command failed with exit code1. Error message:Error 6 initializing SQL*Plus
MSI (s) (70!60) [11:18:32:252]: Note: 1: 2205 2:  3: Error 
MSI (s) (70!60) [11:18:32:252]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709 

Environment

Component : Data Loss Prevention Enforce 2/3 tier Deployment.

Cause

The installer is unable to connect to the Oracle database due to missing/incorrect ORACLE_HOME path or oracle client configuration.

Resolution

1. Check and verify TNSNAMES.ora file in the ORACLE client
2. Check and verify SQLnet.ora file in the ORACLE client
3. Make sure ORACLE_HOME is configured with the correct path.
4. Launch SQL PLUS and test the database connectivity as schema owner (typically protect) user.
5. Relaunch the installer after steps 1 to 4 are verified.