oracle挂载目录下,Oracle数据库使用nfs挂载的盘执行expdp说明（Linux环境下）

一、使用如下目录挂载NFS网络磁盘

# mount -t nfs -o rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,proto=tcp,nolock 10.10.10.10:/orabak/ /exp20151202/

二、执行expdp时出现如下报错的解决办法

[oracle@rac1 ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

[oracle@rac1 ~]$ expdp system/oracle  directory=expdp20151202 dumpfile=expdp20151202.dmp logfile=expdp20151202.log  full=y

Export: Release 10.2.0.3.0 - 64bit Production on Thursday, 03 December, 2015 14:09:55

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

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

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31641: unable to create dump file "/exp20151202/expdp20151202.dmp"

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

Additional information: 3

解决办法：

SQL> alter system set events '10298 trace name context forever,level 32';

System altered.

[oracle@rac1 expdp20151214]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

[oracle@rac1 expdp20151214]$ expdp system/oracle dumpfile=full%U directory=dir_151214 full=y parallel=4 logfile=expdp20151214.log

10.2.0.3.0 - 64bit Production on Monday, 14 December, 2015 9:00:41

(c) 2003, 2005, Oracle.  All rights reserved.

: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

FLASHBACK automatically enabled to preserve database integrity.

Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/******** dumpfile=full%U directory=dir_151214 full=y parallel=4 logfile=expdp20151214.log

Estimate in progress using BLOCKS method...

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

....

至此，即可正常导出数据。