Cannot run DataBaseTablespaces Summary report after migrating Oracle DB to 19c

Products

• Data Loss Prevention Network Monitor and Prevent for Email and Web

Issue/Introduction

DataBaseTablespaces Summary report fails to run in the Enforce console after you have migrated your Oracle DB from 12c to 19c.

 

 

Environment

Release : 15.5

 

Cause

Localhost log files contains the entry:

Level: SEVERE
Source: com.vontu.manager.admin.database.DatabaseDiagnosticsReportLoader
Message: Error encountered while fetching database diagnostic reports data. Caught exception trying to fetch database diagnostics report data: Cannot run program "sqlplus": CreateProcess error=2, The system cannot find the file specified

Resolution

1. Add the new Oracle 19c client path to the Windows system environment variable in the ORACLE_HOME and in the PATH variable on the Enforce server
2. Restart the SymantecDLPManager service for the change to be recognised