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

[Steven E. Protter]

Hi again,


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?

Right. You can't buy PA-RISC systems and 10.20 support ended in 2003

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

That is the right way to go.

3. Upgrade 10.2 to 11iv3

Can't. Need to do a new install of a new system on new hardware 11.31 is the best way to go to avoid obsolescence.

Is there any better option?

Nope.

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

They don't care. Pete Randall refused to close his threads.

SEP

[Patrick Wallek]

>>Upgrade 10.2 to 11iv3

That is not going to be possible. Any hardware that is capable of running HP-UX 10.20 will NOT run HP-UX 11iv3.

[John Brooks_1]

I agree with Steven on the options. You should be able to upgrade the database and move to the new hardware in one jump. How big is the database?

I have installed the Oracle binaries and then use the dbca to create an empty database. Create all the tablespaces and user you need. Then imp the V7 data into the new database. You may have issue with user constrants, but if you import only the database structure first , no data, and then import the data, you should be able to get it moved.

I don't know if the Oracle Migratation tools will work on a V7 database. I have moved an 8i to 10g without issue using the Oracle tools. One question is Migration tools VS exp/inp and that depends on the database size. But that can be worked around by only exp/imp a user at a time.

[S.N.S]

Thanks SEP, Patrick, John..and all for your
valuable inputs...

One more shot though before "pausing" the thread
-Can virtualization help reduce the above complexities in any way? - I dont know..

Thanks Again!

SNS

NB: The DB is not large, though they havent given the size.