Apply Patch set 10.2.0.4

- Stop all oracle components " Services " running like LISTENER, EM , ISQLPLUS and DB itself etc.

- Take a backup of Oracle Home and Database

- Install the patchset 10.2.0.4

- startup upgrade


spool c:\pre_upgrade.log

@C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlu102i.sql

spool off

spool c:\upgrade.log

@C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\catupgrd.sql

spool off

shutdown immediate

startup

spool c:\recompile.log

@C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlrp.sql

spool off


set lines 10000
set pages 1000
column comp_name format a40
column version format a12
column status format a6
select comp_name, version, status from sys.dba_registry;