Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged database oracle oracle10g database-administration or ask your own question.

Oracle 9I For Windows 8 Upgrade Guide From

You should not use this article in replace of the official upgrade guide from Oracle.

Manual upgrade is the method that I often use because it gives you control of all the upgrade process but keep in mind that oracle always recommends the use of DBUA because is easier, covers all the things for you and everything is automated.

Although the upgrade process is similar for windows, there are few extra steps to be done on this platform.

Im going to use rman, but you could use any method you consider.

We must create a new listener in the new home at will hold the new version.

In my case only was necessary to change compatible to a higher value than 10.1.0.

Startup the instance using this parameter file in nomount state and create a spfile from this file.

This script is located at the same location of the first one.

Lets run the final script, catuppst.sql located at ORACLEHOMErdbmsadmin.

In this environment I have grid infrastructure installed, so the next output is from that listener.

Oracle 9I For Windows 8 Update The Time

Another step after the upgrade is to update the time zone from version 1 to version 14.

Oracle 9I For Windows 8 64 Bit