HP/UX and Oracle Server 7.1.4

HP/UX and Oracle Server 7.1.4

Post by Peter Gra » Thu, 20 Jul 1995 04:00:00



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 e*ment.  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?

 
 
 

HP/UX and Oracle Server 7.1.4

Post by Johnn » Tue, 25 Jul 1995 04:00:00


: 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 e*ment.  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 *
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 "e*ment" 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

 
 
 

HP/UX and Oracle Server 7.1.4

Post by Parris Geis » Tue, 25 Jul 1995 04:00:00



> 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 e*ment.  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?

Peter,
        Yes, we are. I also a problem with 7.1.4 dealing with TUXEDO/XA transactons.
        We were told that, oh, yes all of our XA customers on going to 7.1.6!!
                parris geiser
 
 
 

1. Any Advice for Converting from HP-UX 9.0x to HP-UX 10.xx

We are a little puzzled about how different a system is HP-UX 10.0 from HP-UX 9.04.

Some of the software (HP LABUX-don't ever buy it!!) that we currently have is not being
upgraded to HP-UX 10.0.

Therefore, we have decided to get an ORACLE system and start migrating into it.

What are some of the major components that 10 provides that are significantly different
and USEFUL from 9.x?

Are the binaries etc.. that different that we will need to have a complete system overhaul?

How long would HP possibly support 9.04?

Are we doomed if we stay on 9.04 for next 5 years?

Would we run into problems with ORACLE if we don't keep up?

Thanks for any input!
Mir

2. help: Comet Cursor ?

3. Oracle HP/UX client/server to ORACLE NLM?

4. Getting E-Mail via Dial-up and Exchange Server

5. Technical Support Analyst - ORACLE/SYBASE/HP-UX/4GL/Client Server - Bay Area, California

6. RDB and VMS 6.1 Question

7. Connecting Delphi / WfW3.11 to Oracle / HP-UX sql server?

8. Admin Shares accessible by everyone

9. Help connecting to HP-UX oracle database server, please!

10. HP MirrorDisk/UX & Oracle 7 on HP 9000 G50

11. Parallel Server on HP-UX

12. Oracle7 Workgroup server on HP-UX Version 10.1