RE: Force an ora-600?

Charles Schultz wrote:

> Perhaps this is no longer true for 11g (11.1.0.6)? Linux RHEL4.

I also was unable to raise ORA-00600[12235] on 11.1.0.6 Linux/32 using the
tried and true method of invoking the oracle binary from the shell.

> Jeremiah Wilton, your suggestion worked wonderfully, thank you.

NP.  The story behind this is that Dan Morgan was somewhat miffed that ADR
had no facility for generating a "generic" event that would result in a
payload for Oracle Support similar to RDA.  The premise of ADR at present is
that some kind of error like an ORA-00600 has to happen to cause an event
that can be packaged.  If ADR payloads are meant to replace RDA, then there
needs to be some way to create an event/package on demand.

Dan bugged a few people at Oracle and was advised to raise ORA-700 with
dbke_test when he wanted to create an event for purely diagnostic purposes
(see blog entry). Dan generously shared this with me one day in the corridor
at OOW.

I liked the look of dbke_test and soon found that it has a usage prompt (as
per my blog entry), and tried a few other functions. One lets you raise
ORA-00600 (OERI) (dde_flow_kge_ora), with any arguments you like.  The
PL/SQL method has no way to pass arguments to the OERI. I also perused the
Oracle binary for other unit_test components and found a few.

Regards,

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net 

--
http://www.freelists.org/webpage/oracle-l

Other related posts: