- 最后登录
- 2017-7-13
- 在线时间
- 42 小时
- 威望
- 21
- 金钱
- 200
- 注册时间
- 2012-5-29
- 阅读权限
- 10
- 帖子
- 40
- 精华
- 0
- 积分
- 21
- UID
- 464
|
1#
发表于 2014-4-6 19:52:10
|
查看: 1957 |
回复: 0
操作系统SUSE Linux Enterprise Server 10 (x86_64) 数据库版本: 11.1.0.7.0 ,安装了Patch 13923474
问题是节点1产生大量监听日志,短短两天日志量100G
oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/alert> lsnrctl status
LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 06-APR-2014 19:45:22
Copyright (c) 1991, 2008, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date 06-APR-2014 19:31:07
Uptime 0 days 0 hr. 14 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/product/db11g/network/admin/listener.ora
Listener Log File /oracle/app/diag/tnslsnr/kfivr1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kfivr1)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "kfivr" has 1 instance(s).
Instance "kfivr1", status READY, has 1 handler(s) for this service...
Service "kfivrXDB" has 1 instance(s).
Instance "kfivr1", status READY, has 1 handler(s) for this service...
Service "kfivr_XPT" has 1 instance(s).
oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/alert> ll
total 483255
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:34 log_10.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:34 log_11.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:34 log_12.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:35 log_13.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:35 log_14.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:35 log_15.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:36 log_16.xml
-rw-r----- 1 oracle oinstall 10485859 2014-04-06 19:36 log_17.xml
-rw-r----- 1 oracle oinstall 10485762 2014-04-06 19:36 log_18.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:37 log_19.xml
-rw-r----- 1 oracle oinstall 10485837 2014-04-06 19:31 log_1.xml
-rw-r----- 1 oracle oinstall 10485832 2014-04-06 19:37 log_20.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:37 log_21.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:38 log_22.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:38 log_23.xml
-rw-r----- 1 oracle oinstall 10485846 2014-04-06 19:38 log_24.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:39 log_25.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:39 log_26.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:39 log_27.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:40 log_28.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:40 log_29.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:31 log_2.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:40 log_30.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:41 log_31.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:41 log_32.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:41 log_33.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:42 log_34.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:42 log_35.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:42 log_36.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:43 log_37.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:43 log_38.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:44 log_39.xml
-rw-r----- 1 oracle oinstall 10485873 2014-04-06 19:32 log_3.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:44 log_40.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:44 log_41.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:45 log_42.xml
-rw-r----- 1 oracle oinstall 10485762 2014-04-06 19:45 log_43.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:45 log_44.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:46 log_45.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:46 log_46.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:46 log_47.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:32 log_4.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:32 log_5.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:33 log_6.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:33 log_7.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:33 log_8.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:33 log_9.xml
-rw-r----- 1 oracle oinstall 1343552 2014-04-06 19:46 log.xml
log.xml 内容如下:
oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/alert> tail -50 log.xml
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>
<msg time='2014-04-06T19:47:31.071+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='kfivr1'
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>
<msg time='2014-04-06T19:47:31.071+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='kfivr1'
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>
<msg time='2014-04-06T19:47:31.072+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='kfivr1'
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>
<msg time='2014-04-06T19:47:31.072+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='kfivr1'
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>
<msg time='2014-04-06T19:47:31.072+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='kfivr1'
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>
oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/trace> tail -50 listener.log
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/trace> hostname
kfivr1
oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/trace> cat /etc/hosts
127.0.0.1 localhost
10.0.0.1 kfivr1.KF
10.0.1.2 kfivr1.KF
136.160.25.19 kfivr1
169.254.55.155 kfivr1_priv
136.160.25.18 kfivr1_vip
136.160.25.17 kfivr2
169.254.55.156 kfivr2_priv
136.160.25.16 kfivr2_vip |
|