Apply Bundle Patch 42 for Patchset 3

Apply Bundle Patch 42 for Patchset 3
1. Cleanly shut down all processes running from the ORACLE_HOME.
2. Upgrade Opatch version for the database with Copy
3. Set the ORACLE_HOME and PATH environment variables to the correct Oracle home that needs to    be patched.

set ORACLE_HOME=C:\oracle\product\10.2.0\db_1

set PATH=C:\oracle\product\10.2.0\db_1\Opatch;%PATH%

4. cd C:\p10349197_10204_Win32\10349197
5. opatch apply
6. Start all processes running from the ORACLE_HOME.
7. run these SQLs

sqlplus /nolog
CONNECT / AS SYSDBA
STARTUP
  @C:\oracle\product\10.2.0\db_1\Bundle\Patch42\catcpu.sql
  @C:\oracle\product\10.2.0\db_1\rdbms\admin\utlprp.sql 0

To check for invalid objects, execute the following statement:
SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';

Recompile invalid Views:
SELECT * FROM registry$history where ID = '6452863';

sqlplus /nolog
CONNECT / AS SYSDBA
@C:\oracle\product\10.2.0\db_1\Bundle\view_recompile\recompile_precheck_jan2008cpu.sql
SHUTDOWN IMMEDIATE
STARTUP UPGRADE
@C:\oracle\product\10.2.0\db_1\Bundle\view_recompile\view_recompile_jan2008cpu.sql
SHUTDOWN IMMEDIATE
STARTUP