通过trace收集errorstack查看ora报错原因

落日映苍穹つ 2022-08-07 07:54 154阅读 0赞

<table style="font-family:''; word-wrap:break-word; word-break:break-all"> 
 <tbody> 
  <tr style="background-color:rgb(255,237,196)"> 
   <td style="font-size:9pt; border:1px solid rgb(255,219,141)"> 
    <div style="margin-top:5px; padding-left:20px; width:300px; overflow-x:hidden"> 
     <span style="color:rgb(0,110,254); background-color:rgb(255,255,255)">&nbsp;</span> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border:1px solid transparent"> 
    <div style="text-align:left; margin-top:5px; padding-left:20px; width:300px; overflow-x:hidden"> 
     <span style="font-family:微软雅黑,'MS Sans Serif',sans-serif"><span style="font-size:18px">比如当遇到ora01722报错的时候</span></span> 
    </div> <span style="font-size:18px"><span style="font-family:微软雅黑,'MS Sans Serif',sans-serif"></span></span> 
    <div style="text-align:left"> 
     <span style="font-size:18px"><br> </span> 
    </div> 
    <div style="text-align:left"> 
     <span style="font-size:18px">1，alter&nbsp;system&nbsp;set&nbsp;events='1722&nbsp;trace</span> 
    </div> 
    <div style="text-align:left; margin-top:5px; padding-left:20px; width:300px; overflow-x:hidden"> 
     <span style="font-family:微软雅黑,'MS Sans Serif',sans-serif"><span style="font-size:18px">name&nbsp;errorstack&nbsp;forever,&nbsp;level&nbsp;3';</span></span> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border:1px solid transparent"> 
    <div style="text-align:left; color:rgb(0,110,254); padding-left:10px"> 
     <span style="font-size:18px"><br> </span> 
    </div> 
    <div style="text-align:left; color:rgb(0,110,254); padding-left:10px"> 
     <span style="font-size:18px">2,重现错误</span> 
    </div> 
    <div style="text-align:left; color:rgb(0,110,254); padding-left:10px"> 
     <span style="font-size:18px"><br> </span> 
    </div> 
    <div style="margin-top:5px; padding-left:20px; width:300px; overflow-x:hidden"> 
     <div style="text-align:left"> 
      <span style="font-family:微软雅黑,'MS Sans Serif',sans-serif"><span style="font-size:18px">报错以后</span></span> 
     </div> 
     <span style="font-size:18px"><span style="font-family:微软雅黑,'MS Sans Serif',sans-serif"></span></span> 
     <div style="text-align:left"> 
      <span style="font-size:18px">3,alter&nbsp;system&nbsp;set&nbsp;events='1722&nbsp;trace&nbsp;name&nbsp;errorstack&nbsp;off';</span> 
     </div> 
    </div> 
    <div style="text-align:left; margin-top:5px; padding-left:20px; width:300px; overflow-x:hidden"> 
     <span style="font-family:微软雅黑,'MS Sans Serif',sans-serif"><span style="font-size:18px"><br> </span></span> 
    </div> 
    <div style="text-align:left; margin-top:5px; padding-left:20px; width:300px; overflow-x:hidden"> 
     <span style="font-size:18px">11g是在trace目录下查看最新的trc文件，就可以观察详细的报错原因了。</span> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>