DB Broken

First, I'd like to say I think it's the application, but I have to ask.

Our A/R system is running on Oracle 7.3.4 for OpenVMS on a DEC Alpha. Anyway, the Alpha appears to have a bad CPU, and this past Tuesday it rebooted itself. Big Q had a new CPU on order, but both Oracle DBS were open at the time.

Things started getting weird on Wed - the app is a graphical screen scraper with COBOL driven batch programs behind the scenes. The table structures are a mess, was a flat file crammed into Oracle. All dependancies are maintained in code.

So starting Wed, people were getting kicked out because "A Serious DB Error was encountered". So we dug through the source (we own it), and this app does consistency checking at run time.

We wanted to make sure everything was ok, so we exp Production and imp into test. The reimp went fine, so it seems some records removed Monday caused the prob. We were able to reinsert the records and fix that problem (reindexing the table in question of course).

Anyway, at this point I remove the blame from the evil A/R system. Now, when a user does a lookup for "ma" for example, they go down to the bottom, and then when they go up after reaching the last "ma" they get the "s"s.

So what I'm wonder is, does Oracle maintain pointers in the DB that could be corrupt? Like I said, I've rebuilt the index for this table and it still act's strange. We're looking into a rebuild util for the horrid code dependancies, but I want to make sure nothing is wrong in Oracle. (SQL queries seem ok).

Thanks,
John

--
**************************************************


"One World, One Web, One Program" - Microsoft Ad

"Ein Volk, Ein Reich, Ein Fuhrer" - Adolf Hitler



Sent via Deja.com http://www.deja.com/
Before you buy.