|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Apply Oracle July CPU patch |
| Monday, October 09, 2006 |
|
Last month, I Posted about Oracle CPU Patches also called as Critical patch Update or security Patch Update.
You can access that Post or Overview of CPU from below link
http://becomeappsdba.blogspot.com/2006/09/oracle-critical-patch-updates-and.html
Today & in my future posts I am going to cover How to Apply these patches in your Applications. You might be having following applications
Oracle Application Server ( 9i , 10g )
Oracle Collaboration Suite ( 9i or 10g )
Oracle E-Business Suite ( 11i )
Standalone Database (8i, 9i, 10g)
The Steps Mentioned in today's post are specific to Jul 2006 CPU patches for Application Server . This Oct. ( Mid of Month ) Oracle is going to release CPU for Oct 2006 and I'll Update you as and when they are out.
Common things to remember in almost all of CPU Patches
Order of CPU Patch
First Database
Then Application Tier
Previous CPU Patches
E-Business Suite Patches are non cumulative
Application Server, Database or Collaboration Suite CPU patches are cumulative .
1. Applying JUL CPU for 10g Application Server ( Ver. 10.1.2.0.2)
1.1 Assumptions while applying patch
Steps mentioned here are for 10g R2 Application Server version 10.1.2.0.2
Portal Schema Content is stored in separate Database Version 10.2.0.1
OID & SSO Database is stored in Database Version 10.1.0.5
Infrastructure Tier is on separate Host then Middle Tier
Middle Tier & Infrastructure Tier both are on version 10.1.2.0.2
In my application architecture , I have three oracle homes , two on machine1 ( oh_1 for database 10.2.0.1 , oh_2 for infrastructure home with another database 10.1.0.5) , third oracle home on machine2 ( oh_3 application Server Middle Tier)
Don't forget to backup before applying patch as fall back plan
Reference are taken from metalink note # 372930.1
1.2 Order of patches
Based on my configuration my order of patch application will be first database patch on oh_1 for db 10.2.0.1 on machine1
Then apply Infrastructure patch on oh_2 on machine1
Finally apply middle tier patch on oh_3 on machine2
1.3 Exact Steps for applying patches
1.3.1 Apply Database 10.2.0.1 patch
- Login to machine1 under oracle_home1 & need to apply database patch for db version 10.2.0.1 and patch number is 5225798 (This is for Unix) if you are on windows you need 5239698 for 32 bit Windows. If you are on 10.1.0.5 patch # is 5225797 & so on ... ( Check Note # mentioned above for exact patch Number )
- Download patch & shutdown services
- Lets assume you have downloaded patch to /u01/patch/cpu/jul06/5225798 then go to this directory & follow readme.txt ( Steps mentioned here from readme.txt)
- 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
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
and this complete your patch on standalone PORTAL repository database.
Same way you have to apply Jul CPU patch on standalone database .
* If your database version is different than 10.2.0.1 then patch number will vary so check note# mentioned above .
How to Apply CPU patch on Application Server Infrastructure Tier, Middle Tier ..
How to Apply CPU patch on Collaboration Suite Infrastructure & Middle Tier ..
How to apply CPU July patch on E-Business Suite ...
Coming in Next Post .......Labels: patching |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 5:26 PM
  |
|
| 17 Comments: |
-
Excellent post. Good to see "down in the trenches" Oracle stuff.
One issue I came across - our mid-tier and infra structure tiers are on MS Windows and we needed to logon with the same Windows account that performed the original SW install in order to update/upgrade Oracle Application Server.
Thankfully this account was still there even though the user had long gone.
-
Hi Atul,
Its very useful site for the newbees like me in Apps. Thanks a lot. Keep it Up.
Ravindra
-
Hi Angrydot,
I was just wondering if you were not using user who installed Application Server then how were you starting stopping services ?
As what user ?
-
I supposed that when you are talking of “Database 10.2.0.1 patch” - you are talking of Portal database. Am I correct?
“Assumptions while applying patch” – suppose we don’t know what our application architecture is. How can we find it ? Using XML config file?
-
Yes Neto,
These are specific to for portal database 10.2.0.1 but these apply to any other 10.2.0.1 database as well.
If you don't know architecture , ask for architecture diagram from person maintaining it
Atul
-
Atul,
Apart from asking what the architecture is can we find the architecture ourselves?
Thanks
-
Atul,
I want to know How to upgrade Portal 9.0.4.0 to 10.1.2 and from where to start with ? like DB and then iAS etc.
Can you please let me know about this. DB version is showing like:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.0.1.5.0 - Production
PL/SQL Release 9.0.1.5.0 - Production
CORE 9.0.1.2.0 Production
TNS for Solaris: Version 9.0.1.4.0 - Production
NLSRTL Version 9.0.1.5.0 - Production
then, what's the correct version?
Thanks
Adarsh
-
Adarsh,
If you could explain me your Application Server architecture , I can explain you how to upgarde .
Though basics steps are
First upgarde Infrastructure Tier & then
Middle Tier
You can check steps at
http://download-uk.oracle.com/docs/cd/B14099_19/sol.1012/quickupgrade.1012/quickupgrade/toc.htm
for 10.1.2.0.2 Upgrade
-
hi ,
Will you please tell me CPU critical patch list which i can apply in Oracle 11.5.10 and the steps
-
Rajat,
Please follow metalink Note # 391564.1 E-Business Suite Critical Patch Update October 2006 Note
-
What is the latest patch for Oracle? spam@starkaz.com
-
cn u provide step by steps and were to apply patch for both dbtier and appstier
-
Hello Atul,
I am fresher in oracle DBA.
I dont knw about CPU patch..But while i am learning ,ur post helped me a lot to learn how to apply cpu patches.thanks..Have a marvellous monday
-
Hello Atul,
I am fresher in oracle DBA.
I dont knw about CPU patch..But while i am learning ,ur post helped me a lot to learn how to apply cpu patches.thanks..Have a marvellous monday
-
Hi Atul,
I am an Oracle Functional Consultant and have installed R12 as per your guide. Everything works fine but I cannot save receipts of material as it gives an error saying "Please enter a GL date within Purchasing Accounting period: Eror APP-PO-14376". I have downloaded patch #p3620293. I use windows server 2003. Can you please let me know how to apply this patch so that I can proceed further. Your a help shall be appreciated.
Regards,
Uday
-
Hi Atul,
I am an Oracle Functional Consultant and have installed R12 as per your guide. Everything works fine but I cannot save receipts of material as it gives an error saying "Please enter a GL date within Purchasing Accounting period: Eror APP-PO-14376". I have downloaded patch #p3620293. I use windows server 2003. Can you please let me know how to apply this patch so that I can proceed further. Your a help shall be appreciated.
Regards,
Uday
-
Hi Atul,
I am an Oracle Functional Consultant and have installed R12 as per your guide. Everything works fine but I cannot save receipts of material as it gives an error saying "Please enter a GL date within Purchasing Accounting period: Eror APP-PO-14376". I have downloaded patch #p3620293. I use windows server 2003. Can you please let me know how to apply this patch so that I can proceed further. Your a help shall be appreciated.
Regards,
Uday
|
| |
| << Home |
| |
|
|
|
|
Excellent post. Good to see "down in the trenches" Oracle stuff.
One issue I came across - our mid-tier and infra structure tiers are on MS Windows and we needed to logon with the same Windows account that performed the original SW install in order to update/upgrade Oracle Application Server.
Thankfully this account was still there even though the user had long gone.