DLP Enforce upgrade fails with error "Oracle Permissions Check Failed: The database precheck has detected a problem"

book

Article ID: 184464

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

You are attempting to update your Enforce server version 14.6 Maintenance Patch 1 to 14.6 Maintenance Patch 3 but it fails while running the precheck.

In the precheck.log you found in the updates folder where you ran the installer from you found this error: 

Running Prechecks
Extracting Properties from Config Files
Detecting Enforce or Single-Tier System
Performing pre-update steps
Stopping Services
VontuIncidentPersister service killed
VontuManager service killed.
VontuMonitorController service killed.
VontuUpdate service killed.
VontuNotifier service killed.
Checking File Permissions
Unable to connect to database to verify permissions

Oracle Permissions Check Failed:
The database precheck has detected a problem. The upgrade has been canceled. Your system remains on the current version. Please see the Troubleshooting section of the Upgrade Guide for solutions.

In the i4j_log_EnforceUpgradeInstaller_xxxxxxxxxx.log found in your user's temp folder %temp% the following error appears: 

[ERROR] com.vontu.install.i4j.VerifyDBPermissionsAction [ID 124827]: SQLException while verifying Oracle permissions: ORA-04063: package body "PROTECT.PRECHECK" has errors
ORA-06508: PL/SQL: could not find program unit being called: "PROTECT.PRECHECK"
ORA-06512: at line 1

[INFO] com.vontu.install.i4j.VerifyDBPermissionsAction [ID 124827]: Variable changed: oraclePermissionsErrorMessage=<Error>
Oracle Permissions Check Failed:
The database precheck has detected a problem. The upgrade has been canceled. Your
system remains on the current version. Please see the Troubleshooting section of 
the Upgrade Guide for solutions.
</Error>[class java.lang.String]
[ERROR] com.vontu.install.i4j.VerifyDBPermissionsAction [ID 124827]: Execute action not successful after 563 ms
[INFO] com.vontu.install.i4j.VerifyDBPermissionsAction [ID 124827]: Rollback barrier reached
[INFO] com.install4j.runtime.beans.screens.CustomizableProgressScreen [ID 100333]: Canceled

Cause

The Protect user has insufficient permission to compile the precheck package.

Resolution

Ask your Database Administrator to verify the missing permissions required by protect user to compile the precheck package.

If they identify that the SYS.DBMS_UTILITY and SYS.DBMS_SQL are missing then run the following statements to grant the protect user the permissions:

grant execute on SYS.DBMS_UTILITY TO PROTECT; 
grant execute on SYS.DBMS_SQL TO PROTECT;

If the missing permissions required differ from the above then you may need to grant the required permission to the protect user.