Listener spawns child process

Post date: Feb 20, 2010 1:02:11 PM

If you are running Oracle database 10.2.0.4 on Linux server the chances are that you may hit the following bug when you ran autoconfig.

You may see that though the database is a non-RAC the autoconfig has resulted in many listener processes for the same SID.

oracle 12785 1 0 07:39 ? 00:00:00 /oracle/product/10.2.0.4/<SID>/bin/tnslsnr <listener_name> -inherit

oracle 12787 12785 0 07:39 ? 00:00:00 /oracle/product/10.2.0.4/<SID>/bin/tnslsnr <listener_name> inherit

oracle 12788 12787 0 07:39 ? 00:00:00 /oracle/product/10.2.0.4/<SID>/bin/tnslsnr <listener_name> -inherit

oracle 12789 12787 0 07:39 ? 00:00:00 /oracle/product/10.2.0.4/<SID>/bin/tnslsnr <listener_name> -inherit

One may even doubt whether the RAC is turned off in the code tree or not. Well, this is a bug

The solution is to update the listener.ora with the below entry and then restart the listener.

SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF

The parameter will prevent the listener from registering against ONS (Oracle Notification Services), which is the area affected by the bug, as well as disabling ONS itself.

Wow, you will find that the issue is resolved. But remember to take the backup of listener.ora and restoring it whenever the autoconfig is ran. Alternatively you may wish to update it in listener_ifile.ora