How to upgrade from an Oracle 10g 10.2.0.3 to 10.2.0.4 Database on MS Vista

Here you go
The patch No. is 6810189
Step 1). download the pacth from metalink. the file name for solaris is p6810189_10204_win32.zip
Step 2). Extract the file using unzip utilities p6810189_10204_win32.zip
Step 3). Stop all services
         i) shutdown database (using: connect / as sysdba and shutdown immediate )
         ii) Shutdown listener (using lsnrctl stop)
        iii) emctl stop dbconsole  (if dbconsole is configured and running).
       iv). isqlplusctl stop (if isqlplus is configured and running)
Step 4). Start Oracle Universal Installer located in the unzipped area of the patch set. For example, Oracle_patch\setup.exe
select the proper Oracle home and click next ..... next ... next
On the Summary screen, click Install. When the installation is complete, the End of Installation screen appears. On the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal Installer.

Step 5). startup the listener.  (lsnrctl start )
Step 6). Start the Oracle Database Upgrade Assistant:
From the Start menu, select Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools and then Database Upgrade Assistant to start the Oracle Database Upgrade Assistant.
On the Welcome screen, click Next.
On the Databases screen, select the name of the Oracle Database that you want to update, then click Next.
On the Recompile invalid objects screen, select the Recompile the invalid objects at the end of upgrade option, then click Next.
If you have not taken the back up of the database earlier, on the Backup screen, select the I would like to take this tool to backup the database option, mention the Path, then click Next.

On the Summary screen, check the summary, then click Finish.

On the End of Upgrade screen, click Exit, then click Yes to exit from Oracle Database Upgrade Assistant.

Step 7). Restart the database:

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.

SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql


Note:

When the 10.2.0.4 patch set is applied to an Oracle Database 10g Standard Edition database, there may be 54 invalid objects after the utlrp.sql script runs. These objects belong to the unsupported components and do not affect the database operation.
Ignore any messages indicating that the database contains invalid recycle bin objects similar to the following:

BIN$4lzljWIt9gfgMFeM2hVSoA==$0

 


Run the following command to check the status of all the components after the upgrade:

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

In the output of the preceding command, the status of all the components should be VALID for a successful upgrade.