oracle 出现多个监听的SAP回复

Short Text
plz JAMES ZHANG to read listens issue
Long Text
dear Zhang:
my system Netweaver 7.0 EP is installed independent in a HP-UX
11.31
system.the database is oracle 10.2.0.1.
tomorow,the system cant be used,I'v check the EP instance/oracle
instance and the filesystem,all ok.when I check the oracle process,i
found
there are two listener process whit different process number,I kill
the two
process and restart listener .problem solved.
plz tell me why and how to prevent this happen again


Dear Customer,


This is an known bug for your database version.

To solve this issue, we have to options:

1. first is to upgrade the database to 11.2.0.4, because right now
your database version is already end of support for long time.

Another option to solve this issue is to following oracle metalink
340091.1:

2.1 add below parameter to listener.ora:

SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF

(Where <listener_name> should be replaced with the actual listener
name configured in the LISTENER.ORA file. This parameter is to be
placed by itself on an empty line / at the end of file.#)

For example, if the listener name is LISTENER (default), the parameter
would be:

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

2.2#Locate the ons.config file in the 10g(rdbms) home and rename it to
something else.
For example:
cd $ORACLE_HOME/opmn/conf
mv ons.config ons.config.orig

The listener needs to be restarted after these changes.

Afterwards the problem would be solved.

By the way again your database version is very very old, you have to
plan a database upgrade as soon as possible to avoid support limit.

Best regards,
James

http://blog.csdn.net/zqpgood/article/details/6091897
在Metalink上可以找到相关问题的很多解释,这个问题被最终确认为Oracle10201一个BUG,BUG号为:4518443,其会自动创建一个子监听器,当出现此情况时,监听器将会挂起。

Oracle称在较大压力下,监听进程可能出现间歇性停止服务,此时Oracle会spaw出另外一个监听进程,进而导致两个监听进程互相影响的故障。
请使用浏览器的分享功能分享到微信等