DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Instance crash, alert log inside

  1. #1
    Join Date
    Jan 2001
    Posts
    3,134

    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.

  2. #2
    Join Date
    Apr 2003
    Posts
    32
    what version and platform?

  3. #3
    Join Date
    Apr 2003
    Posts
    32
    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.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    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
  •  


Click Here to Expand Forum to Full Width