Update readiness tool failed to run with errors ORA-39002, ORA-39070 and ORA-29283

Products

• Data Loss Prevention Core Package
• Data Loss Prevention
• Data Loss Prevention Endpoint Suite
• Data Loss Prevention Enforce

Issue/Introduction

You are trying to run the latest version of the Upgrade Readiness Tool (URT) and the tool fails to run with the below error:

Error: Update readiness tool failed to run

Below errors are seen in the URT output:

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation: nonexistent file or path [29434]

or

ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation: unexpected "LFI" error (1509)[29437]

Environment

DLP 15.8 or above

Cause

1. Mismatched Oracle client and server version in a 3-tier environment

2. Insufficient privileges for the data pump to perform the sandbox upgrade.

3. DATA_PUMP_DIR has not such file or directory

Resolution

1. Ensure that the Oracle client version is the same as the Oracle server version in a 3-tier environment.

2. Provide the required permissions to the data pump by running the below commands.

NOTE - The commands assume the Oracle database user to be the default i.e. “protect”. Replace the user as appropriate if not using the default user.

sqlplus sys/protect as sysdba
GRANT read, write ON directory data_pump_dir TO protect;
GRANT SELECT ON dba_registry_history TO protect;
GRANT SELECT ON dba_temp_free_space TO protect;
GRANT SELECT ON v_$version TO protect;
GRANT EXECUTE ON dbms_lob TO protect;

For Oracle 19c, additionally run the below command

GRANT create job TO protect;

3. Run on the oracle server

namei -l <DATA_PUMP_DIR_directory_path>

and if the output will be as below:

namei -l <DATA_PUMP_DIR_directory_path>
f: /u01/app/oracle/FolderName/db/rdbms/log/
dr-xr-xr-x root root /
drwxr-xr-x root oinstall u01
drwxr-xr-x root oinstall app
drwxrwxr-x oracle oinstall oracle
FolderName - No such file or directory

Then you need to create a new FolderName in the Oracle server because the current one does not exist. 

Additional Information

See also: Article ID: 160076 Verify or Grant Oracle Database Permissions to Protect User or Upgrade Readiness User

See also: Article ID: 160062 Verify the protect database user has the correct privileges in DLP