Unable to apply 15.8 MP3 update on the Enforce Server
search cancel

Unable to apply 15.8 MP3 update on the Enforce Server


Article ID: 247719


Updated On:


Data Loss Prevention Data Loss Prevention Enforce


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 


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


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


  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.