Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the Oracle implementation expdp write NFS file system prompt ORA-39001 error", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "how to solve the Oracle implementation expdp write NFS file system prompt ORA-39001 error" bar!

1. Execute expdp command prompt ORA-27054 error

one

two

three

four

five

six

seven

eight

nine

ten

eleven

twelve

thirteen

fourteen

fifteen

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

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

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

two。 View alert log information

one

two

three

four

five

six

seven

eight

nine

ten

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 law 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. Find a solution on MOS

Use the "expdp ORA-27054" keyword to find the MOS document:

ORA-27054: NFS File System Where the File is Created or Resides is Not Mounted With Correct Options (document 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 00

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. Remount the NFS file

one

two

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. Result verification

one

two

three

four

five

six

seven

eight

nine

ten

eleven

twelve

thirteen

fourteen

fifteen

sixteen

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

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

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

Obviously, this problem is caused by the incorrect mount of the NFS file system. By adding key parameters and remounting the NFS system, the problem that Oracle executes expdp to write NFS file system prompts ORA-39001 ORA-39000 ORA-31641 ORA-27054 error is successfully solved.

Thank you for your reading, the above is "how to solve Oracle implementation expdp write NFS file system prompt ORA-39001 error" content, after the study of this article, I believe you on how to solve the problem of how to solve Oracle implementation expdp write NFS file system prompt ORA-39001 error have a deeper understanding, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.