Re: Strange Request

From: Kaing, Leng <Leng.Kaing_at_team.telstra.com>
Date: Wed, 08 Oct 2003 21:44:24 -0800
Message-ID: <F001.005D2702.20031008214424@fatcity.com>

You're going to have to be more specific here. How are you intending to trap for the error? In the alert.log? When it crashes the database? via a database trigger? a PL/SQL program? via shell script?

Methods for triggering the error will depend on how you're going to test for it. If you only want to detect it in the alert.log you can just write to the alert log using either "cat 'xx' > alert.log" or Dbms_system.ksdwrt. If you REALLY need the database to have a actual ORA-600 error, this requires a bit more thought. We've had a few of them in the past but can't remember exactly how to reproduce them. One of the most drastic measures would be to kill one of the background processes!! Of course this will also kill your database.

---

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
>
>

---

Leng Kaing
Email: leng.kaing_at_team.telstra.com
Phone: +61-3-9203-7589
Mobile: +61-417-371-348

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kaing, Leng
  INET: Leng.Kaing_at_team.telstra.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 Thu Oct 09 2003 - 00:44:24 CDT