DataPump Export (EXPDP) Fails with Error ORA-27054 on HP 11.23
(Doc ID 785389.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database Exadata Cloud Machine - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
HP-UX Itanium
NOTE: In the testcase content below, the user information and metadata used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
Symptoms
DataPump export (expdp) fails on HP-UX 11.23 with errors:
#> expdp parfile=test.par
Export: Release 10.2.0.4.0 - 64bit Production on Monday, 19 January, 2009 15:20:39
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Username: system
Password:
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 "/fs_backup/export/test.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 4
Export: Release 10.2.0.4.0 - 64bit Production on Monday, 19 January, 2009 15:20:39
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Username: system
Password:
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 "/fs_backup/export/test.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 4
Changes
NFS mount option is set to:
"hard,bg,proto=tcp,noac,rsize=32768,wsize=32768,nointr,noac,forcedirectio,llock"
on node1 and node2 and expdp is run on both nodes.
The expdp executes normally on node2 but when expdp runs on node1 then it fails with ORA-27054.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |