When selecting the Get Full Report in System>Database>Tablespace Summary. The report will not generate.
Rhel 7.x
DLP 16.x ,15.x
in the tomcat logs we see the following:
Thread: 307
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": error=2, No such file or directory
In the service account the oracle environment variables are not set or are incorrectly set:
1. find the service user in terminal:
ps ax o user:16,pid,pcpu,pmem,vsz,rss,stat,start_time,time,cmd | grep -i symantec | awk {'print $1" "$11'}
2. Edit the server users .bash_profile and add the ORACLE_HOME and ORACLE_SID environment variables
3. To reload the changes by running "source /home/<users>/.bash_profile"
4. Restart the DLP services so the service account sessions load the new environment variables
5. re run the Get Summary reboot button in the Enforce UI and the report should generate.