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
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
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
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)
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
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
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-
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
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
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
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
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
12 matches
Mail list logo