Date: Thu, 7 Jan 1999 17:31:13 -0800 From: Jason Ackley To: BUGTRAQ@netspace.org Subject: Re: Fw:"NERP" DoS attack possible in Oracle On Wed, 6 Jan 1999, Paul Schenk wrote: > In fact, on HP-UX 10.20, Oracle 7.3.3, in listener.log you get: > > 06-JAN-99 16:15:45 * 12569 > TNS-12569: TNS:packet checksum failure > > And tnslistner continues happily along at ~0 CPU usage, it even accepts and > processes new connections fine. > > So its either an Oracle 8/NT thing or a misconfiguration > I sent this to Aleph1, but I guess he was busy, in regards to OS combinations: --- >From: bruce_redmon@sra.com I tested this on Sequent Dynix and sure enough it runs the process out of control. If it happens on this platform I suspect this can happen on any platform. --- >From: bcf@jwfc.acom.mil confirmed on Oracle 8.0.3 on Solaris 2.6 port 1521 confirmed on Oracle 8.0.5 on Solaris 2.6 port 1526 --- >From: giblin Hello, I gave it a try on a Solaris 2.6 ( heavily patched ) and Oracle 8.0.4 Database CPU utilization climbed and hovered at a high 49.9x% and didn't fall below 49.7x%. This is on a UE450 with 2 processors and 1.5GB RAM. Oracle required a restart to get it back into previous working condition. Hmmm... Nice :) --- >From: Adam vonNieda I've tried the bug on my Linux box, (8.0.5), and it pegged instantly. I then tried it on one of my IBM SP (8 way) nodes running AIX 4.3 and Oracle 8.0.4.2.1, and essentially lost the processor that the listener is attached to instantly. So, it won't totally dog an SMP machine, but I wouldn't expect much response from the listener! Thanks for the info. --- >From: gabriel magee I just tried it on NT SP3 (+hotfixes) Oracle 8.0.5.0.0 Production on a PII/350 with the same results. 100% CPU until you kill the listener. Could maybe choose a different protocol adapter in the meantime, too... --- Many thanks to everyone that sent in reports! We still seem to be missing information for SGI/IRIX, any takers? cheers, -- Jason Ackley jason@ackley.net