-
Instance crash, alert log inside
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
I remember when this place was cool.
-
what version and platform?
-
Possible reasons:
1)
It appears that you may be encountering Bug:1951929. (fixed in 8173). "This problem is introduced in Oracle 8.1.7.2 and it present in 9.0.1.ORA-7445 in KQRGCU/kqrpfr/kqrpre can occur under heavy load, especially when the shared pool is stressed. This can lead to an instance crash."
Please apply the 8173 or better yet, the 8174 patchset.
2)Possibly you have backups running or a 3rd party software that has files locked.
A third party software, most likely a backup application, has locked a
datafile or logfile. When Oracle attempts to write to the file, the lock prevents it and the database crashes. Backup software should be configured so it does not lock open files.
3)Please check that you have plenty of space in the background_dump_dest and check the $ORACLE_HOME/rdbms/log directory to see if anything was written to this (default) location.
-
Sorry, this is ...
Version 8.1.6.1.0
Win NT
We are running in no archive log mode and there were no third party backups running at the time of this error. he upload proc listed is an front end application.
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|