Try this:
A shell script calling sql env to ANALYZE certain table. kill the process running the shell script before it is done. You might get ora-00600 with argumrnt[1113]
Thanks
Pradhan
--------------------------------
On Wed, 08 Oct 2003 Sinardy Xing wrote :
>ora-600 may result your db down or crash
>
>-----Original Message-----
>Sent: 08 October 2003 10:09
>To: Multiple recipients of list ORACLE-L
>
>
>I want the DB to see and act on an ORA-00600, not just record
>one in the alertSID.log
>
>Thanks,
>Mike
>
>
>-----Original Message-----
>Sent: Tuesday, October 07, 2003 6:54 PM
>To: Multiple recipients of list ORACLE-L
>
>
>did you just want to see it in an alert.log? or are you working with a
>dump?
>
>joe
>
>
>Vergara, Michael (TEM) wrote:
>
> >Ok...strange request time. I want to test a script that I found
> >on the DBA Village web site. It's supposed to capture some
> >information whenever there's a DB error.
> >
> >Does anybody know how to trigger a 'benign' ORA-600 so I can test
> >this functionality?
> >
> >Thanks,
> >Mike
> >
> >
> >---
> >===========================================================================
> >Michael P. Vergara
> >Oracle DBA
> >Guidant Corporation
> >
> >
> >
>
>--
>Joseph S Testa
>Chief Technology Officer
>Data Management Consulting
>614-791-9000
>It's all about the "CACHE"
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Joe Testa
> INET: jtesta@dmc-it.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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.net
>--
>Author: Vergara, Michael (TEM)
> INET: mvergara@guidant.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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.net
>--
>Author: Sinardy Xing
> INET: SinardyXing@bkgcomsvc.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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.net
--
Author: bhabani s pradhan
INET: bhabaniindia_at_rediffmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Oct 08 2003 - 12:59:24 CDT
