How Can We Help?
Search for answers or browse our knowledge base.
fixing Enforce Server migration fail for three-tier environments due to “DatabaseProcessCheck”
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:
SET SERVEROUTPUT ON;
DECLARE
CURSOR inactive_process IS
SELECT 'ALTER SYSTEM KILL SESSION ' || '''' || sid || ',' ||
serial# || ''''
AS kill_stmt, module, sid, serial#
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%';
BEGIN
FOR x IN inactive_process LOOP
DBMS_OUTPUT.put_line(x.kill_stmt);
EXECUTE IMMEDIATE x.kill_stmt;
END LOOP;
END;
/
-
Resart the migration process.