If you are planning to upgrade from Oracle9i Release 2 to Oracle 10g Release 2, you must be at Oracle 220.127.116.11 or higher to go directly to 10gR2. This information can be found in the Oracle Database 10g Release 2 (10.2) Upgrade Guide.
If you do not want to first patch your 9i binaries to 18.104.22.168, you can investigate using export and import to upgrade your database to 10g. This choice would depend on how large your database is. If you have a fairly small database, using export and import may be a good choice.
There are many new features in Oracle 10g which you might want to read about in the Oracle Database 10g Release 2 (10.2) New Features Guide.
Even though you may not be able to utilize many of the new features in 10g, it is a good idea to remain at a supported database release. Having said that, it appears that Oracle 9.2 now has extended support until July 2010 and 10gR2 until July 2013. Click here for more information about Oracle's lifetime support policy.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.