{"id":1271,"date":"2007-05-21T12:00:00","date_gmt":"2007-05-21T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1271"},"modified":"2007-05-21T12:00:00","modified_gmt":"2007-05-21T12:00:00","slug":"10-2-0-2-listener-bug-new-child-listener-process-forked","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2007\/05\/21\/10-2-0-2-listener-bug-new-child-listener-process-forked\/","title":{"rendered":"10.2.0.2 Listener bug, new child listener process forked"},"content":{"rendered":"<p>Today I solved a nasty intermittent problem we&#8217;d been having on one of our Production servers so I thought I&#8217;d blog about it here in case it saves someone else some pain. The symptoms were<\/p>\n<p>1) No-one was able to connect to the database.<\/p>\n<p>2) There were two listener processes running, which was apparent from a ps-ef|grep tns<\/p>\n<pre>oracle 2647896 1495262  1 May 18 -  0:00 \/oem\/oracle\/product\/10.2\/bin\/tnslsnr LISTENER \n\t\t\t\t\t\t-inherit \noracle 1495262       1  1 May 13 -  2:32 \/oem\/oracle\/product\/10.2\/bin\/tnslsnr LISTENER \n\t\t\t\t\t\t-inherit <\/pre>\n<p>(Note the different start times and the later process was definitely not started manually.)<\/p>\n<p>This had happened once or twice and we found that when we killed the child listener (note that one listener&#8217;s parent process ID is the process id of the other) everything worked correctly.<\/p>\n<p>This time I had a good look through the listener.log and noticed these warning messages related to the ONS service, even though we&#8217;re not using RAC.<\/p>\n<pre>WARNING: Subscription for node down event still pending<\/pre>\n<p>It took a while to track it down, but it turns out that this is a known, but unpublished bug number 4518443 in 10.2.0.2 (and no doubt previous versions), fixed in 10.2.0.3. For those of you with Metalink accounts, the relevant note is <a href=\"http:\/\/tinyurl.com\/39q29h\">here<\/a>. You can either apply patch 4518443 or, as a temporary workaround, disable that service by adding the following to your listener.ora configuration and restarting the listener.<\/p>\n<pre>SUBSCRIBE_FOR_NODE_DOWN_EVENT_&lt;<em>listener_name<\/em>&gt;=OFF<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Today I solved a nasty intermittent problem we&#8217;d been having on one of our Production servers so I thought I&#8217;d blog about it here in case it saves someone else some pain. The symptoms were 1) No-one was able to connect to the database. 2) There were two listener processes running, which was apparent from&hellip; <a class=\"more-link\" href=\"http:\/\/orcldoug.com\/blog\/2007\/05\/21\/10-2-0-2-listener-bug-new-child-listener-process-forked\/\">Continue reading <span class=\"screen-reader-text\">10.2.0.2 Listener bug, new child listener process forked<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1271","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1272,"url":"http:\/\/orcldoug.com\/blog\/2007\/05\/24\/listener-bug-part-2\/","url_meta":{"origin":1271,"position":0},"title":"Listener bug &#8211; Part 2","date":"May 24, 2007","format":false,"excerpt":"Work is a little busy at the moment, but I had time to look at this a bit more today ... Many thanks for the useful follow-up comments on the last posting. They were very interesting and if I'd picked them up in some of my Google searches, we might\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1264,"url":"http:\/\/orcldoug.com\/blog\/2007\/05\/06\/re-linking-oracle\/","url_meta":{"origin":1271,"position":1},"title":"Re-linking oracle","date":"May 6, 2007","format":false,"excerpt":"Hooray! Something vaguely technical - at last.My new client is hot on software licence compliance and what seemed a minor issue to me reared it's slightly ugly head this week. When connecting to our 10.2.0.2 database instances using sqlplus, the version banner displays options that we aren't using, for example\u2026","rel":"","context":"With 21 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1328,"url":"http:\/\/orcldoug.com\/blog\/2007\/10\/25\/which\/","url_meta":{"origin":1271,"position":2},"title":"Which?","date":"October 25, 2007","format":false,"excerpt":"No, I don't mean the UK consumer organisation, but a simple *nix command. It's so simple that I've hesitated about blogging about it, but when I keep sharing a small snippet of information and people don't know it and find it useful, it's probably worth mentioning here.If you work on\u2026","rel":"","context":"With 19 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":831,"url":"http:\/\/orcldoug.com\/blog\/2006\/03\/19\/solaris-10-and-oracle-10g\/","url_meta":{"origin":1271,"position":3},"title":"Solaris 10 and Oracle 10g","date":"March 19, 2006","format":false,"excerpt":"Well that was an interesting if not too productive weekend.I'd been keen to install Solaris 10 on the ISP4400, which went very well. These things are always time-consuming but I was interleaving it with normal human activity to make up for my recent mental absence from those around me. So\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1336,"url":"http:\/\/orcldoug.com\/blog\/2007\/11\/04\/rac-and-aix-continued\/","url_meta":{"origin":1271,"position":4},"title":"RAC and AIX &#8211; continued","date":"November 4, 2007","format":false,"excerpt":"If I was to believe Metalink Note 368916.1 (see previous post), then the HACMP software must be installed on the server we were installing 9.2.0.8 on. However, having reviewed \/etc\/inittab and investigating whether cluster services were running, it looked like HACMP wasn't in use. We checked with one of our\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1466,"url":"http:\/\/orcldoug.com\/blog\/2009\/01\/27\/adding-a-new-oracle-host-to-audit-vault\/","url_meta":{"origin":1271,"position":5},"title":"Adding a new Oracle host to Audit Vault","date":"January 27, 2009","format":false,"excerpt":"This one's been outstanding for a while. After my presentation on Audit Vault at UKOUG, the AV Product Manager Tammy Bednar sent me a couple of corrections to the configuration section. Rather than just amend the slides, I was keen to wait until I had another chance to configure a\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1271"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1271\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1271"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}