expdp via Samba

[kgb]

Hi, I am trying to put dump file created by expdp to windows share, but keep getting error:


[root@oraracdub2 /]# cat /mnt/oradub1/datapump/fo61.log
;;;
Export: Release 10.2.0.3.0 - Production on Friday, 11 March, 2011 12:32:05

Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
Data Mining and Real Application Testing options
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/mnt/oradub1/datapump/fo61.dmp"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 2


All files in the share have this permition, I can create delete any files from linux box, even Data Pump itself create a log file with errors

[root@oraracdub2 /]# ls -lat /mnt/oradub1/datapump/
total 69834081
-rw-rw---- 1 root root 570 Mar 11 12:32 fo61.log
drwxrwxrwx 1 root root 0 Mar 11 12:32 .
-rwxrwSrwt 1 root root 397 Mar 11 11:10 fo61_1.log
-rwxrwSrwt 1 root root 61050 Mar 11 11:00 fo530.log
-rwxrwSrwt 1 root root 227078144 Mar 11 11:00 FO530.DMP
drwxrwxrwx 1 root root 0 Mar 10 18:08 ..
-rwxrwSrwt 1 root root 79905 Feb 28 19:15 ALETTI_170910i.log
-rwxrwSrwt 1 root root 78190 Feb 28 16:24 ALETTI_170910.log
-rwxrwSrwt 1 root root 9933185812 Feb 28 16:24 ALETTI_170910.DMP.gz

I granted ALL on this directory to public.


I will appreciate it very much if you could advice what is missing here.

[vnktummala]

fo61.dmp is not there in the specified path.

[root@oraracdub2 /]# ls -lat /mnt/oradub1/datapump/
total 69834081
-rw-rw---- 1 root root 570 Mar 11 12:32 fo61.log
drwxrwxrwx 1 root root 0 Mar 11 12:32 .
-rwxrwSrwt 1 root root 397 Mar 11 11:10 fo61_1.log
-rwxrwSrwt 1 root root 61050 Mar 11 11:00 fo530.log
-rwxrwSrwt 1 root root 227078144 Mar 11 11:00 FO530.DMP
drwxrwxrwx 1 root root 0 Mar 10 18:08 ..
-rwxrwSrwt 1 root root 79905 Feb 28 19:15 ALETTI_170910i.log
-rwxrwSrwt 1 root root 78190 Feb 28 16:24 ALETTI_170910.log
-rwxrwSrwt 1 root root 9933185812 Feb 28 16:24 ALETTI_170910.DMP.gz

Thanks,

[kgb]

yes, it is not there .... this is what error say:

unable to create dump file "/mnt/oradub1/datapump/fo61.dmp"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied

In the same time it creates log file ...

[PAVB]

Everything on that directory appears to be owned by "root"

Couple of questions...

Have you granted full privs to public on Oracle directory pointing to /mnt/oradub1/datapump? I mean, Oracle privs?

Which account was used to install Oracle? was it "oracle"? What happens if you log into the system using that account and try to create a simple text file under /mnt/oradub1/datapump?

[kgb]

Have you granted full privs to public on Oracle directory pointing to /mnt/oradub1/datapump? I mean, Oracle privs?

Yes,

[root@oraracdub2 oradub1]# cd /
[root@oraracdub2 /]# ls -lat
drwxrwxrwx 4 root root 4096 Mar 11 12:01 mnt
[root@oraracdub2 /]# ls -lat /mnt
total 20
drwxrwxrwx 1 root root 0 Mar 14 09:21 oradub1
[root@oraracdub2 /]# ls -lat /mnt/oradub1/
drwxrwxrwx 1 root root 0 Mar 11 12:32 datapump
Oracle can create a log file and write into it, but not a dump file ... this is very strange ... in case of permissions I would expect the same behaviour for a log file.

Which account was used to install Oracle? was it "oracle"? What happens if you log into the system using that account and try to create a simple text file under /mnt/oradub1/datapump?

It was user oracle. user oracle can create a file, see bellow:

[root@oraracdub2 /]# su - oracle
[oracle@oraracdub2 ~]$ cd /mnt/oradub1/datapump/
[oracle@oraracdub2 datapump]$ mkdir test
[oracle@oraracdub2 datapump]$ echo test > test/test.txt
[oracle@oraracdub2 datapump]$ cat test/test.txt
test
[oracle@oraracdub2 datapump]$ rm -rf test
[oracle@oraracdub2 datapump]$

[vnktummala]

Is the "oracle" user password is same in DB server as well as in Samba server? If not, please set the password same in both the places and try.

Thanks,

[kgb]

Is the "oracle" user password is same in DB server as well as in Samba server? If not, please set the password same in both the places and try.

Hi,

/mnt/oradub1/
is mounted to
//oradub1/dump1 1756490840 1338513568 417977272 77% /mnt/oradub1

fstab looks like this:
//oradub1/dump1 /mnt/oradub1 cifs umask=777,mask=777,uid=oracle,username=oracle,password=ora12345 0 0

So, there is no Samba server here were I could specify the password

[vnktummala]

/mnt/oradub1/
is mounted to
//oradub1/dump1 1756490840 1338513568 417977272 77% /mnt/oradub1

fstab looks like this:
//oradub1/dump1 /mnt/oradub1 cifs umask=777,mask=777,uid=oracle,username=oracle,password=ora12345 0 0

So, there is no Samba server here were I could specify the password

from where /mnt/oradub1 pointing? Is it from SAN or JBOD or ???

as par my understanding, DB server is on UNIX and you are mount one file system from windows machine to use to store expdp dump files. Please correct me if I am wrong.

Thanks,

[kgb]

It is pointing from the local filesystem.
And you ar enot wrong ... :-)

[vnktummala]

I am suspecting mount options. could you please explore more on it?

Thanks,