如何進(jìn)行Oracle監(jiān)聽器日志的解析，針對(duì)這個(gè)問題，這篇文章詳細(xì)介紹了相對(duì)應(yīng)的分析和解答，希望可以幫助更多想解決這個(gè)問題的小伙伴找到更簡單易行的方法。

創(chuàng)新互聯(lián)建站服務(wù)項(xiàng)目包括垣曲網(wǎng)站建設(shè)、垣曲網(wǎng)站制作、垣曲網(wǎng)頁制作以及垣曲網(wǎng)絡(luò)營銷策劃等。多年來，我們專注于互聯(lián)網(wǎng)行業(yè)，利用自身積累的技術(shù)優(yōu)勢、行業(yè)經(jīng)驗(yàn)、深度合作伙伴關(guān)系等，向廣大中小型企業(yè)、政府機(jī)構(gòu)等提供互聯(lián)網(wǎng)行業(yè)的解決方案，垣曲網(wǎng)站推廣取得了明顯的社會(huì)效益與經(jīng)濟(jì)效益。目前，我們服務(wù)的客戶以成都為中心已經(jīng)輻射到垣曲省份的部分城市，未來相信會(huì)繼續(xù)擴(kuò)大服務(wù)區(qū)域并繼續(xù)獲得客戶的支持與信任！

/////////////////////////////////////////////////////
監(jiān)聽start后監(jiān)聽日志記錄信息如下:
Tue Feb 06 13:03:06 2018
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/wang/listener/alert/log.xml
Trace information written to /u01/app/oracle/diag/tnslsnr/wang/listener/trace/ora_5682_140618561201984.trc
Trace level is currently 0

Started with pid=5682
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wang)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
06-FEB-2018 13:03:06 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=wang)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0

Tue Feb 06 13:03:48 2018
06-FEB-2018 13:03:48 * service_register * DBdb * 0
 Tue Feb 06 13:04:36 2018
06-FEB-2018 13:04:36 * service_update * DBdb * 0
 Tue Feb 06 13:05:45 2018
06-FEB-2018 13:05:45 * service_update * DBdb * 0
Tue Feb 06 13:06:15 2018
06-FEB-2018 13:06:15 * service_update * DBdb * 0
       Tue Feb 06 13:13:13 2018
06-FEB-2018 13:13:13 * service_update * DBdb * 0
      Tue Feb 06 13:19:48 2018
WARNING: Subscription for node down event still pending
06-FEB-2018 13:19:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=wang)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
    Tue Feb 06 13:23:13 2018
06-FEB-2018 13:23:13 * service_update * DBdb * 0

//////////////////////////////////////////////////////////
通過plsql建立連接：如下是日志信息：
Tue Feb 06 13:23:41 2018
06-FEB-2018 13:23:41 * (CONNECT_DATA=(SERVICE_NAME=DBdb)(CID=(PROGRAM=E:\????\PLSQL_Developer8.0??????\plsqldev.exe)(HOST=SC-201707102126)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.1)(PORT=53088)) * establish * DBdb * 0
06-FEB-2018 13:23:41 * (CONNECT_DATA=(SERVICE_NAME=DBdb)(CID=(PROGRAM=E:\????\PLSQL_Developer8.0??????\plsqldev.exe)(HOST=SC-201707102126)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.1)(PORT=53089)) * establish * DBdb * 0
06-FEB-2018 13:23:43 * service_update * DBdb * 0
06-FEB-2018 13:23:46 * service_update * DBdb * 0


///////////////////////////////////////////////////
客戶端tns信息
DBDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.12)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DBdb)
    )
  )

關(guān)于如何進(jìn)行Oracle監(jiān)聽器日志的解析問題的解答就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，如果你還有很多疑惑沒有解開，可以關(guān)注創(chuàng)新互聯(lián)-成都網(wǎng)站建設(shè)公司行業(yè)資訊頻道了解更多相關(guān)知識(shí)。

名稱欄目：如何進(jìn)行Oracle監(jiān)聽器日志的解析-創(chuàng)新互聯(lián)
轉(zhuǎn)載來源：http://weahome.cn/article/dciecj.html