Oracle 7 on 11i

[S.N.S]

Yes, I know it shouldn't be done, but this Customer has Oracle 7 currently - want to install this on a System V flavor. However, they would be migrating to Oracle 11 later.

Now, I read the doc on Oracle 7 from the site that supports v 10.2
The question is:
Can Oracle be installed on HPUX 11i - if yes how? Remember, we would need to migrate to Oracle 11g later!


Kindly guide,

Dunke/Merci
SNS

[melvyn burnard]

I would pass that query straight to the local Oracle office, they should have the answers fro you

[Patrick Wallek]

>>Can Oracle be installed on HPUX 11i

Maybe......

>>if yes how?

Following the usual Oracle install procedure would be my first choice.

Do you have a test server? If so, try it and see what happens.

[Steven E. Protter]

Shalom,

No you can not install oracle 7 on an 11i system. It will fail in the check stage due to an OS version check Oracle has.

You can install it on a 10.20 system and then use Oracle utilities to export the database.

There might be a procedure by which you can migrate the data files, if they exist anywhere. That would come from Oracle.

SEP

[S.N.S]

Hi/Peace,

SEP...
Thanks all for your suggestions.

Well, the fact is that the Oracle7 they have run on an old NCR box.
They need HP UX latest version, and then later the Oracle 11g migration.

I can suggest then is to do the Oracle migration first - then go for HP-UX?

Need guidance/redirection here folks!
Any help is appreciated (& points awarded)

Thank you,
SNS

[Steven E. Protter · Accepted solution]

Recommendations,

I would contact Oracle about a migration procedure. It may involve multiple versions of Oracle, but you should be able to back up the database cold or export the database and then migrate it into a current Oracle version that meets your needs.

1) Set up an HP-UX 11.31 system.
2) Install and get working the final version of Oracle you want to use.
3) Get ready for a painful migration.

SEP

[rick jones]

If Oracle 7 supports HP-UX 10.20 that means we are talking about a PA-RISC Oracle. When you way 11i and 11.31 are you talking about a PA-RISC HP 9000 system, or are we talking about an Itanium-based HP Integrity system, which will add the further wrinkle of needing to run the database code via the Aries PA-RISC translation/emulation?

[John Brooks_1]

Oracle's EXP/IMP utility will move the data from any version of Oracle to another version of Oracle. You can move from 7 to 11, but you can't go from 11 to 7. If oracle 7 will not run under 11i, you can always install Oracle 10g and inport you data. We have made the jump from 8i to 10g with no data issues.

Since Oracle 7 didn't have the tight inventory controls like the newer software has, you can simple try to copy your version 7 Oracle home to the new machine. No need to reinstall.

[Jean-Luc Oudart]

Hi

looks like lots of trouble running Oracle v7 on a newer system. Not too sure what you try to achieve as this would not be a supported configuration.

You did not mention the size of the database but considering the hardware it must be manageable with export / import.

There are many differences between v7 and v11.
eg what is the oracle optimizer (rbo or cbo). This may have some impact on the code.
But with a newer machine, OS and Oracle version, performance will probably go the right direction !

Let us know how this goes.

Regards
Jean-Luc

[S.N.S]

Hey Folks, you people are simply great!

Thank you for all the valuable advices.

Now, the best option (from the given worst choices from client side would be):

1. Get 10.2 on a PA-RISC --
Question: I think we can get a v10.2 - but just that HP doesnt support it - right?

2. Let Oracle help with the 7 - 11g migration

3. Upgrade 10.2 to 11iv3


Is there any better option?

Moderators! The whole process may take month - but I am not supposed to keep a thread open for that long - right?

Thank You all,
SNS