1. 4898608 - Latest Opatch (10.2.0.3.4 )

1. 4898608 - Latest Opatch (10.2.0.3.4 )

cd /admin/orapatch/oracle/10.2.0.3/Patches/OPatch
mv $ORACLE_HOME/OPatch/ $ORACLE_HOME/OPatch_old
mkdir $ORACLE_HOME/OPatch
cp -rp * $ORACLE_HOME/OPatch/.


2. 5929784 - MLR FOR THE FIXES IN 4966417/5605370 AND 5631915 ON TOP OF 10.2.0.3

cd /admin/orapatch/oracle/10.2.0.3/Patches/5929784
opatch apply -local

3. 6358777 - MLR for 6121268 and 5998987

cd /admin/orapatch/oracle/10.2.0.3/Patches/6358777
opatch apply -local

ApplySession applying interim patch '6358777' to OH '/u01/app/oracle/product/10.2.0.3_Aug/DBEE_1'
Interim patch 6358777 is a superset of the patch(es) [ 5998987 ] in OH /u01/app/oracle/product/10.2.0.3_Aug/DBEE_1
OPatch will rollback the subset patches and apply the given patch.

The local system has been patched and can be restarted.


4. 6487758 - MLR for 6397940 and 4587572

cd /admin/orapatch/oracle/10.2.0.3/Patches/6487758
opatch apply -local

5. 6523687 - MLR for 6397948 and 5606847

cd /admin/orapatch/oracle/10.2.0.3/Patches/6523687
opatch apply -local

# After applying/rolling back the patch, you need to run following :
#

Connect sys as sysdba;
ALTER SESSION SET CURRENT_SCHEMA=MDSYS;
$ORACLE_HOME/md/admin/prvtcat.plb
$ORACLE_HOME/md/admin/prvtrtr.plb
$ORACLE_HOME/md/admin/prvtsam.plb
ALTER SESSION SET CURRENT_SCHEMA = SYS;



6. 6646853 - Jan 2008 CPU

cd /admin/orapatch/oracle/10.2.0.3/Patches/6646853
./apply_cpu_proderp_aug.sh


a> On one RAC node, start the instance and execute:

cd $ORACLE_HOME/cpu/CPUJan2008
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catcpu.sql
SQL> QUIT

b> If catcpu.sql reports any Invalid Objects, run the following commands:


cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @utlrp.sql


c> You must recompile views for all databases except the following:

To recompile the views in the database, follow these steps:

Run the pre-check script, which reports the maximum number of views and objects that may be recompiled:

cd $ORACLE_HOME/cpu/view_recompile
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @recompile_precheck_jan2008cpu.sql

Run the view recompilation script. Note that this script is run with the database in upgrade mode, which restricts connections as SYSDBA.

cd $ORACLE_HOME/cpu/view_recompile
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP UPGRADE
SQL> @view_recompile_jan2008cpu.sql

SQL> SHUTDOWN;
SQL> STARTUP;


Check the log file for any errors. The log file is in the current directory and is named: vcomp__.log

d> If any invalid objects were reported, run the utlrp.sql script as follows:

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @utlrp.sql

e> Verify that the view recompilation has been performed for the database, by executing the following statement:

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

If the view recompilation has been performed, this statement returns one row. If the view recompilation has not been performed, this statement returns no rows.