you are using Oracle Direct NFS, and the NFS is running on Windows, there is a potential issue with permissions and ownership changes required.<\/p>\n
An example of issues with Oracle Direct NFS using datapump with the DATA_PUMP_DIR located on an NFS share server by NFS on Windows:<\/p>\n
Estimate in progress using BLOCKS method...\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\r\nTotal estimation using BLOCKS method: 2.625 MB\r\nProcessing object type SCHEMA_EXPORT\/USER\r\nORA-39126: Worker unexpected fatal error in KUPW$WORKER.CREATE_OBJECT_ROWS [USER:\"XYZ\"]\r\nORA-19505: failed to identify file \"\/u01\/ORCL\/ORCL_testexp.dp\"\r\nORA-17503: ksfdopn:4 Failed to open file \/u01\/ORCL\/ORCL_testexp.dp\r\nORA-17500: ODM err:File does not exist\r\nORA-06512: at \"SYS.DBMS_SYS_ERROR\", line 95\r\nORA-06512: at \"SYS.KUPW$WORKER\", line 11014\r\n----- PL\/SQL Call Stack -----\r\n object line object\r\n handle number name<\/pre>\nRelevant MOS Documents<\/h2>\n
RMAN Backup Fail to NFS Shares From a Windows Server When DNFS is Enabled (Doc ID 2171297.1)
\nDatapump Dump File Permission In DNFS Environment (Doc ID 2049012.1)<\/p>\nSolution<\/h2>\n
Change the value of the following registry key (on the Windows Server providing NFS) to 0 and restart Server for NFS:<\/p>\n
HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\ServerForNfs\\CurrentVersion\\Exports\\0\\RestrictChown = 0 (DWORD)<\/p>\n
Workaround<\/h2>\n
You could also disable Direct NFS:
\nset ORACLE environment.
\ncd $ORACLE_HOME\/rdbms\/lib\/
\nmake -f ins_rdbms.mk dnfs_off<\/p>\n— restart the instance<\/p>\n","protected":false},"excerpt":{"rendered":"
Scenario : Oracle Direct NFS, NFS on Windows Server you are using Oracle Direct NFS, and the NFS is running on Windows, there is a potential issue with permissions and ownership changes required. Example An example of issues with Oracle … Continue reading