DataPump Export/Import Hangs With "DEFINING" Status

刘泽宇

DataPump job hung forever with "DEFINING" status in dba_datapump_jobs:

SQL> SELECT owner_name, job_name, operation, job_mode, state, attached_sessions
FROM dba_datapump_jobs
WHERE job_name NOT LIKE 'BIN$%'
ORDER BY 1,2;
OWNER JOB_NAME OPERATION JOB_MODE STATE ATTACHED_SESSIONS
----- -------------------- ----------- -------- -------- -----------------
SYS SYS_EXPORT_SCHEMA_01 EXPORT SCHEMA DEFINING 1
SYS SYS_EXPORT_SCHEMA_03 EXPORT SCHEMA DEFINING 0

when the directory is located on a NFS location.


The following entries are found from the DM trace file:

...
KUPC: Setting remote flag for this process to FALSE
KUPP: Initialization complete for master process DM00
*** 2017-03-28 03:38:52.109
[2122856714591] kgnfs_processmsg: RPC FAIL msg rejected 1
[2122856714802] kgnfs_processmsg: AUTH ERROR 5
...



SOLUTION

This is not an issue of Datapump, but an issue with the filesystem where the Dumpfiles reside. As one can see from DM trace file, the underlying issue is coming back from kgnfs_processmsg.
The AUTH ERROR is clearly a server side configuration issue. Follow the outlined diagnostic collection steps for dnfs issues as outlined in Document 1464567.1 and contact your Storage admin/System Admin to check the filesystem.

To make DataPump job working until the filesystem problem is fixed, use any of the following workarounds:

1. Move the dumpfiles to a local filsystem.

or

2. Disable direct NFS.