Applying October 2010 Critical Patch Update

Applying October 2010 Critical Patch Update

1. Pre-patch Tasks (Before the day of the patch)

1.1 Send a notification email to the Application Team and appropriate distribution lists (at least 2 days before)

1.2 Make sure you can sudo to root on the server

1.3 Download and Extract the Patch Software from the Remote Desktop machine (3.156.180.175). The patch zip file is located on c:\temp\cpu directory.

1.4 Read the Patch Set Notes

2. Pre-patch Tasks (During the day of the patch)

2.1 Create the ISR or start the RFC

2.2 Put the database in Blackout Mode in OEM

2.3 Make sure the full database backup from the previous night ran successfully (check the RMAN backup logs on /usr/openv/netbackup/scripts)

2.4 Send notification email before shutting down the database

2.5 Set the ORACLE_BASE, ORACLE_HOME and ORACLE_SID environment variables

$ . setdb.sh SID or

$ export ORACLE_BASE=Oracle_base

$ export ORACLE_HOME=Oracle_home

$ export ORACLE_SID=sid

2.6 Check for any invalid objects

$ sqlplus '/ as sysdba'

SQL> select owner, object_type,object_name, status from dba_objects where status='INVALID' order by 1,2;

SQL> select comp_name, version, status from dba_registry;

2.7 Check the shrept.lst file exists. The opatch will fail if this file is missing.

$ cd $ORACLE_HOME/network/admin

$ ls -l shrept.lst

2.8 Stop all processes (make sure the backup is not running before shutting down the database)

$ lsnrctl stop Listener_name

$ sqlplus '/ as sysdba'

SQL> shutdown immediate

2.9 Backup the System

$ cp -pr /nbcop110_oracle/10.2 /dcss_wrk/donotdelete_p110_backups/ORACLE_HOME_BACKUP/

$ cp -pr /oracle_asm /dcss_wrk/donotdelete_p088_backups/ASM_HOME_BACKUP/

$ cp -pr /oracle/oraInventory /dcss_wrk/oraInventory_bak

3. You must use the OPatch 10.2 version 10.2.0.4.8 or later to apply this patch. If you need to upgrade OPatch, perform the following steps

3.1 Copy the p6880880_102000_platform.zip file to the ORACLE_HOME and unzip directly under the ORACLE_HOME

3.2 Check that the version of the opatch utility is 10.2.0.5

$ opatch version

3.3 Delete the zip file

3.4 The first time you run opatch, it will ask for your email address, password and proxy specification information. You can enter your email address, skip the password and enter NONE on the proxy specification.

4 Apply Patch 9952272

4.1 Ensure that the $PATH has the following executables: make, ar, ld and nm. The location of these executables depends on your operating system. On many operating systems, they are located in /usr/ccs/bin, in which case you can set your PATH as follows:

$ setenv PATH "${PATH}:/usr/ccs/bin" or

$ export PATH=$PATH:/usr/ccs/bin

4.2 Set your current directory to the directory where the patch is located and then run the Opatch utility b entering the following commands:

$ unzip p9952272_10204_<platform>.zip

$ cd 9952272

$ $ORACLE_HOME/OPatch/opatch napply -skip_subset -skip_duplicate

4.3 You may see the error below which means the ORACLE_HOME is missing from the Central Inventory.

List of Homes on this system:

Home name= nbcos120_10g_home, Location= "/nbcos120_oracle/10.2"

OPatchSession cannot load inventory for the given Oracle Home /nbcod109_oracle/10.2. Possible causes are:

No read or write permission to ORACLE_HOME/.patch_storage

Central Inventory is locked by another OUI instance

No read permission to Central Inventory

The lock file exists in ORACLE_HOME/.patch_storage

The Oracle Home does not exist in Central Inventory

UtilSession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73

Run the following command to check if the ORACLE_HOME is registered in the Central Inventory.

$ opatch lsinventory -all

If the ORACLE_HOME is missing from the Central Inventory, you need to register/attach the ORACLE_HOME information to the existing Central Inventory using the following command.

$ cd $ORACLE_HOME/oui/bin

$ ./attachHome.sh or

$ ./runInstaller -silent -attachHome \ ORACLE_HOME=$ORACLE_HOME \ ORACLE_HOME_NAME="Name_Of_The_Oracle_Home"

Re-run the opatch command.

4.4 Should OPatch return conflicts or subsets, Enter "y" to run opatch to perform a partial CPU installation.

Invoking OPatch 10.2.0.5.0

Oracle Interim Patch Installer version 10.2.0.5.0

Copyright (c) 2010, Oracle Corporation. All rights reserved.

UTIL session

Oracle Home : /nbcod075_oracle/10.2

...