Home > bug > listener.log service_update spin (BUG 9235880)

listener.log service_update spin (BUG 9235880)

今天开发库磁盘又屌爆了,直接原因是listener.log里面下面这种信息狂增:

01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 01-FEB-2012 16:26:59 * service_update * johnnydb * 0 ...

 

一秒钟会产生几百条记录:

[oracle@johnnydb log]$ grep "01-FEB-2012 16:26:59" listener.log|wc -l
653

暂时的解决办法就是将listener的log_status关掉,不输出,但是这样就捕获不到有用的连接信息了,而且不治本。

逛逛metalink,恭喜,中BUG了(9235880),具体描述可以参考ID 982068.1,看样子是PMON向listener频繁发送service_update信息引起,而触发条件就是remote_listener设置为空这一操作执行2次。忽然想到前一段时间remote_listener确实被动过。。

文章中提供的解决方法也很简单:

Solution

Bug is being worked on by development.

Do not set REMOTE_LISTENER to Null if already Null

Workarounds

If REMOTE_LISTENER is required to by Null, set to value before setting to Null

ALTER SYSTEM SET remote_listener='example.com' SCOPE=BOTH; ALTER SYSTEM SET remote_listener='' SCOPE=BOTH;

Or set to a false value

ALTER SYSTEM SET remote_listener='example2.com' SCOPE=BOTH;

Example2 not being a valid net-service-name entry

Categories: bug Tags:
  1. No comments yet.
  1. No trackbacks yet.