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\<Users>\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 

OR 

CREATE OR REPLACE PACKAGE BODY DI_DataRefresh
*
ERROR at line 1:
ORA-01031: insufficient privileges
 
at com.symantec.databasemigration.oracle.sqlplus.SQLPlusExecutor.execute(SQLPlusExecutor.java:197)
at com.symantec.databasemigration.oracle.sqlplus.SQLPlusExecutor.execute(SQLPlusExecutor.java:127)
at com.symantec.dlp.DatabaseUpdateUtility.DatabaseUpdateUtility.updateDatabase(DatabaseUpdateUtility.java:98)
... 1 more
 
MSI (s) (4C!94) [10:32:01:684]: Note: 1: 2205 2:  3: Error 
MSI (s) (4C!94) [10:32:01:684]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709 
MSI (s) (4C!94) [10:32:01:684]: 
CustomAction updateDatabaseOnPatch.401D797E_336E_470A_B482_AFC1EA3637F4 returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 10:32:01: InstallFinalize. Return value 3.

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. Check oracle permissions for protect user see: Verify Oracle Permissions
6. Relaunch the installer after steps 1 to 4 are verified.