Download
* Download patch 6810189 from metalink, e.g. p6810189_10204_Win32.zip.
* Unzip.
* Read README.html for upgrade details.
Install
* Stop all Oracle related services.
* Click setup.exe to start installer.
Installer Wizard
* Specify Home Details
Name: OraDb10g_home1 Path: C:\prog\oracle\product\10.2.0\db_1
* Click ‘Next’ buttons until ‘Install’ button is enabled.
* Click ‘Install’ button to start the install process.
* Click ‘Exit’ button to exit the installer.
Post Install
* Start tns listener.
* Start Database Upgrade Assistant
Oracle – HOME_NAME -> Configuration and Migration Tools -> Database Upgrade Assistant
Database Upgrade Assistant Screen
* Select database to be upgraded (e.g. orcl) and click next
* Click ‘Yes’ when prompted if continue due to invalid objects error.
* Select ‘Do Not Move Database Files as Part of Upgrade’
* Select ‘Recompile invalid objects at the end of upgrade’
* Select ‘I would like to take this tool to backup the database’.
– Backup directory ‘C:\prog\oracle\product\10.2.0\admin\orcl\backup’
* Select ‘Specify Flash Recovery Area’
– Flash Recovery Area: C:\prog\oracle\product\10.2.0/flash_recovery_area
– Flash Recovery Area Size: 2048
* Click Finish on summary screen.