Use Oracle-Linux expdp to windows network drive

Question

I am trying to use expdp to perform an export on some tables of my Oracle DB

my code:

expdp AAA/***@xxx schemas=AAA include=TABLE:\"= \'TBL001\'\" directory=DUMP_DIR dumpfile=dmpfile.dmp logfile=lgfile.txt

This is what I get:

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

I checked online and I guess it is a problem of corssing different OS and/or authorization

This is my situation:

• Oracle DB on Linux machine with CentOS 7
• directory=DUMP_DIR is a directory object on DB. It was created as I saw the path through Linux Machine = smb://Win_machine1/dump_oracle/
• DUMP_DIR is located on a windows server 2008 R2 (Win_machine1)
• I can reach DUMP_DIR from Oracle Machine giving windows credentials
• I launch a .bat file in Win_machine1 with expdp command written above

Q1: Authorization from Oracle Machine through Win Server? I suppose Oracle uses AAA to access DB and perform export operation, but which user accesses the directory DUMP_DIR? When I located it in CentOS it asked me for credentials (and I told it to remember), but I don't know if it stored them or if expdp uses them. (AAA is not a domain user)

Could it be this the problem or should I check something else?

Thank you, Marcello

Answer 1

Related to bug ticket 8313127 the DataPump does not support CIFS file system. Oracle recommends to use NFS file system instead.

Answer 2

I found the solution:

Create directory under /mnt/ in Linux using mkdir

cd /mnt

mkdir mydir

then mount it using mount

mount -t cifs -o username,password //servername/sharename /mnt/mydir/

where username and password is Windows-user able to access the share and //servername/sharename is the path of my share (servername = IP address if not able to resolve DNS)

Then create directory on Oracle DB

CREATE OR REPLACE DIRECTORY DUMP_DIR AS '/mnt/mydir'

expdp is correctly working

expdp AAA/***@xxx schemas=AAA include=TABLE:\"= \'TBL001\'\" directory=DUMP_DIR dumpfile=dmpfile.dmp logfile=lgfile.txt