How to apply CPU patch

How to apply CPU patch

How to Apply SPU Patch

CPU Patch Apply Procedure:

Before applying the patch make sure all backups are in place.

cpu patch location on server1
/opt/oracle/July2010/9655017

Step 1) take the below commands outputs. 

SQL>select name from v$database;
SQL>select * from registry$history;
SQL>select * from v$version;
SQL>select * from dba_registry_history;
SQL>select count(1) from dba_objects where status like 'I%';
SQL>SELECT OBJECT_NAME,OBJECT_TYPE,owner FROM DBA_OBJECTS WHERE STATUS= 'INVALID';
$cd $ORACLE_HOME/OPatch
$opatch version
$opatch lsinventory

Step 2) Shut down the database & stop the listener.

Step 3) check the iventory path and make sure the inventory path should be point correct inventory.

Step 4) use below commands and take the home and inventory backups.
cd /oracle10g/PRDRCD1/product/10.2
tar cvf - .|gzip -c > /path/back_home/home_dbname_`hostname`_`date +%Y%m%d`.tar.gz
cd /inventorypath/product/10.2/inventory
tar cvf - .|gzip -c > /path/oraInvent_dbanem_`hostname`_`date +%Y%m%d`.tar.gz

Step 5)take the OPatch backup.
cd $ORACLCE_HOME
cp OPatch OPatch_bak

Step 6) unzip the p6880880_102000_SOLARIS64.zip under ORACLE_HOME

Step 7) go to CPU patch directory and apply the CPU patch
cd /opt/oracle/July2010/9655017
export PATH=$PATH:/usr/ccs/bin
export PATH=$ORACLE_HOME/OPatch:$PATH:.
opatch version
opatch napply -skip_subset -skip_duplicate

Step 8) Run catbunle.sql
cd $ORACLE_HOME/rdbms/admin
sqlplus /'as sysdba'
startup
@catbundle.sql cpu apply

Step 9) run the utlrp.sql

Step 10) excute the below statement
SQL>SELECT * FROM registry$history where ID = '6452863';
if that statement returns no rows please execute below commands
$cd $ORACLE_HOME/cpu/view_recompile
$sqlplus /'as sysdba'
SQL>@recompile_precheck_jan2008cpu.sql
sql>shut immediate
startup upgrade
@view_recompile_jan2008cpu.sql
shut immediate

startup
@utlrp.sql

10) perform 1st step for taking patch information.

-----------------------------------------------

Send Gifts to India by http://amazegifts.com

Gifts To India

 -----------------------------------------------