Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-08176: consistent read failure; rollback data not available

424754Nov 22 2004 — edited Jun 3 2009

Hi,

We implemented UNDO management on our servers and started getting these errors for few of our programs.:

ORA-08176: consistent read failure; rollback data not available

These errors were not coming when we were using the old rollback segments and we have not changed any code on our server.

1. What is possibly causing these errors?
2. Why did they not surface with rollback segments but started appearing when we implemented AUM and Temporary TS (instead of fixed TS used as temporary TS).

Our environment:

RDBMS Version: 9.2.0.5
Operating System and Version: Windows 2000 AS SP5

Thanks

Satish

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2009

Added on Nov 22 2004

#general-database-discussions

25 comments

50,408 views