the last posting<\/a>. They were very interesting and if I’d picked them up in some of my Google searches, we might have solved the problem more quickly, although I would re-emphasise a couple of general points :-<\/p>\n1) This particular problem is nothing to do with RAC, in as much as the server concerned is not part of a cluster, so this is just as likely to happen on a single instance\/node.<\/p>\n
2) What’s irritating about this is that it’s because the Listener is configured to use ONS by default, even if we’re unlikely to be interested in using it in a single-instance environment. (Actually, is that true? I’ll come back to that.)<\/p>\n
What I neglected to mention last time is that there is another work-around mentioned in the various Metalink notes. We can rename the ons.config file so that the Listener won’t see it and try to start ONS. This is from my server at home.<\/p>\n
Sun Microsystems Inc. SunOS 5.10 Generic January 2005\n$ cd $ORACLE_HOME\/opmn\/conf\n$ ls -ltra\ntotal 6\ndrwxr-x--- 7 oracle oinstall 512 Oct 7 2006 ..\n-rw------- 1 oracle oinstall 44 Oct 7 2006 ons.config\ndrwx------ 2 oracle oinstall 512 Oct 7 2006 .\n$ cat ons.config\nlocalport=6100\nremoteport=6200\nloglevel=3<\/pre>\n So I could just rename ons.config and restart the Listener and that should fix it. <\/p>\n
However, I much prefer the original solution I mentioned. Rather than renaming configuration files in the ORACLE_HOME with no obvious reason why (which seems a bit of a hack to me), I prefer having the parameter in listener.ora which explicitly disables the subscription, with a comment explaining why it’s there. e.g.<\/p>\n
# Workaround for bug 4518443 - should be fixed in 10.2.0.3\nSUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF<\/pre>\nBetter still, just patch to the right level, but we found the listener change less risky and faster to implement. It went in last night although I’m glad to say it wasn’t me that made the change – thanks Richard 😉<\/p>\n
Oh, yes, so why do Oracle configure this even in a non-RAC environment? Well, for all I know it’s just a mistake, but it occurred to me that just because it’s single-instance and it might not be so useful, maybe an application would want to use FAN? Maybe not.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 have solved the problem more… Continue reading Listener bug – Part 2<\/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-1272","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1271,"url":"http:\/\/orcldoug.com\/blog\/2007\/05\/21\/10-2-0-2-listener-bug-new-child-listener-process-forked\/","url_meta":{"origin":1272,"position":0},"title":"10.2.0.2 Listener bug, new child listener process forked","date":"May 21, 2007","format":false,"excerpt":"Today I solved a nasty intermittent problem we'd been having on one of our Production servers so I thought I'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\u2026","rel":"","context":"With 16 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":982,"url":"http:\/\/orcldoug.com\/blog\/2005\/03\/23\/system-managed-undo-problem\/","url_meta":{"origin":1272,"position":1},"title":"System Managed Undo Problem","date":"March 23, 2005","format":false,"excerpt":"Tired of trying to fix my daughter's PC (that nightmare's still ongoing) and dealing with the complex emotions of Oracle professionals (that'll be me then), I thought I'd try to post something potentially useful.We use System Managed Undo (or Automatic Undo Management - your choice) on a large number of\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1159,"url":"http:\/\/orcldoug.com\/blog\/2006\/12\/11\/a-more-complex-statspack-example-summary\/","url_meta":{"origin":1272,"position":2},"title":"A More Complex Statspack Example – Summary","date":"December 11, 2006","format":false,"excerpt":"Looking back at the three blogs (and hopefully the comments, where others have made some very useful contributions), it's all quite unsatisfactory, isn't it? We haven't solved the problem. All we've proved is that the tests aren't equivalent, although I think there's value in that negative result because I was\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1339,"url":"http:\/\/orcldoug.com\/blog\/2007\/11\/06\/the-reality-gap-3-a-single-instance-per-server\/","url_meta":{"origin":1272,"position":3},"title":"The Reality Gap (3) – A Single Instance per Server","date":"November 6, 2007","format":false,"excerpt":"There will probably be about four or five of these posts in total. This is one I didn't mention in the original presentation because I didn't feel I could do it justice and because there was someone I wanted to have the right to reply. Step forward Tom Kyte.By coincidence,\u2026","rel":"","context":"With 15 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1156,"url":"http:\/\/orcldoug.com\/blog\/2006\/12\/07\/a-more-complex-statspack-example-part-2\/","url_meta":{"origin":1272,"position":4},"title":"A More Complex Statspack Example – Part 2","date":"December 7, 2006","format":false,"excerpt":"So far we're barely into the comparison of the Statspack reports from the two different test environments and they look quite different already.Next up, the Instance Efficiency Percentages. I have to confess that I rarely find these very useful because the numbers are always near 100% on most databases I\u2026","rel":"","context":"With 13 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1302,"url":"http:\/\/orcldoug.com\/blog\/2007\/07\/29\/oracle-workload-metrics\/","url_meta":{"origin":1272,"position":5},"title":"Oracle Workload Metrics","date":"July 29, 2007","format":false,"excerpt":"I've been asked this question at quite a few sites so thought it would be worth blogging about. (The fact that it's a common question also implies that any criticism is aimed at the industry rather than individual companies or colleagues.)Someone, usually a manager, wants to see the workload history\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1272","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=1272"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1272\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1272"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}