ORA-27054

 

ORA-27054

 

生产系统需要导出数据到一个NFS目录下报错：ORA-27054

 

bash-3.00$ expdp \'/ as sysdba\' directory=bak_data_pump_dir schemas=epm_ha dumpfile=epm_ha.dmp logfile=epm_ha.log

 

Export: Release 10.2.0.4.0 - 64bit Production on Friday, 21 May, 2010 16:09:25

 

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

 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.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 "/epmhis/DATA_PUMP_EPMHA1/epm_ha.dmp"

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

Additional information: 2

 

网上搜索资料，解决方法包括：

设置事件10298 level 32，alter system set event='10298 trace name context forever, level 32' scope = spfile;

打补丁：5146667，
在mount的时候设置参数：rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0。
在solaris系统上tcp参数不可用。

 

由于是生产系统，尽量采用不停数据库来解决，重新mount。

 

1 umount目录

umount /epmhis

 

2 mount目录加一些参数

mount -F nfs -o rw,hard,nointr,noac,vers=3,rsize=32768,wsize=32768 IP地址:/epmhis /20100521

 

3 重新expdp导出文件到NFS目录

Export: Release 10.2.0.4.0 - 64bit Production on Friday, 21 May, 2010 16:41:37

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

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

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

and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting "SYS"."SYS_EXPORT_SCHEMA_15":  '/******** AS SYSDBA' directory=bak_data_pump_dir schemas=epm_ha dumpfile=epm_ha.dmp logfile=epm_ha.log

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 355.2 GB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA_EXPORT/DB_LINK

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Master table "SYS"."SYS_EXPORT_SCHEMA_15" successfully loaded/unloaded

******************************************************************************

Dump file set for SYS.SYS_EXPORT_SCHEMA_15 is:

  /epmhis/DATA_PUMP_EPMHA1/epm_ha.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_15" successfully completed at 17:56:28

 

没有报错，问题解决。

 

-----------------------

在solaris系统上一些需要用到的命令：

 

--查看哪儿些用户正在访问目录

fuser -cu /epmhis

 

--查询nfs服务的状态

svcs nfs/server

STATE      STIME    FMRI

 

disabled   Aug_18   svc:/network/nfs/server:default

 

--启动和禁用nfs服务

svcadm enable/disable network/nfs/server

 

--设置server端nfs共享目录（重启系统也可生效）

vi /etc/dfs/dfstab

share -F nfs -o rw,anon=0 /epmhis

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13177610/viewspace-675077/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13177610/viewspace-675077/