RE: Force an ora-600?
- From: "Jeremiah Wilton" <jeremiah@xxxxxxxxxxx>
- To: <sacrophyte@xxxxxxxxx>
- Date: Fri, 4 Apr 2008 21:09:27 -0700
Charles Schultz wrote: > Perhaps this is no longer true for 11g (126.96.36.199)? Linux RHEL4. I also was unable to raise ORA-00600 on 188.8.131.52 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