The Enforce Server migration may fail in a three-tier environment when you upgrade to Symantec Data Loss Prevention version 15.5.
The issue occurs because Symantec Data Loss Prevention database "DatabaseProcessCheck" action remains active during the migration.
Stop all Symantec Data Loss Prevention database sessions:
Reboot the Enforce Server.
Access the database server.
Start SQL*Plus: sqlplus /nolog
Log on as the SYS user: SQL> connect sys/password@protect as sysdba Where password represents the SYS password.
Run the following query to identify processes running in the database: SELECT module, action, client_identifier FROM v$session WHERE ( UPPER(module) LIKE 'VONTU%' OR UPPER(client_identifier) LIKE 'VONTU%' OR UPPER(module) = 'SYMANTEC DLP: INCIDENT DELETOR' OR UPPER(module) = 'DATAUSER_MERGE' OR UPPER(module) = 'DATA INSIGHT DATA REFRESH' ) AND module <> 'Vontu Refresh CBO Stats' AND UPPER(module) NOT LIKE '%SCHEMA UPGRADER%';
If the query identifies running processes, run the following command to stop them: