ora-39087 directory name data_pump_dir is invalid

Error :-

ora-39002 invalid operation

ora-39070 unable to open the log file

ora-39087 directory name DATAPUMP is invalid

Solution :-

create a new directory object (as a SYS user or as a user with CREATE ANY DIRECTORY privilege granted), grant READ and WRITE privileges on that DIRECTORY, and perform data pump export/import tasks.

Make sure that the /u01/EXPDP_IMPDP directory has 660 permission.

create or replace your directory and grant the following privileges' to user(system).

[oracle@prod u01]$ mkdir EXPDP_IMPDP

[oracle@prod u01]$ chmod 660 EXPDP_IMPDP

[oracle@QA u01]$ sqlplus sys/*****@PDB1 as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Jul 7 11:30:58 2022

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Last Successful login time: Sat Jun 25 2022 14:49:08 -04:00

Connected to:

Oracle Database 12c EE High Perf Release 12.2.0.1.0 - 64bit Production

SQL> create directory EXPDP_IMPDP as '/u01/EXPDP_IMPDP';

Directory created.

SQL> GRANT READ, WRITE ON DIRECTORY EXPDP_IMPDP TO system;

Grant succeeded.

SQL>