URT readiness user upgrade fails with ORA-29283 error

Products

• Data Loss Prevention Enforce
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

The Update Readiness Tool (URT) fails, and the output shows errors.

ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at line 4

 

Cause

URT utilizes the expdp ("protect") and impdp ("readinessuser") utilities to export the protect schema to DATA_PUMP_DIR which is then imported into the readiness user in order to run sandbox upgrade. While running these, it fails with the error message shown below which will be seen in the upgradereadiness*-details.txt output file.

ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation

Resolution

• Verify the DATA_PUMP_DIR exists: select directory_name, directory_path from dba_directories;

 

• Verify the protect user has the privilege to read and write to it: select privilege from dba_tab_privs where table_name LIKE 'DATA_PUMP_DIR' and grantee = 'PROTECT'; (replace PROTECT with the correct name for your schema user)

 

• Check the OS-level permissions for the folder.  The Oracle OS user must have permissions to write to the directory.