scan listener issue

lypflash

感觉scan listener重新reboot了，数据库中没有啥问题。
不知道到底是啥问题造成的？

找不到以下文件：
D:\app\11.2.0\grid\log\diag\tnslsnr\era-mesdb01\listener\trace\ora_4136_716.trc"

日志错误记录：
03-4月 -2012 00:24:09 * (CONNECT_DATA=(SID=mesdb1)(CID=(PROGRAM=D:\app\administrator\product\11.2.0\dbhome_1\perl\bin\perl.exe)(HOST=ERA-MESDB01)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.74.1.65)(PORT=60930)) * establish * mesdb1 * 0
03-4月 -2012 00:24:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
Tue Apr 03 00:24:56 2012
03-4月 -2012 00:24:56 * (CONNECT_DATA=(SID=mesdb1)(CID=(PROGRAM=D:\app\administrator\product\11.2.0\dbhome_1\perl\bin\perl.exe)(HOST=ERA-MESDB01)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.74.1.65)(PORT=60934)) * establish * mesdb1 * 0
03-4月 -2012 00:25:00 * ping * 0
03-4月 -2012 00:25:00 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
Tue Apr 03 00:25:09 2012
03-4月 -2012 00:25:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
不再監聽器於: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.74.1.60)(PORT=1521)))
03-4月 -2012 00:25:09 * service_died * LsnrAgt * 12537
不再監聽器於: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.74.1.65)(PORT=1521)))
系統參數檔案是 D:\app\11.2.0\grid\network\admin\listener.ora
追蹤資訊被寫入到 D:\app\11.2.0\grid\log\diag\tnslsnr\era-mesdb01\listener\trace\ora_4136_716.trc
追蹤層次目前是 0
日誌訊息寫入 D:\app\11.2.0\grid\log\diag\tnslsnr\era-mesdb01\listener\alert\log.xml
03-4月 -2012 00:25:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * reload * 0
03-4月 -2012 00:25:11 * version * 0
監聽之處: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.74.1.60)(PORT=1521)))
監聽之處: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.74.1.65)(PORT=1521)))
03-4月 -2012 00:25:11 * service_register * LsnrAgt * 0
03-4月 -2012 00:25:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
Tue Apr 03 00:25:32 2012
03-4月 -2012 00:25:32 * (CONNECT_DATA=(SID=mesdb1)(CID=(PROGRAM=D:\app\administrator\product\11.2.0\dbhome_1\perl\bin\perl.exe)(HOST=ERA-MESDB01)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.74.1.65)(PORT=61088)) * establish * mesdb1 * 12505
TNS-12505: TNS: 監聽器目前不知道連線描述區中指定的 SID
Tue Apr 03 00:26:09 2012
03-4月 -2012 00:26:09 * service_register * mesdb1 * 0
03-4月 -2012 00:26:12 * service_update * mesdb1 * 0
03-4月 -2012 00:26:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
Tue Apr 03 00:27:15 2012
03-4月 -2012 00:27:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
Tue Apr 03 00:28:15 2012

Maclean Liu(刘相兵

action plan:

上传完整的

listener.log
listener.ora


使用  diagcollection.pl  脚本收集其他日志 并压缩打包上传