ORA-604, ORA-1555 AND ORA-2067
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-604, ORA-1555 AND ORA-2067

  1. #1
    Join Date
    Nov 2001
    Location
    SC
    Posts
    23

    Cool

    Hi DBA's,
    Please help me with these errors. I have a batch job that runs at night and failed with these errors.

    ORA-00604: error occurred at recursive SQL level 1
    ORA-02067: transaction or savepoint rollback required
    ORA-01555: snapshot too old: rollback segment number 1 with name "RB_BIG" too small

    I checked the batch job log for errors, these errors were reported by the job
    ORA-00603:Oracle server session terminated by fatal error.
    ORA-01041 :internal error. hostdef extension doesn't exist.

    I need help to fix these errors.
    RB_BIG is 2400K with optimal at 24000K, minextents 10 and maxextents 249. I do not know how large this job gets.

    Please help.
    :)

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    This topic has been discussed several thousand times in these forums. Please check http://www.dbasupport.com/forums/search.php
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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