小弟剛剛學Oracle，遇到這樣問題。
今天回公司，發現網站無法連接資料庫。
檢查下，發現Oracle已停了。
小弟使用以下指令來重新開啟
sqlplus /nolog
connect /as sysdba
SQL> startup
SQL> exit
LSNRCTL> start
開啟了Oracle。
不過小弟想檢查下日志，看看Oracle為何停了。是有人把它停了或受到什么影響。。。
請問各位前輩小弟該如何詢查。（小弟是新手，很多還不懂）
謝謝。
uj5u.com熱心網友回復：
請各位前輩賜教。。。！uj5u.com熱心網友回復：
自己頂一下。。。！很急，請各位前輩賜教幫忙。。。！
uj5u.com熱心網友回復：
把alert 的后50行發上來看看。uj5u.com熱心網友回復：
<msg time='2017-03-17T16:28:39.352+07:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DB01'
host_addr='127.0.0.1'>
<txt>17-MAR-2017 16:28:39 * 12502
</txt>
</msg>
<msg time='2017-03-17T16:28:39.352+07:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DB01'
host_addr='127.0.0.1'>
<txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
</txt>
</msg>
<msg time='2017-03-17T16:31:39.351+07:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DB01'
host_addr='127.0.0.1'>
<txt>17-MAR-2017 16:31:39 * 12502
</txt>
</msg>
<msg time='2017-03-17T16:31:39.351+07:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DB01'
host_addr='127.0.0.1'>
<txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
</txt>
</msg>
<msg time='2017-03-17T16:34:39.372+07:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DB01'
host_addr='127.0.0.1'>
<txt>17-MAR-2017 16:34:39 * 12502
</txt>
</msg>
<msg time='2017-03-17T16:34:39.372+07:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DB01'
host_addr='127.0.0.1'>
<txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
</txt>
</msg>
<msg time='2017-03-17T16:37:39.372+07:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DB01'
host_addr='127.0.0.1'>
<txt>17-MAR-2017 16:37:39 * 12502
</txt>
</msg>
<msg time='2017-03-17T16:37:39.372+07:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DB01'
host_addr='127.0.0.1'>
<txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
</txt>
</msg>
<msg time='2017-03-17T16:40:39.378+07:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DB01'
host_addr='127.0.0.1'>
<txt>17-MAR-2017 16:40:39 * 12502
</txt>
</msg>
<msg time='2017-03-17T16:40:39.378+07:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DB01'
host_addr='127.0.0.1'>
<txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
</txt>
</msg>
這是alert Log
請前輩幫幫忙
uj5u.com熱心網友回復：
TNS-12502 錯誤一般是由客戶端tnsnames.ora中沒有包含CONNECT_DATA導致。檢查你的tnsnames.ora 檔案轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/92124.html
標籤：基礎和管理
上一篇：="'"&A1&"'"