RE: Migrating Oracle

We are in an identical process now. Migrating from 7.3.4 and 7.2.3.0 (yes, we survided Y2K !) on HP-UX 10.20 to HP-UX 11.0. The path we chose was to migrate to 8.0.6 on 10.20 first. And then transfer databases to newly built machines running HP-UX 11.0 and Oracle 8.0.6. This way, we assumed, there would be less 'surprises' from Oracle s/w side. We did not run into any problems. The next phase is to upgrade on HP-UX 11 from Ora 8.0.6 to 8.1.6. We stayed with 32-bit Oracle on HP-UX 11.0. We do not have any Appl to take advantage of 64-bit processing and our SGAs are not approaching 2GB size either. However, the Developers were a bit concerned about large sizes of their Pro*C and Pro*COBOL executables on HP-UX 11.0. Answer to that was to convert to PL/SQL procedures as much as possible, which will be undertaken soon on Dev machines.

HTH..

• Kirti

> -----Original Message-----
> From: Kimberly Smith [SMTP:KSMITH1_at_gmd.fujitsu.com]
> Sent: Thursday, April 27, 2000 9:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Migrating Oracle
>
> Currently we are running Oracle 8.0.5 32-bit on HPUX 10.20. We are going
> to
> be upgrading our machines to HPUX 11 64-bit. I already have an Oracle 8i
> 64-bit database running in this environment but its a new database. Has
> anyone had the joy of going from 8.0.5 to 8i (probably 8.1.5) and from
> 32-bit to 64-bit plus a new operating system? Any gotya's to go with
> that?
> I think the preference so far in our upgrades is to go from a fresh
> install
> of the OS instead of upgrading but they have not done one with a database
> yet. These are all 24x7 production systems as well.
>
> I would be willing to upgrade the database to 8.0.6 first then move it to
> HP11 as 8.0.6 then upgrade to 8i but keep it 32-bit. I see no real gains
> in
> 64-bit in our cases (from an Oracle standpoint). Even though that
> involves
> a couple of upgrades does it not seem like the easiest and safest in the
> end? Any thoughts appreciated.
Received on Fri Apr 28 2000 - 08:45:54 CDT