Hey boys and girls;
Well today I had a production instance crash and burn. I am trying to decipher what happened from the alert.log and .TRC files.
Any help is appreciated
Thanks.

Errors in file D:\oraadmin\Mr.Hanky\UDUMP\ORA00495.TRC:
ORA-00604: error occurred at recursive SQL level 1
ORA-02067: transaction or savepoint rollback required
ORA-20999: ORA-20701: Bid number Q0800799FR is locked
ORA-06512: at "UPLOAD_PROC", line 70
ORA-06512: at line 1

Tue May 06 16:45:48 2003
Errors in file D:\oraadmin\Mr.Hanky\UDUMP\ORA00495.TRC:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-02067: transaction or savepoint rollback required
ORA-20999: ORA-20701: Bid number Q0800799FR is locked
ORA-06512: at "UPLOAD_PROC", line 70
ORA-06512: at line 1

Tue May 06 16:46:42 2003
DBW0: terminating instance due to error 472
Instance terminated by DBW0, pid = 409



I think I need to go on a developer paintball implementation rampage!


MH