设为首页收藏本站
开启辅助访问 切换到窄版
搜索
第一问答网»论坛 › 中问网 › 问答 › 如何分析监听日志有问题，具体有啥思路，谢谢！ ...

如何分析监听日志有问题，具体有啥思路，谢谢！

[复制链接]
查看11 | 回复3 | 2007-5-10 01:02:02 | 显示全部楼层 |阅读模式
我们数据库前台经常断开连接，分析监听日志，不知道该如何看问题。
比如如下一小段，可以说明有啥问题吗

08-NOV-2011 10:44:24 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=timefist)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43450)) * establish * CODE * 0
08-NOV-2011 10:44:25 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=timefist)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43457)) * establish * CODE * 0
08-NOV-2011 10:44:26 * service_update * CODE1 * 0
08-NOV-2011 10:44:32 * service_update * CODE1 * 0
08-NOV-2011 10:44:34 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=audit)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43513)) * establish * CODE * 0
08-NOV-2011 10:44:48 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=audit)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43523)) * establish * CODE * 0
08-NOV-2011 10:44:58 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=audit)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43530)) * establish * CODE * 0
08-NOV-2011 10:44:59 * service_update * CODE1 * 0
08-NOV-2011 10:45:00 * service_register * CODE2 * 1184
TNS-01184: Listener rejected registration or update of service handler "DEDICATED"
TNS-01185: Registration attempted from a remote node
08-NOV-2011 10:45:00 * service_died * CODE2 * 12537
08-NOV-2011 10:45:09 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=audit)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43531)) * establish * CODE * 0
08-NOV-2011 10:45:19 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=audit)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43536)) * establish * CODE * 0
08-NOV-2011 10:45:22 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=fist@CODE-ht)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43541)) * establish * CODE * 0
08-NOV-2011 10:45:22 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=timefist)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43542)) * establish * CODE * 0
08-NOV-2011 10:45:30 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=audit)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43550)) * establish * CODE * 0
08-NOV-2011 10:45:40 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=audit)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43551)) * establish * CODE * 0
08-NOV-2011 10:45:50 * (CONNECT_DATA=(SERVICE_NAME=CODE)(SERVER=DEDICATED)(CID=(PROGRAM=audit)(HOST=CODE-ht)(USER=iteruser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.116.91.932)(PORT=43555)) * establish * CODE * 0
08-NOV-2011 10:45:59 * service_update * CODE1 * 0
08-NOV-2011 10:46:00 * service_register * CODE2 * 1184
TNS-01184: Listener rejected registration or update of service handler "DEDICATED"
TNS-01185: Registration attempted from a remote node
08-NOV-2011 10:46:00 * service_died * CODE2 * 12537

回复

使用道具 举报

千问 | 2007-5-10 01:02:02 | 显示全部楼层
还有，应用半天时间，写这个监听日志就写了2万行记录，算多吗？
两个节点就是4万条了。
回复

使用道具 举报

千问 | 2007-5-10 01:02:02 | 显示全部楼层
UP
回复

使用道具 举报

千问 | 2007-5-10 01:02:02 | 显示全部楼层
你给出来的时间段的日志，还是比较空闲的
应该没有多大问题，取决于你的应用访问数据库是否频繁
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

千问

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
回复楼主 返回列表
热门排行