April 13, 2010

add opatch to your path:

PATH=$PATH:$ORACLE_HOME/OPatch

Patch 9352179 - 11.1.0.7.3 Patch Set Directions

1. OPatch utility version 11.1.0.6.7 or later

check your version of opatch:

opatch version –invPtrLoc $ORACLE_HOME/oraInst.loc

Check what patches are installed:

opatch lsinventory –details –invPtrLoc $ORACLE_HOME/oraInst.loc

 

2. Environment Checks

$PATH definition has the following executables: make, ar, ld, and nm.

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

3. One off conflict detection and resolution 

unzip p9352179_11107_<platform>.zip  opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9352179

 

4. Patch Installation Instructions

Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands

unzip p9352179_11107_<platform>.zip  
cd 9352179  
opatch apply –invPtrLoc $ORACLE_HOME/oraInst.loc

5. Post Installation Instructions

1. Apply conflict resolution patches

Apply the patch conflict resolution one-off patches from #3

2. Load modified SQL files into the database

For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script as follows: 
cd $ORACLE_HOME/rdbms/admin 
sqlplus /nolog 
SQL> CONNECT / AS SYSDBA 
SQL> STARTUP  SQL> @catbundle.sql psu apply 
SQL> QUIT

Check the following log files in $ORACLE_HOME/cfgtoollogs/catbundle for any errors:

catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log  
catbundle_PSU_<database SID>_GENERATE_<TIMESTAMP>.log

 

3. Recompile views in the database, if necessary,

If you want to check whether view recompilation has already been performed for the database, execute the following statement:

SELECT * FROM registry$history where ID = '6452863';

 

1061295.1 Patch Set Updates - One-off Patch Conflict Resolution
   
   
   
   

 

Gather statistics for SYS schema 
$ sqlplus "/ as sysdba"  
SQL> shutdown normal;  
SQL> startup restrict;  
SQL> @adstats.sql   
SQL> shutdown normal;  
SQL> startup;   
SQL> exit;  
 

 

8. Restart Applications server processes