Upgrade Oracle 9.2.0.1 to 9.2.0.4 Options

[Tanvi Agrawal]

Hi,

I want to know the detailed steps for the Upgradation of database from Oracle 9.2.0.1 to 9.2.0.4?

[RHR]

There is already plenty of documentation for performing this available from the vendor.

Oracle 9i was desupported way back in 2007. Have you considered an upgrade to 10g or 11g?

http://www.remote-dba.net/t_oracle_9i_de_supported.htm

RHR

[burleson]

Hi Tanvi,

>> Upgradation

Upgradation IS NOT an English word!

>> want to know the detailed steps for the Upgradation of database from Oracle 9.2.0.1 to 9.2.0.4?

It's a standard upgrade, the same as any other erelease.

Follow the steps in the 9i upgrade installation guide, available from Oracle:

http://support.oracle.com

[Tanvi Agrawal]

Hi ,

Actually I want to upgrade my database from Oracle 9.2.0.1 to Oracle 10.2.0.1. I found out that for this purpose first I have to upgrade to 9.2.0.4.
If you can give the solution for Oracle 9.2.0.1 to Oracle 10.2.0.1. directly, then that would be awesome.

[SteveC]

Read the upgrade guide for the version you are upgrading to. Oracle lists the supported paths. If you need to go from 9.2.0.1 to 9.2.0.4, then read the README for the 9.2.0.4 patchset. Then read the upgrade guide for 10.2.0.1. It is not worth repeating entire documents here in a forum.

You can also visit My Oracle Support and look for the "Complete checkllst..." for upgrading to release 10.2.