Error running migration utility - Missing permissions on Oracle database despite having granted them
Last Updated June 21, 2019
As part of your DLP environment upgrade, you have migrated your DLP database to a new Oracle server
You have successfully executed the Grant Permissions section of the Upgrade Guide to the database, connecting via SQLPlus
You have run the Update Readiness Tool (URT) from the Enforce using a SQLPlus connection and it has completed without errors
However, when you execute the Migration Utility you receive an error stating that the required permissions are missing on the Oracle database
Any DLP upgrade that utilitises the migration utility tool.
In the MigrationUtility.log file:
SEVERE: Missing permissions while checking of oracle database permissions[GRANT WRITE ON DATA_PUMP_DIR TO DLP_OWNER;, GRANT READ ON DATA_PUMP_DIR TO DLP_OWNER;].
The URT tool uses the connection information in the TNSNames.ora file to broker the connection to the Oracle DB via SQLPlus.
The Migration Utility, however, uses the JDBC.properties file for its database connection information.
If you have updated the TNSNames.ora to point to the new DB instance, but have forgotten to update the JDBC.properties connection string with the same information, the Migration Utility will connect to the old DB and fail.
Update the JDBC.properties file located in the config folder on the Enforce server with the correct information for the new database.