Oracle database upgrade version 10.2.0.1.0 to 10.2.0.4.0

Step 1:download the appropriate patch from my oracle support and save it.

Step 1:  Stop all running services and shutdown database.

Startàrunàtype services.mscàstop all oracle services by using this widow.

Step 2: Take the cold backup of all files...like copy /paste from base directory(oracle)

Step 3: install the download patch in the same oracle home.

Step 4:start all services like the same above,

Step 5: startup database using “startup upgrade” command

Step 6: After database open

Give this command

SQL>spool patch.log(log will store in from which user u run the script that place)

SQL>@ORACLE_HOME/rdbms/admin/catupgrd.sql(this command for upgrade the database)

SQL>spool off

(shutdown the database from restricted mode and open in normal mode)

SQL>shutdown immediate

SQL>startup

(Below script recompile the invalid objects )

SQL>@ORACLE_HOME/rdbms/admin/utlrp.sql

SQL>select * from v$version

(it display upgraded version.)