Expdp Times ORA-31693 ORA-31617 ORA-195 error

Today, I made a mistake in the data Times and found an error indicating similar permissions, but I still reported an error all the time after modifying the permission. Some netizens also encountered the same error after searching for it.

However, it may be that only one node is enabled in my rac environment, which may be related to the cluster cluster.

At first, it was suspected that the physical directory permissions of dir_dp were not enough.

Granted 775 permissions.

But not yet.

The official document says

UsingPARALLEL During An Export In An Oracle RAC Environment

In an Oracle Real Application Clusters (Oracle RAC) environment, if an export operation has PARALLEL=1, then all Data Pump processes reside on the instance where the job isstarted. Therefore, the directory object can point to local storage for thatinstance.

If the export operation has PARALLEL set to a value greater than 1, then Data Pump processes can resideon instances other than the one where the job was started. Therefore, the directoryobject must point to shared storage that is accessible by all instances of theOracle RAC.

It seems that the directory of the exported file is not the reason why the two nodes are shared. / backup is only mounted on node 1, not on node 2. If / backup were shared between the two nodes, such an error would not occur. But now you can only operate on a single instance. Look at the help of expdp and find that there is a parameter cluster. This parameter controls whether to use multi-instance export. After setting up cluster=n, that is:

Expdp system/system directory=backup dumpfile=db_full.dump cluster=n logfile=db_full_20180307.log parallel=8

The export is normal after execution. There is no wrong report.