Wouldn't this create a looping situation that would start t.sh over and
over again? This would, eventually, create more processes than the
configuration could handle and crash. Please correct me if I'm wrong.
- Vikas Kawatra <VKawatra_at_innoventry.com> wrote:
> What the heck do the following commands do ??
>
> -----Original Message-----
> Sent: Wednesday, May 09, 2001 9:01 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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: Weaver, Walt
> INET: wweaver_at_rightnow.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: Henry Poras
> INET: Henry.Poras_at_ctp.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Vikas Kawatra
> INET: VKawatra_at_innoventry.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).
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rocky Welch
INET: rockyw_99_at_yahoo.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 - 12:46:33 CDT
