Apply CPU/PSU patches:

Apply CPU/PSU patches:

$ .oraenv

ORACLE_SID:prod

SQL> sqlplus “ / as sysdba”

SQL> shutdown immediate

$ lsnrctl stop <listener_name>

$unzip p919293_1024_linux86.zip

$ cd p919293     create directory  same patchset number

$ opatch apply     os level oracle binary  apply the patches

$opatch lsinventory  in ur db what r the patches u applied and  date & time to be list out.

$ .oraenv

ORACLE_SID:prod

$ cd $ORACLE_HOME/rdbms/admin

$ sqlplus /nolog

SQL> connect / as sysdba

SQL> startup

SQL> @?/rdbms/admin/catbundle.sql psu apply 11g upto this steps enough,  10g or <10g u continue following below steps.

--

SQL> @?/cpu/view_recompile/recompile_precheck_jan2008cpu.sql

SQL> shutdown immediate (ddc table invalid means)  (how many ddc table invalid count display)

SQL> connect / as sysdba

SQL> startup upgrade

SQL> @?/cpu/view_recompile/view_recompile_jan2008cpu.sql

SQL> shutdown;

SQL> startup

SQL> @?/rdbms/admin/utlrp.sql  incase ur db object invalid - u run the script

SQL> alter package schemaname.packagename compile;

SQL> select * from dba_registry_history; in ur db what r the patches u applied and  date & time to be list out.