Oracle CPU Patch July for application Server Contd…

If you are reading this post directly then first read post listed at

http://becomeappsdba.blogspot.com/2006/10/apply-oracle-july-cpu-patch.html

So lets continue with Oracle CPU patch for July , yesterday I updated steps to install patch for Portal Database (Remote Database ) Installed using Rep CA .

1.3.2 Apply Application Server patch on infrastructure Tier
—In Application Server Infrastructure consist of OID+SSO & database to store metadata for OID & SSO.
—Patch number mentioned here are for Infrastructure version 10.1.2.0.2 with database version 10.1.0.5
— The patch number for 10g Infra tier with database 10.1.0.5 is 5225797 but in order to apply this patch you should be on opatch version 1.0.0.0.55 . If you are not sure how to check opatch version Click Here
— Apply opatch version 1.0.0.0.55 patch
— Install Patch 5225797 , assume you have downloaded patch at /u01/patch/cpu/jul06/5225797 then go to that directory and
— opatch apply (If you encounter opatch not found then include it in path like export PATH=$PATH/$ORACLE_HOME/OPatch as opatch is in $OH/OPatch Directory)
You should see OPatch succeeded Then
— sh /u01/patch/cpu/jul06/5225797/cpu_root.sh from root
—cd $ORACLE_HOME/cpu/CPUJul2006
—sqlplus “/as sysdba”
—SQL> startup ( Start database )
—SQL> spool catcpu.log (to store output of catcpu.sql in log file)
—SQL> @catcpu.sql
—SQL> @?/rdbms/admin/utlrp.sql ( Compile Database Objects)

This will complete your Installation but if you try to start ldap server after this your OID will not compe up. This is because oid library files in $OH/lib32 folder were overwritten by database patch . Follow metalink note # 361800.1

This Complete your Jul CPU patch on Infrastructure Tier .

In order to apply CPU patch on Application Tier on AS version 10.1.2.0.2 patch number is 5249970. When you try to apply this patch on Middle Tier you might encounter error like

MISSING_COMPONENT : oracle.rsf.rdbms_rsf, 10.1.0.5.0
or
MISSING_COMPONENT : oracle.rsf.rdbms_rsf, 10.1.0.4.0
Depending on your Infarstructure Database Version .

Why you get this error ?
How to apply CPU Patch on 10g Application Server Middle Tier ?
How to apply CPU patch on E-Business Suite ?

Coming in next post …

Oracle CPU Patch July for application Server Contd…

About the Author Atul Kumar

Leave a Comment:

2 comments