Re: Faking an ORA-600

"Ball, Terry" wrote:
>
> We are trying to test out monitoring software (on a test database at
> 8.1.6.3). We have been able to generate most of the errors that we want to
> monitor for, but have been unable to generate an ORA-600. Does anyone have
> a way of doing this?
>
> TIA.
>
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX: 816-300-1800
>

Terry,

  Depends on how you do it. If it's by checking the alert log file, I presume that something such as

   execute sys.dbms_system.kdswrt(3, 'Errors in file blablah.trc:')    execute sys.dbms_system.kdswrt(3, 'ORA-00600: internal error code, arguments: [9999], [FAKED], [], [], []')

  should look alarming enough.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).