Register for Apps DBA Training
For Apps DBA Beginner's
  • Start From Here
  • Order of Apps Study
  • 11i Software
  • Apps Architecture
  • Install Apps 11i
  • Install Apps 11i Part II
  • Startup/Shutdown
  • Request Flow in Apps
  • Various TOP's
  • Cloning Basics
  • Cloning I
  • Cloning II
  • Autoconfig Basics
  • Autoconfig Config File
  • Template Files in Autoconfig
  • Discoverer Overview
  • Workflow Mailer in Apps
  • Printing Overview
  • Configuring Printers
  • Pasta Printing
  • Performance Overview
  • Install 10g Application Server
  • Apps DBA Certification
  • Common DBA Topics
  • Scared of RAC ?
  • Install RAC on your laptop part I
  • Step by Step build RAC part II
  • Step by Step install RAC using VMWare part III
  • Install Oracle RAC Database part IV
  • oraInventory Basics
  • Install Database 10.2.0.1
  • Upgarde DB to 10.2.0.2
  • Fusion
  • Is Fusion a conFusion ?
  • Fusion Middleware Overview I
  • Fusion Middleware Overview II
  • Application Integration Architecture
  • SOA Install Part I
  • SOA Install Part II
  • SOA Install Part III
  • Install BPEL Process Manager
  • Apps Integration OID/SSO
  • Management Qs for Apps Integration with SSO/OID
  • 25 things your DBA should know for Apps/SSO integration
  • Identity Management
  • COREid Overview
  • Oracle COREid or Idm & Access Mgmt overview
  • Installing Access Manager 10.1.4
  • WebGate request flow
  • Identity Manager Architecture
  • Installing Identity Manager
  • OAS-SSO Overview
  • OID Overview
  • OID Basics II
  • OID Cluster
  • OID Integration with Other LDAP Servers overview
  • Integrate OID with AD I
  • OID Replication Overview
  • Multi Master OID Replication
  • Migrate OID/SSO to new Host
  • Apps R 12
  • Socket or Servlet in R12
  • Startup/Shutdown Scripts in R12
  • Unified APPL_TOP
  • Apps R 12.0.1
  • Difference between 11i & R12 Technical
  • Prepare for R12 Installation
  • Install VMWare on Windows for Linux Install
  • Install Linux for Apps R12 Install
  • Install Apps R12 on Linux Virtual Machine
  • R12 Upgrade & database
  • R12 Fils System Changes
  • R12 Release Date
  • 10g Application Server
  • 10g AS Overview
  • Installing 10g AS
  • Start/Stop 10g AS
  • Web Cache Basics
  • Single Sign-On Overview
  • OID Overview
  • Cloning 10g AS
  • 10g AS Middle tier Cloning & Overview
  • OID Cluster Imp. Points
  • CPU Patch, Infra Tier
  • CPU Patch, Middle Tier
  • AS Guard / DR Overview
  • Oracle Apps 11i
  • My Site
  • Apps DBA Scripts
  • Apps DBA Interview Q's
  • 11i JVM's
  • Apps Training in India
  • 11i Health Check
  • Good Metalink Notes
  • About Me  
  • For Advanced Apps DBA
  • URL Firewall in DMZ Setup
  • Upgrade Apps to 11.5.10.2
  • Load Balancer Overview
  • Load Balancer Config
  • HTTP layer Load balancing in Apps 11i
  • Dataguard Overview
  • Configure Dataguard / Standby database
  • Standby Site for Apps 11i
  • How to change Hostname on Apps Instance
  • SSL Overview in Apps
  • Configure SSL to Web Server
  • Key Points for SSL in Apps
  • Reduce Patch Timing
  • Reduce Patch Timing II
  • Shared APPL_TOP Overview
  • Configure Shared APPL_TOP
  • 11i Database Upgrade I
  • 11i Database Upgrade II
  • Change Session TimeOut
  • Patching
  • Apps Patch Basics
  • Apps Patch Basics II
  • Apply Apps Patch
  • CPU Overview
  • Steps to Apply CPU Patch
  • CPU Patch on Infra Tier
  • CPU Patch on AS Middle Tier
  • Troubleshooting
  • Web Server TS Part I
  • Web Server TS Part II
  • CM Troubleshooting
  • 10g Discoverer with Apps
  • Discoverer Bascis in Apps
  • Discoverer 10g Upgarde Basics
  • Discoverer 10g Configuration Steps with 11i
  • Collaboration Suite
  • Collaboration Suite
  • Calendar Overview
  • Sync Calendar from Mobile I
  • Sync Calendar from Mobile II
  • OCS Mail Architecture
  • Apex / HTMLDB
  • Install Apex 2.2
  • Apex with SSO part I
  • Apex with SSO part II
  • SSO Authentication Schemes
  • Certification
  • Possible Certifications for DBA
  • Apps DBA Certification
  • 1Z0-311-OCA-10g OAS Overview
  • 1z0-312-OCP-10g OAS Overview
  • 1z0-312 - Managing Customization and Topology
  • 1z0-312 - Cloning and Staging OAS
  • Apps DBA Jobs
  • Working / Apps DBA in UK
  • Oracle Recruiting Apps DBA's
  • Apps DBA Jobs Updated Regularly
  • Apps Job at Satyam
  • Useful Links
  • Good Metalink Notes
  • petefinnigan's Oracle Security
  • Linux Basics
  • Atul Mehta's Oracle Links
  • Others
  • Apps DBA Training Institute
  • 1 Year Journey of this Blog
  • How To ?
  • Change APPS Password
  • Preserve Customizations
  • Blog Roll
    Apps / E-Business Suite
  • Steven Chan Apps
  • Anil Passi Technical
  • Fadi Apps DBA
  • Senthil Apps DBA
  • Bas Klaassen EBS DBA
  • Sam Apps DBA
  • Black Geek Apps DBA
  • Bandari Apps
  • Vikram ERP Architect
  • OraBiz
  • Eric Core DBA
  • SOA
  • Navdeep Saini Apps DBA
  • tugdualgrall Web Services
  • Mohan Dutt's Apps Certification
    IdM
  • Nishant Kaushik's IdM
  • Nulli Blog, OAM
  • Identity Musing
  • Identity nd Access Management
    Core DBA
  • Vidya Bala DBA
  • Sabdar DBA
    Data Management
  • Ivan Pellegrin Data Management


  • We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Apply Oracle July CPU patch
    Monday, October 09, 2006
    Register for R12 upgrade
    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:


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 5:26 PM  
    17 Comments:
    • At 11:25 PM, Anonymous Angrydot said…

      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.

       
    • At 10:18 AM, Anonymous Anonymous said…

      Hi Atul,
      Its very useful site for the newbees like me in Apps. Thanks a lot. Keep it Up.
      Ravindra

       
    • At 11:56 PM, Blogger Atul Kumar said…

      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 ?

       
    • At 4:43 PM, Anonymous agostino_neto said…

      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?

       
    • At 7:59 AM, Blogger Atul Kumar said…

      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

       
    • At 2:03 PM, Anonymous agostino_neto said…

      Atul,
      Apart from asking what the architecture is can we find the architecture ourselves?
      Thanks

       
    • At 2:23 PM, Anonymous Anonymous said…

      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

       
    • At 3:09 PM, Blogger Atul Kumar said…

      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

       
    • At 7:22 AM, Anonymous rajat said…

      hi ,

      Will you please tell me CPU critical patch list which i can apply in Oracle 11.5.10 and the steps

       
    • At 7:36 AM, Blogger Atul Kumar said…

      Rajat,
      Please follow metalink Note # 391564.1 E-Business Suite Critical Patch Update October 2006 Note

       
    • At 6:34 AM, Anonymous Anonymous said…

      What is the latest patch for Oracle? spam@starkaz.com

       
    • At 11:11 PM, Blogger Sudhakar said…

      cn u provide step by steps and were to apply patch for both dbtier and appstier

       
    • At 9:39 AM, Blogger ranjani said…

      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

       
    • At 9:39 AM, Blogger ranjani said…

      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

       
    • At 6:17 PM, Blogger Uday said…

      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

       
    • At 6:18 PM, Blogger Uday said…

      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

       
    • At 6:19 PM, Blogger Uday said…

      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

       
    Post a Comment
    << Home
     
    About Me


    Name: Atul Kumar
    Home: London, United Kingdom

    About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
    atul @ onlineappsdba.com

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Search
    Only search this Blog
    Categories
  • Advanced Topics
  • Application Server
  • Apex / HTMLDB
  • Apps 11i
  • Apps R12
  • Autoconfig
  • Basics
  • Certification
  • Cloning
  • Discoverer
  • Fusion
  • OID
  • Patching
  • Printer
  • Single Sign-On
  • Useful Sites & Forum
  • Previous Post
    Archives
    Add On
     

    Add to Technorati Favorites

     

     

    Add to Google

     

    Add to My AOL

     

    Subscribe in Bloglines

     

    Subscribe in NewsGator Online

     
    Powered by



    Hits Since 30, Jul 06

    Blog Counter

    Technology Blogs - Blog Top Sites
    Comments
    ADs
    Copyright © 2006 teachmeoracle.com All rights reserved Presented by Atul Kumar