6 Replies Latest reply on Oct 12, 2012 7:44 PM by Dean Gagne-Oracle

    EXPDPD error

      Dear all

      We have rac environment.
      We have mounted the disk to linux folder for dump
      and I have try to take EXPDP , creating directory for mounted path but its getting following error

      expdp batch_user/iims schemas=BATCH_USER directory=DATAPUMP_T dumpfile=batch_user.dmp logfile=batch_user.log

      Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
      Data Mining and Real Application Testing options
      ORA-39001: invalid argument value
      ORA-39000: bad dump file specification
      ORA-31641: unable to create dump file "/u02/exports/dumps/dumps/batch_user.dmp"
      ORA-27041: unable to open file

      But it's working other server disk its working well ,
      why getting this error
        • 1. Re: EXPDPD error
          Sunny kichloo
          Is your batch_user has permission on directory DATAPUMP_T and if not Please grant it by below mentioned command

          SQL>grant read,write on directory DATAPUMP_T to batch_user;

          And also what is the permission assign to directory DATAPUMP_T in OS level
          • 2. Re: EXPDPD error
            Already granted
            • 3. Re: EXPDPD error
              Sunny kichloo
              permission assign to directory DATAPUMP_T in OS level
              • 4. Re: EXPDPD error
                This error could occur for more than one reason :
                1- is the directory located on server (must be created)
                2-did you transfer the dmp to server via ftp (must be binary mode)
                3-Check permission


                you use  import dumpfile that was created with the original Export client (exp) you must have to use imp.
                • 5. Re: EXPDPD error
                  Peter Häusler
                  in case this is a RAC and you are importing or exporting a file you should set the Parameter cluster to N.
                  Otherwise the system will try to use all your RAC nodes for import or export and you get this error because one of the nodes did not find the directory.

                  Utilize cluster resources and distribute workers across the Oracle RAC.
                  Valid keyword values are: [Y] and N.

                  • 6. Re: EXPDPD error
                    Dean Gagne-Oracle
                    Just make sure that each node in the rack has the directory object defined. You could have it defined on node a and one of the Data Pump processes could be started on node b. If node b does not have the directory object defined, then you could get this error. You do not have to set cluster=n. It may fix the problem because all of the processes will be started on the same node, but defining the directory object and making sure each node has access to the disk should solve the problem.

                    1 person found this helpful