21 May 2007

An end to my Oracle listener hanging

Over the weekend I have become obsessed with two things: the Allman Brothers Band and Jeremy Schneider's diagnosis of the listener/ONS bug found in Oracle 10.2.0.2. The former due to "Jessica" being in the playlist for Guitar Hero II, the latter because not only did it provide me a rhyme and reason (and workaround) for my Oracle listener hanging, but it is one of the most well-written and presented diagnoses that I've seen, even busting out tcpdump to sniff the wire.

I somehow missed Jeremy's post when he originally wrote it a month ago, and stumbled across it today via Doug Burns. Doug mentions that he first noticed a problem when he saw multiple listener processes. A-HEM:

$ ps -aef | grep lsnr
oracle 32573 1 0 May13 ? 00:16:15 /u00/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
oracle 32574 32573 0 May13 ? 00:00:16 /u00/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
oracle 32575 32574 0 May13 ? 00:00:10 /u00/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
oracle 32576 32574 0 May13 ? 00:00:00 /u00/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit


At the risk of gushing like a fanboi, I'll just direct you to Jeremy's post while I remain here and aspire to pull it together like he does when faced with such things. Plus I can watch this:

1 comment:

  1. hey Jeremy thanks for the heads up. Unfortunately I don't think I'll make any concerts in the near future. I was heartbroken that Jonathan Coulton came and went from *2* Wisconsin stops and I couldn't attend either.

    And yes GH is great. I've challenged my 14-year-old brother-in-law to a Freebird-off. That song is all about the endurance. Although my mother-in-law warns me that he plays GH2 3 hours a night now.

    Plus a co-worker directed me to TMBG's cover of Jessica which is just so incredibly awesome it makes me cry.

    ReplyDelete