RE: Faking an ORA-600

2002-12-20 Thread Ball, Terry
Thanks for the replies. I was able to test sucessfully. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Thursday, December 19, 2002 2:52 PM To: Multiple recipients of list ORACLE-L We are trying to test out monitoring software (on a test

Re: Faking an ORA-600

2002-12-19 Thread Stephen Andert
vi and manually add it ??? Stephen Andert Scottsdale, Arizona [EMAIL PROTECTED] 12/19/02 01:51PM 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

RE: Faking an ORA-600

2002-12-19 Thread Jamadagni, Rajendra
Title: RE: Faking an ORA-600 dbms_system.ksdwrt(2,'abc2_ora_2269266.trc:ORA-00600: internal error code, arguments: [794], [0x700189CDE40], [0x700189CDF08], [0x700189D0398], [4294967295], [], [], []'); Basically put anything in the string ... Lather , rinse, repeat. Raj

Re: Faking an ORA-600

2002-12-19 Thread Jonathan Lewis
Have you tried a search on metalink for 8.1.6.3 and ORA-00600 in the Advanced search section of the Bug database ? Offhand, this might work: create a table with 3 columns create table t1 as select trunc((rownum-1)/100,0)b1, mod(rownum,100)

Re: Faking an ORA-600

2002-12-19 Thread Stephane Faroult
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

RE: Faking an ORA-600

2002-12-19 Thread Loughmiller, Greg
Title: RE: Faking an ORA-600 How about taking the text of the ORA-600 error and CAT the text to the end of your alert file? I am assuming that you will be parsing the alert log for that type of notification greg -Original Message- From: Ball, Terry [mailto:[EMAIL PROTECTED

RE: Faking an ORA-600

2002-12-19 Thread Fink, Dan
If this is unix, type oracle at the command line. It will through an ORA-00600 in the alert log of the database identified by $ORACLE_SID. I learned this one the hard way...after a series of panicked calls to Oracle support when I was a Jr. DBA (e.g. last week ;) Dan -Original Message-

RE: Faking an ORA-600

2002-12-19 Thread Johnston, Tim
Type oracle at the command line and hit enter... It should come right back to the command prompt but you'll see the following in the alert log... ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], [] -Original Message- Sent: Thursday, December 19, 2002 3:52 PM

RE: Faking an ORA-600

2002-12-19 Thread Smith, Ron L.
If you don't mind messing up a datafile, you could copy junk over an index datafile. Then use the index in a query. We had a corrupt index that always generated an ORA-600. R. Smith -Original Message- Sent: Thursday, December 19, 2002 3:39 PM To: Multiple recipients of list ORACLE-L

RE: Faking an ORA-600

2002-12-19 Thread Fink, Dan
Okay, so I can't trype, I mean type... through should be THROW. I like this method because it does not make any schema changes, corrupt any indexes (even if they are junk). And it is very easy to repeat for multiple sids. dba:X920oracle dba:X920tail -3

Re: Faking an ORA-600

2002-12-19 Thread Jared . Still
If you are monitoring the alert.log, try dbms_system.ksdwrt http://www.oracledba.co.uk/tips/plsql_alert_log.htm Jared Ball, Terry [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/19/2002 12:51 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

RE: Faking an ORA-600

2002-12-19 Thread Rahul
recipients of list ORACLE-L Subject: Re: Faking an ORA-600 If you are monitoring the alert.log, try dbms_system.ksdwrt http://www.oracledba.co.uk/tips/plsql_alert_log.htm Jared Ball, Terry [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/19/2002 12:51 PM Please respond