Re: HP/UX and Oracle Server 7.1.4

Peter Grant (grant_at_devbn1.triumf.ca) wrote:
: I've had quite a week with HP/UX 9.x and Oracle Server 7.1.4 all right.
 

: Has anyone else out there had real problems? In my case, we encountered
: a known Oracle bug which ended up corrupting the database. Wiping it clean
: and starting over was the only suggestion Tech Support had. It's been seven
: days now putting it all back together, encountering one after another bug
: (all showing up as internal errors, many having to to do with corrupt indexes,
: for whatever reason). Oracle says they're seen the index problems before,
: but have never been able to reproduce it. We've encountered it three or four
: times in the past week. The project is now delayed by over a week due to all
: of this excitement. Having the trace files sent to California is little help
: at this point.
 

: Dropping and recreating the indexes on our tables takes about 12 hours on
: our I50 - there's about 3GB of data and indexes in total so far.
 

: I just received 7.1.6.2.0 today, and am thinking that I should probably just
: put it in (as soon as the last table population process finishes - a 72 hour
: job which is half way).
 

: Are other HP/UX users using 7.1.6 successfully?

I've used Oracle on HP-UX 9.x for the past 3 years in production shops beginning with v6.0.36 and have encountered only a couple of nasty database corruption bugs (that was under 7.0.15, btw). Otherwise, I think it is definitely one of the more robust and cost efficient Oracle/UNIX combinations I have worked with. I am now using 7.1.4 in production and doing application testing for 7.1.6 in preparation for an production upgrade soon. Neither has provided any of the "excitement" you've been experiencing.

I would possibly look at maybe your hardware and make sure some disk isn't acting flaky. Is this a brand, new machine or disks? Are the corruptions happening consistently on one disk pack or controller? We are on I70's and T500's with RAID disks. Maybe a full HP diagnostics might be in order, just to rule out hardware as a variable.

btw, I do *not* work for HP...i am an independent contractor, and I base my strong praise for HP and Oracle not on my affiliations but purely on past experience with Oracle and it running on HP as well as other platforms.

Johnny Chan
Indepedent Oracle Specialist Received on Mon Jul 24 1995 - 00:00:00 CEST