Critical Patch Installation

Critical Patch Installation in 10.2.0.3

1. Patch Set Overview

Patch release 10.2.0.3. Before installing this patch set you must be need 10.2.0.3 version.

2. Requirements

Oracle DB : Oracle 10.2.0.3
Operating System: Windows 2000 (Service Pack 2 or higher)


1. Stop all services

C:\>set oracle_sid=samidb

C:\>net stop OracleDBConsoleSamidb
The OracleDBConsolesamidb service is stopping...........
The OracleDBConsolesamidb service was stopped successfully.


C:\>net stop OracleServiceSamidb
The OracleServicesamidb service is stopping.
The OracleServicesamidb service was stopped successfully.


C:\>net stop OracleOraDB10g_Home1iSQL*Plus...
The OracleOraDb10g_home1iSQL*Plus service was stopped successfully.


C:\>net stop OracleOraDb10g_home1TNSListener
The OracleOraDb10g_home1TNSListener service is stopping.
The OracleOraDb10g_home1TNSListener service was stopped successfully.


Note: while patch installation time we need to stop Distributed Transaction Coordinator. It’s not oracle related but you should be stop this service.

C:\>net stop msdtc
The Distributed Transaction Coordinator service is stopping.
The Distributed Transaction Coordinator service was stopped successfully.

3. How to check previous patch

C:\>set oracle_sid=samidb

C:\>set oracle_home=d:\oracle\product\10.2.0\db_1

C:\>d:

D:\>cd d:\oracle\product\10.2.0\db_1

D:\oracle\product\10.2.0\db_1>cd opatch

D:\oracle\product\10.2.0\db_1\OPatch>opatch lsinventory
….
….
….
4. Take complete backup.

Before installing patches we should take complete database cold backup. And take backup for OraInventory folder (It’s available in operating system drive).
5. How to install patch
C:\>set oracle_sid=samidb

C:\>set oracle_home=d:\oracle\product\10.2.0\db_1

C:\>d:

D:\>cd d:\oracle\product\10.2.0\db_1

D:\oracle\product\10.2.0\db_1>cd opatch

D:\oracle\product\10.2.0\db_1\OPatch>opatch apply E:\ 6637237
……
…..
…..

6. Start all Oracle Services including MSDTC

Once patch installation successfully completed. You need to start all oracle services including Microsoft Distribution co-ordinate (MSDTC)

7. Post installation
For each database instance running out of the ORACLE_HOME being patched, connect to the database using SQL*Plus as SYSDBA and run catcpu.sql as follows:
> cd %ORACLE_HOME%\CPU\CPUJan2008
> sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catcpu.sql
SQL> SHUTDOWN
SQL> QUIT

5. Compile Invalid Objects

If catcpu.sql reports any Invalid Objects, compile the invalid objects as follows.
(For large numbers of objects, this compilation step can take some time. If you are applying this patch through the Oracle Enterprise Manager console, you will be prompted to run this compilation script.)
> cd %ORACLE_HOME%\rdbms\admin
> sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlprp.sql 0