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 126.96.36.199.0 - 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
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
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)
OR you use import dumpfile that was created with the original Export client (exp) you must have to use imp.
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.
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.