Re: OracleService is down on regular basis

2002-04-02 Thread Bob Robert
Jamdagni Danishment, Thanks for your help. I opened a ticket with Oracle and it got fixed. See the Oracle explanation ... This is bug 614799. Abstract: ORA-600[17034] WHEN CONSTRAINT IS VIOLATED Workaround is: set AUDIT_TRAIL=NONE or set AUDIT_TRAIL=FALSE Thanks, Bob --- Danisment Gazi Unal

OracleService is down on regular basis

2002-04-01 Thread Bob Robert
OS: Windows NT Oracle Database: 8.0.4 One of our production database instance OracleService was down at least three times in a row. At this stage, we have to restart OracleService to bring up the database. I saw couple of error messages in alert log file. ORA-00600: internal error code,

OracleService is down on regular basis

2002-04-01 Thread Bob Robert
OS: Windows NT Oracle Database: 8.0.4 One of our production database instance OracleService was down at least three times in a row. At this stage, we have to restart OracleService to bring up the database. I saw couple of error messages in alert log file. ORA-00600: internal error code,

RE: OracleService is down on regular basis

2002-04-01 Thread Jamadagni, Rajendra
Check the code in the trigger it seems that one of the variables is getting assigned a value that is longer than it can hold. The ora-2 error is user generated. Check on metalink you could be running into a bug, one of the posters got it resolved by pinning all the packages in SGA. Anyways,

Re: OracleService is down on regular basis

2002-04-01 Thread Danisment Gazi Unal
Hi, can you paste ora-600 trace files to list ? Jamadagni, Rajendra wrote: Check the code in the trigger it seems that one of the variables is getting assigned a value that is longer than it can hold. The ora-2 error is user generated. Check on metalink you could be running into a bug,