Oracle Debugging‎ > ‎

Listener spawns child process

posted Feb 20, 2010, 5:02 AM by Saptharishi Suresh   [ updated Feb 20, 2010, 9:16 AM ]
If you are running Oracle database 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/<SID>/bin/tnslsnr <listener_name> -inherit

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

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

oracle   12789 12787  0 07:39 ?        00:00:00 /oracle/product/<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.


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