怎么解決Oracle執行expdp寫入NFS文件系統提示ORA

149次閱讀

共計 4236 個字符，預計需要花費 11 分鐘才能閱讀完成。

這篇文章主要講解了“怎么解決 Oracle 執行 expdp 寫入 NFS 文件系統提示 ORA-39001 錯誤”，文中的講解內容簡單清晰，易于學習與理解，下面請大家跟著丸趣 TV 小編的思路慢慢深入，一起來研究和學習“怎么解決 Oracle 執行 expdp 寫入 NFS 文件系統提示 ORA-39001 錯誤”吧！

1. 執行 expdp 命令提示 ORA-27054 錯誤

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

oracle@cwgsdb1:~$ expdp \ / as sysdba\ directory=dir_dp schemas=hr dumpfile=hr.dmp logfile=hr.log parallel=2

Export: Release 11.2.0.4.0 – Production on Thu Oct 25 16:55:06 2018

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, 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 /backup/hr.dmp

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

Additional information: 3

Additional information: 18

2. 查看 alert 日志信息

1

2

3

4

5

6

7

8

9

10

Thu Oct 25 16:55:08 2018

ALTER SYSTEM SET service_names= SYS$SYS.KUPC$C_1_20181025165507.CAMS SCOPE=MEMORY SID= cams1 ;

ALTER SYSTEM SET service_names= SYS$SYS.KUPC$C_1_20181025165507.CAMS , SYS$SYS.KUPC$S_1_20181025165507.CAMS SCOPE=MEMORY SID= cams1 ;

Thu Oct 25 16:55:08 2018

DM00 started with pid=55, OS id=17279, job SYS.SYS_EXPORT_SCHEMA_01

WARNING:NFS mount of file /backup/hr.dmp on filesystem /backup done with incorrect options:rw,xattr,dev=9640001

WARNING:Expected NFS mount options: rsize =32768,wsize =32768,hard,

Thu Oct 25 16:55:10 2018

ALTER SYSTEM SET service_names= SYS$SYS.KUPC$S_1_20181025165507.CAMS SCOPE=MEMORY SID= cams1 ;

ALTER SYSTEM SET service_names= cams SCOPE=MEMORY SID= cams1 ;

3. 在 MOS 上查找解決方案

使用“expdp ORA-27054”關鍵字查找，找到 MOS 文檔：

ORA-27054: NFS File System Where the File is Created or Resides is Not Mounted With Correct Options (文檔 ID 781349.1)

SYMPTOMS

You are transferring your database/installation to a NetApps NFS mount point.

The following error occurs on database startup:

ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file /nfs_d04/oasisxx/data/oasis_system.dbf
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

The current mount point is mounted as:

rw,bg,rsize=32768,wsize=32768,hard,vers=3,nointr,timeo=600,proto=tcp,suid 0 0

CAUSE

The correct mount point options are being used but they are not in the correct order per oracle docs on correctly mounting NFS mounts for oracle software.

The correct setting should be:

rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,proto=tcp,suid

NOTE: the location of the parameter hard

NOTE: As per
Bug 11812928
, the intr nointr are deprecated in UEK kernels, as well as Oracle Linux 6. It is harmless to still include it, you will get a notice..

NFS: ignoring mount option: nointr.

SOLUTION

Mount the NFS mount point with the recommended options in the exact order specified in oracle documentation.

For example:
# mount -F nfs -o rw,bg,hard,rsize=32768,wsize=32768,vers=3,forcedirectio,nointr,proto=tcp,suid host:/folder1/to1 /folder2/to2

NOTE: if settings revert back to original settings after remount, check auto-mounter options/settings. For more info on auto-mounter, please contact the OS vendor.

4. 重新掛載 NFS 文件

1

2

root@cwgsdb1:~# umount /backup

root@cwgsdb1:~# mount -F nfs -o rw,bg,hard,rsize=32768,wsize=32768,vers=3 100.100.100.54:/impbackup /backup

5. 結果驗證

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

oracle@cwgsdb1:/backup$ expdp directory=dir_dp schemas=hr dumpfile=hr.dmp logfile=hr.log parallel=2

Export: Release 11.2.0.4.0 – Production on Thu Oct 25 17:14:26 2018

Username: system

Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

Starting SYSTEM . SYS_EXPORT_SCHEMA_01 : system/******** directory=dir_dp schemas=hr dumpfile=hr.dmp logfile=hr.log parallel=2

Estimate in progress using BLOCKS method…

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 448 KB

顯然該問題是由 NFS 文件系統未正確掛載引起的，通過添加關鍵參數，重新掛載 NFS 系統，順利解決 Oracle 執行 expdp 寫入 NFS 文件系統提示 ORA-39001 ORA-39000 ORA-31641 ORA-27054 錯誤的問題。

感謝各位的閱讀，以上就是“怎么解決 Oracle 執行 expdp 寫入 NFS 文件系統提示 ORA-39001 錯誤”的內容了，經過本文的學習后，相信大家對怎么解決 Oracle 執行 expdp 寫入 NFS 文件系統提示 ORA-39001 錯誤這一問題有了更深刻的體會，具體使用情況還需要大家實踐驗證。這里是丸趣 TV，丸趣 TV 小編將為大家推送更多相關知識點的文章，歡迎關注！

正文完