Oracle Impdp Failed on RAC with ORA-31640, ORA-19505, ORA-27037, Linux-x86_64 Error: 2: No such file

╰半夏微凉° 2022-08-10 17:40 17阅读 0赞

在rac环境执行impdp并行导入报错：

<table> 
 <tbody> 
  <tr> 
   <td align="left"><span style="font-size:14px; text-align:right; padding:0px 6px 0px 0px; font-weight:bold"><br> Oracle Impdp Failed on RAC with ORA-31640, ORA-19505, ORA-27037, Linux-x86_64 Error: 2: No such file or directory (文档 ID 1467232.1)</span></td> 
   <td align="right">&nbsp;</td> 
   <td><img src="https://support.oracle.com/epmos/adf/images/t.gif" alt="" width="20" height="10"></td> 
  </tr> 
 </tbody> 
</table>

<table style="table-layout:fixed; overflow:hidden"> 
 <tbody> 
  <tr> 
   <td style="overflow:hidden"><span style="font-size:12px"></span> <p><strong>In this Document</strong><br> </p> 
    <table> 
     <tbody> 
      <tr> 
       <td></td> 
       <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=2ew8zjrvy_4&amp;_afrLoop=1038719469245300#SYMPTOM" rel="nofollow">Symptoms</a></td> 
      </tr> 
     </tbody> 
    </table> 
    <table> 
     <tbody> 
      <tr> 
       <td>&nbsp;</td> 
       <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=2ew8zjrvy_4&amp;_afrLoop=1038719469245300#CAUSE" rel="nofollow">Cause</a></td> 
      </tr> 
     </tbody> 
    </table> 
    <table> 
     <tbody> 
      <tr> 
       <td>&nbsp;</td> 
       <td><a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=2ew8zjrvy_4&amp;_afrLoop=1038719469245300#FIX" rel="nofollow">Solution</a></td> 
      </tr> 
     </tbody> 
    </table> 
    <hr> <p><br> </p> 
    <table> 
     <tbody> 
      <tr> 
       <td><em>This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.<em></em></em></td> 
      </tr> 
     </tbody> 
    </table> <h2 style="border-bottom-width:1px; border-bottom-style:solid; border-bottom-color:rgb(196,209,230); font-size:16px; background-color:rgb(119,119,115); color:rgb(255,255,255); text-transform:uppercase; padding-top:6px; padding-bottom:6px; padding-left:8px"> APPLIES TO:</h2> Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.1 [Release 11.2 to 12.1]<br> Information in this document applies to any platform.<br> ***Checked for relevance on 13-Nov-2013** <h2 style="border-bottom-width:1px; border-bottom-style:solid; border-bottom-color:rgb(196,209,230); font-size:16px; background-color:rgb(119,119,115); color:rgb(255,255,255); text-transform:uppercase; padding-top:6px; padding-bottom:6px; padding-left:8px"> <a rel="nofollow"></a>SYMPTOMS</h2> <p>We did expdp on AIX server with mutliple files using filesetsize=10G parameter and when we are importing into LInux database we are facing below errors:<br> <br> ORA-31693: Table data object "DBO_ACTIONAL_PROD"."ACT_SUBN_STATS_H_" failed to load/unload and is being skipped due to error:<br> ORA-31640: unable to open dump file "/u01/app/oracle/export/utl01p/act04.dmp" for read<br> ORA-19505: failed to identify file "/u01/app/oracle/export/utl01p/act04.dmp"<br> ORA-27037: unable to obtain file status<br> Linux-x86_64 Error: 2: No such file or directory<br> Additional information: 3<br> </p> <h2 style="border-bottom-width:1px; border-bottom-style:solid; border-bottom-color:rgb(196,209,230); font-size:16px; background-color:rgb(119,119,115); color:rgb(255,255,255); text-transform:uppercase; padding-top:6px; padding-bottom:6px; padding-left:8px"> <a rel="nofollow"></a>CAUSE</h2> <p><br> When you are using a cluster database it is possible for datapump workers to start on any of the available nodes unless you specify cluster=N. If the nodes that start the workers do not have access to the datapump directory they will be unable to process the files. This is proved out when you specify cluster=N to remove the other nodes from the equation.<br> &nbsp;</p> <h2 style="border-bottom-width:1px; border-bottom-style:solid; border-bottom-color:rgb(196,209,230); font-size:16px; background-color:rgb(119,119,115); color:rgb(255,255,255); text-transform:uppercase; padding-top:6px; padding-bottom:6px; padding-left:8px"> <a rel="nofollow"></a>SOLUTION</h2> <p>Use cluster=N to run the import from a single node of the RAC cluster which has file access.<br> &nbsp;</p> </td> 
  </tr> 
 </tbody> 
</table>