topic Re: Database compatibility Question in Operating System - HP-UX

Database compatibility Question

Waqar Razi — Thu, 31 Jul 2008 17:02:36 GMT

I am working on upgrade of OS on hp ux servers. I have few questions about database compatibility:

1- Is oracle 9.2.0 is supported on hpux 11.31?

2- Is Oracle 8.1.7 supported on hpux 11.11, 11.23 and 11.31? If not, on what versions of hpux it is supported?

3- If I want to migrate from oracle 8.1.7 to oracle 9.2.0, what are the steps and considerations I have to take before doing that?

Regards,

Razi

Re: Database compatibility Question

Steven E. Protter — Thu, 31 Jul 2008 17:11:30 GMT

Shalom,

1) My understanding is that all supported oracle versions are now certified with 11.31.

2) Oracle 8.1.7 is not supported on HP-UX 11.31 because it was de-supported by Oracle before 11.31 was released. It might work, but technically its not supported on any OS any more from the oracle perspective.

3) That migration involves a data migration/conversion. There is a 26 step conversion plan on Oracles metalink site. My DBA did this once for me back in 2005.

Note if you are planning a migration you might want to think about Oracle 10g. Oracle 9.2.0 is nearing the end of its support life cycle.

SEP

Re: Database compatibility Question

Waqar Razi — Thu, 31 Jul 2008 17:21:40 GMT

Could you please send me the link for 26 step migration plan?

Also when is the end of support for oracle 9.2.0?

Could you also please refer some plan for database migration from 8.1.7 to 10g and also from 9.2.0 to 10g?

Re: Database compatibility Question

Patrick Wallek — Thu, 31 Jul 2008 17:23:42 GMT

You should really be checking with Oracle on these questions.

Oracle 8i is currently out of support completely, so there will be NO support for it on 11.31. It may work, but if you have problems you are on your own.

I believe Oracle 9i is almost out of support as well. Again, it may work, but you would be on your own if you have problems.

If I were looking to migrate, I would be looking to go to Oracle 10gR2 or 11g.

Oracle has some good documentation about upgrading and migrating. You should have a look at it.

Re: Database compatibility Question

Oviwan — Thu, 31 Jul 2008 22:57:31 GMT

hey

have you access to http://metalink.oracle.com? there you will find all this information. for example under the certify link...

Regards

Re: Database compatibility Question

Deepak Kr — Fri, 01 Aug 2008 00:43:03 GMT

Good to go with Oracle 10g now!!

Older versions will be out of support matrix soon.

Re: Database compatibility Question

Yogeeraj_1 — Fri, 01 Aug 2008 18:29:35 GMT

hi Razi,

I would 'upgrade' directly to 11g. Anyway, before you upgrade to any version, you should ensure that your applications will continue to work with the new version of Oracle database.

OF course, newer version will consume more resources as compared to the version you have. So bear in mind that you may have to upgrade you hardware resources before the database upgrade.

If you need any further assistance, please let us know.

kind regards
yogeeraj

Re: Database compatibility Question

Volker Borowski — Sat, 02 Aug 2008 17:14:03 GMT

Hi,

Customer Care Support for 9.2 ended 31.07.2007.
It was extended at no additional Cost until 31.07.2008 (at least for SAP Customers).

If you want to use 9.2 right now and receive support, you need to be on extended maintanance (which will require additional cost). As far as I know, you can extend until 2010.

I'd recommend to go to 10g if your application permits.

Best regards
Volker