My Oracle Support Banner

agile9expdp.bat Fails with ORA-39002, ORA-39070, ORA-29283, ORA-06512 After Changing the Directory of export_directory.sql to Mapped Network Drive (Doc ID 2889710.1)

Last updated on AUGUST 21, 2022

Applies to:

Oracle Agile PLM Framework - Version and later
Generic Windows


Fails to export dmp file using agile9expdp.bat with below error in the console after changing the directory in export_directory.sql to mapped network drive.



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


The issue can be reproduced at will with the following steps:

  1. On the Windows server machine, map a network drive (i.e. M:) to the share folder created on the network server machine.
  2. Stop Agile Application Server service.
  3. Take backup of export_directory.sql file under %ORACLE_BASE%\admin\agile9\create\agile, and open the file with text editor
  4. Change the line to below:
  5. Gets error in the console


Changed the directory of exp_dir_agile in export_directory.sql to the mapped network drive


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.