Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 7 on 11i

SOLVED
Go to solution
S.N.S
Valued Contributor

Oracle 7 on 11i

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
"Genius is 1% inspiration, 99% Perspiration" - Edison
13 REPLIES

Re: Oracle 7 on 11i

I would pass that query straight to the local Oracle office, they should have the answers fro you
My house is the bank's, my money the wife's, But my opinions belong to me, not HP!
Patrick Wallek
Honored Contributor

Re: Oracle 7 on 11i

>>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
Exalted Contributor

Re: Oracle 7 on 11i

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
S.N.S
Valued Contributor

Re: Oracle 7 on 11i

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
"Genius is 1% inspiration, 99% Perspiration" - Edison
Steven E. Protter
Exalted Contributor
Solution

Re: Oracle 7 on 11i

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
rick jones
Honored Contributor

Re: Oracle 7 on 11i

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?
there is no rest for the wicked yet the virtuous have no pillows

Re: Oracle 7 on 11i

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
Honored Contributor

Re: Oracle 7 on 11i

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

fiat lux
S.N.S
Valued Contributor

Re: Oracle 7 on 11i

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
"Genius is 1% inspiration, 99% Perspiration" - Edison
Steven E. Protter
Exalted Contributor

Re: Oracle 7 on 11i

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Patrick Wallek
Honored Contributor

Re: Oracle 7 on 11i

>>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.

Re: Oracle 7 on 11i

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
Valued Contributor

Re: Oracle 7 on 11i

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.
"Genius is 1% inspiration, 99% Perspiration" - Edison