expdp via Samba
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: expdp via Samba

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Angry expdp via Samba

    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.
    Best wishes!
    Dmitri

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    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 ...
    Best wishes!
    Dmitri

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Quote Originally Posted by PAVB View Post
    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.

    Quote Originally Posted by PAVB View Post
    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]$
    Best wishes!
    Dmitri

  6. #6
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  7. #7
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Quote Originally Posted by vnktummala View Post
    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
    Best wishes!
    Dmitri

  8. #8
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Quote Originally Posted by kgb View Post

    /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,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  9. #9
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    It is pointing from the local filesystem.
    And you ar enot wrong ... :-)
    Best wishes!
    Dmitri

  10. #10
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    I am suspecting mount options. could you please explore more on it?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width