SLTechnology News&Howtos › Database ›

How to deal with ORA-27054 problems in EXPDP

Shulou Source: shulou.com Published: 2022-06-01 08:57:39 11月15日 Update

Phenomenon:

[oracle@oracle1 ~] $expdp xian/xian schemas=xian directory=dumpdir dumpfile=xian.dmp LOGFILE=xian.log

Export: Release 10.2.0.5.0-64bit Production on Friday, 02 December, 2016 20:19:48

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production

With the Partitioning, Real Application Clusters, 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 "/ backup/xian.dmp"

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Additional information: 3

Additional information: 18

Reason:

No relevant parameters are added to the folder MOUNT NFS

Additional parameter is required: rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0

Solution: change it to the following

Mount-t nfs-o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0 10.71.13.109:/oracle/backup/ / backup