Will Oracle 10g work when upgrading 11.11 to 11.23?

[Oscar Melez]

Hi,

We recently completed upgrading Ora 10g on HP-UX 11.11. If we later upgrade to 11.23, will Oracle 10g still work without changes or does it need to be re-installed?

Appreciate all feedback on this. Thanks.

[Steven E. Protter]

Shalom Oscar,

It probably will not.

At the very least you will need to relink Oracle and it may or may not work properly after the upgrade.

The upgrade itself failes more often than it succeeds. You are better off with a cold install followed by a reinstall of Oracle after the cold OS installation.

I'm assuming what you mean by upgrade, you have an 11.11 machine that can run 11.23 and you run upgrade-ux.

Oracle has different software for PA-Risc versus Itanium servers and a migration is required to accommodate that kind of move.

SEP

[Oscar Melez]

Thanks Steven. The reason I'm exploring this possibility is because we're moving to a new hosting center which will be using 11.23 on itanium servers (we're currently on Pa-RISC). They will be installing Oracle10g there and to sync data with our current box during the migration, they will be using Oracle DataGuard.

The project architect advised that Dataguard transfers between Ora10g on different hardware is certified only between 11.23 systems. So i guess my question should be whether that is correct or not. my initial impression is, data transfer of that kind is on the oracle layer and should probably work as long as both databases are 10g.

[Bill Hassell]

Going from PA-RISC to Itanium is the biggest step. You can safely assume that Oracle must be installed (not copied) on the new boxes. Although the executables might run on Itanium, they will be run through the PA-RISC emulator so you'll see about a 3x-4x performance penalty (that's a LOT). By installing, you'll get native executables.

[Yogeeraj_1]

Hi Oscar,

You will definitely have to reinstall the database software and perform the migration to the new environment.

It is also still too early to think about it, when the time come, review the certification matrix on the Oracle MetaLink Web site for the most up-to-date list of certified hardware platforms and operating system versions.

hope this helps!

kind regards
yogeeraj

[Steven E. Protter]

You are PA-RISC.

No way can you upgrade. You must do a cold install on new systems, and follow Oracle's data migration guidelines, if the new systems are Itantium and more than likly they are.

I'd have the same recommendations if this was PA-RISC to PA-RISC.

As a new ITRC user, please read this:
http://forums1.itrc.hp.com/service/forums/helptips.do?#28

SEP

[Ivan Pechorin]

Hi, Oscar!

"The project architect advised that Dataguard transfers between Ora10g on different hardware is certified only between 11.23 systems."

I tried hard to find such certification information on Oracle Metalink, but I failed. Here is info from two documents on Metalink:

1) from "Certification and Prerequisites for Oracle DataGuard" (Doc ID 234508.1):

"Primary and Standby Database must
- reside on the same Platform
- use the same Oracle Baserelease (eg. 9.2.0)

Primary and Standby should have
- the same Patchlevel (eg. 9.2.0.3)
- the same OS-Version
- the same Hardware Configuration"


2) from "Supported Physical Standby Database Word Sizes" (Doc ID 239941.1):

"A production database protected by a physical standby database in a Data Guard configuration is isolated from Operating System differences. What this means is that the production system and the standby system can be on different releases of the same OS (e.g.,Solaris 2.6 or Solaris 8) and/or these Operating Systems can be of different bit-ness (32-bit OS or 64-bit OS). The two nuances to this are that the Oracle bit-ness must be the same for the production and standby databases (i.e., Production DB bit-ness must equal the Standby DB bit-ness) and this compatibility is within the same OS family/architecture (e.g., Solaris 2.6 to Solaris 8 is OK but Solaris to HP-UX is not OK, and HP-UX 10.20 to HP-UX 11.0 is not OK too)."


"From a technical compatibility perspective, the rules are:

- database bit-ness must be homogenous between production and standby systems
- the OS release can be heterogeneous between production and standby systems
- the OS bit-ness can be heterogeneous between production and standby systems"


As far as I know, Oracle on HP-UX on PA-RISC and Itanium 2 have the same endianness (big-endian).

I suppose, that:

1) First of all, you can try Data Guard without upgrading you PA-RISC box from 11.11 to 11.23, i.e. from HP-UX 11.11 on PA-RISC to HP-UX 11.23 on Itanium.

2) If it fails, after migration of PA-RISC box from 11.11 to 11.23 it should fail also, because Oracle is the same for these releases of HP-UX for PA-RISC (64-bit, big-endian, installed from the same set of CD or DVD)