免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 数据库技术 › Oracle › 求:如何跟踪连接listener的用户进程号
最近访问板块 发新帖
查看: 2957 | 回复: 4
打印 上一主题 下一主题

求:如何跟踪连接listener的用户进程号 [复制链接]

yxh_chinaunix

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2006-11-06 20:11 |只看该作者 |倒序浏览
我的oracle是8.1.7.4版本,操作系统是sco unix ware7.1.3
通过跟踪listener.log日志发现有应用每隔几秒就连接listener,但是通过日志又无法发现是哪个进程,请大虾指点,如何跟踪.
listener.log片段如下:
06-NOV-2005 20:04:50 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=38134)) * establish * dbcult1 * 0
06-NOV-2005 20:04:54 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=3813) * establish * dbcult1 * 0
06-NOV-2005 20:04:58 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=38140)) * establish * dbcult1 * 0
06-NOV-2005 20:05:00 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=38142)) * establish * dbcult1 * 0
06-NOV-2005 20:05:04 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=38146)) * establish * dbcult1 * 0
06-NOV-2005 20:05:08 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=3814) * establish * dbcult1 * 0
06-NOV-2005 20:05:10 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=38150)) * establish * dbcult1 * 0
06-NOV-2005 20:05:14 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=38154)) * establish * dbcult1 * 0
06-NOV-2005 20:05:18 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=38156)) * establish * dbcult1 * 0
06-NOV-2005 20:05:20 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=3815) * establish * dbcult1 * 0
06-NOV-2005 20:05:20 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=38160)) * establish * dbcult1 * 0
06-NOV-2005 20:05:24 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=38164)) * establish * dbcult1 * 0
06-NOV-2005 20:05:28 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=38166)) * establish * dbcult1 * 0
06-NOV-2005 20:05:30 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=3816) * establish * dbcult1 * 0
06-NOV-2005 20:05:34 * (CONNECT_DATA=(SID=dbcult1)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=hppc1)(USER=demosw))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.9)(PORT=38172)) * establish * dbcult1 * 0
无法知道程序名,也没有进程号
trace_level设置成support了
通过v$process查询出来的进程号是服务器进程和后台进程,没有用户进程的信息,而且也很正常,没有反映每隔几秒有新的进程产生.
yxh_chinaunix

论坛徽章:
0
2楼 [报告]
发表于 2006-11-06 20:14 |只看该作者

回复 1楼 yxh_chinaunix 的帖子

我通过netstat -an |grep 1521 看到到现象是:
$ netstat -an |grep 1521
tcp 0 0 192.168.123.9.38966 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38962 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38960 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38958 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38956 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38952 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38950 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38948 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38944 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38942 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38940 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38936 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38934 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38932 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38928 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38926 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38924 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38920 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38918 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38916 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38914 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38910 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38908 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38906 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38902 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38900 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38898 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38894 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38892 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38890 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38886 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38884 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38882 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38880 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38876 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38874 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38872 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38868 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38866 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38864 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38860 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38858 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38856 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38852 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38850 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38848 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38844 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38842 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38840 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38838 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38834 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38832 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38830 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38826 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38824 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38822 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38818 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38816 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38814 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38810 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38808 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38806 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38804 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38800 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38798 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38796 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38792 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38790 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38788 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38784 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38782 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38780 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38776 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38774 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38772 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38768 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38766 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38764 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.38762 192.168.123.9.1521 TIME_WAIT
tcp 0 0 192.168.123.9.1521 192.168.123.9.62687 ESTABLISHED
tcp 0 0 192.168.123.9.62687 192.168.123.9.1521 ESTABLISHED
tcp 0 0 *.1521 *.* LISTEN
tcp 0 0 192.168.123.9.1521 192.168.123.9.39685 ESTABLISHED
tcp 0 0 192.168.123.9.39685 192.168.123.9.1521 ESTABLISHED
tcp 0 0 192.168.123.9.1521 192.168.123.9.39679 ESTABLISHED
tcp 0 0 192.168.123.9.39679 192.168.123.9.1521 ESTABLISHED
tcp 0 0 192.168.123.9.1521 192.168.123.9.39677 ESTABLISHED
tcp 0 0 192.168.123.9.39677 192.168.123.9.1521 ESTABLISHED
tcp 0 0 192.168.123.9.1521 192.168.123.9.39675 ESTABLISHED
tcp 0 0 192.168.123.9.39675 192.168.123.9.1521 ESTABLISHED
tcp 0 0 192.168.123.9.1521 192.168.123.9.39673 ESTABLISHED
tcp 0 0 192.168.123.9.39673 192.168.123.9.1521 ESTABLISHED
tcp 0 0 192.168.123.9.1521 192.168.123.9.39671 ESTABLISHED
tcp 0 0 192.168.123.9.39671 192.168.123.9.1521 ESTABLISHED
tcp 0 0 192.168.123.9.1521 192.168.123.9.39669 ESTABLISHED
tcp 0 0 192.168.123.9.39669 192.168.123.9.1521 ESTABLISHED
最上面的基本基本没连接,每隔几秒又会新增，严重影响了主机性能
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
yxh_chinaunix

论坛徽章:
0
3楼 [报告]
发表于 2006-11-07 11:19 |只看该作者
ding
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
numenhuang

论坛徽章:
0
4楼 [报告]
发表于 2006-11-08 09:42 |只看该作者
V$PROCESS反映的是当前active进程的信息，包括当前active user processes。

可能这个连接持续的时间很短，你可以audit connect by demosw 来跟踪哪些session连接上来。注意audit产生的记录数量及相关配置。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
xuebao_zx

论坛徽章:
0
5楼 [报告]
发表于 2009-08-28 12:59 |只看该作者
如果可以的话，建议你在数据库上创建触发器，来监视登陆情况。可以得到相关的IP地址。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP