温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

如何进行Oracle监听器日志的解析

发布时间:2021-11-30 10:06:02 来源:亿速云 阅读:209 作者:柒染 栏目:关系型数据库

如何进行Oracle监听器日志的解析,针对这个问题,这篇文章详细介绍了相对应的分析和解答,希望可以帮助更多想解决这个问题的小伙伴找到更简单易行的方法。

/////////////////////////////////////////////////////
监听start后监听日志记录信息如下:
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)
    )
  )

关于如何进行Oracle监听器日志的解析问题的解答就分享到这里了,希望以上内容可以对大家有一定的帮助,如果你还有很多疑惑没有解开,可以关注亿速云行业资讯频道了解更多相关知识。

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI