Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Cool way to crash an Oracle database, any time, any place

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

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Wed, 09 May 2001 19:32:59 -0700
Message-ID: <F001.002FEC8E.20010509191119@fatcity.com>

why do I get an image of you sticking your tongue out at Brian? :)

>From: Jared Still <jkstill_at_cybcon.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Cool way to crash an Oracle database, any time, any place
>Date: Wed, 09 May 2001 17:40:26 -0800
>
>
>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).



Get your FREE download of MSN Explorer at http://explorer.msn.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: carmichr_at_hotmail.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).
Received on Wed May 09 2001 - 21:32:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US