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 9.3.5.0 and later
Generic Windows

Symptoms

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.


 

ERROR

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





Steps

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



Changes

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

Cause

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
Symptoms
Changes
Cause
Solution
References


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