Apps R12
  • Major changes from 11i
  • R12:HTTP Debug Logging
  • Compile Apps Schema invalid objects in R12
  • Apps 11i
  • Apps Components and Architecture
  • Concurrent managers
  • Patching
  • Using AD Patch
  • Using AD Control
  • FNDCPASS utility
  • Single-node Installation
  • Multi-node Installation
  • Find Apps Version
  • Cloning
  • Upgrade 11.5.9 to 11.5.10.2
  • Upgrade from 11.5.10.2 to R12
  • Upgrading 9i to 10g with 11i
  • 11i/R12 General Topics
  • AppsDBA System Management Utilities Guide
  • Identifying Long Idle Sessions
  • Identifying High Active Sessions
  • Change hostname for EBS
  • Database 9i-10g
  • Top 99 Responsibilities of a DBA
  • General Info
  • Database Patching
  • 10g:ASM
  • 10g:Data Pump
  • 10g:Data Guard Installing
  • 10g:Rollback Monitoring
  • 10g:Flashback Table
  • Tablespace Management
  • Materialized Views
  • 10g:Enterprise Manager
  • 10g:Upgrade
  • Error:Ora-01631
  • DBA Scripts
  • Disk I/O,Events,Waits
  • Tablespace Information
  • Session Statistics
  • Hit/Miss Ratios
  • User Information
  • Rollback Segments
  • Full Table Scans
  • Contention/Locking
  • Redo Log Buffer
  • Data Dictionary Info
  • Oracle10g Application Server
  • Oracle10g Application Installation
  • (Re)Securing OAS Control
  • Oracle AS10g null protocol issue
  • Oracle Backup & Recovery
  • RMAN
  • RMAN Setup
  • Backup Recovery
  • Flash Recovery Area
  • Oracle10g Discoverer with Apps
    Coming soon ..............
    Troubleshooting
  • Discoverer Troubleshooting
  • Access EBS in mozile
  • Linux and Unix Platforms
  • How To configure NFS
  • Unix/Linux Command
  • Change hostname in Linux
  • SENDMAIL configuration
  • This Oracle Application DBA Portal is the biggest knowledge gateway for the people in the world of Oracle...
    Wednesday, April 8, 2009
    Upgrade 11.5.9 to 11.5.10.2
    Procedure followed to Upgrade 11.5.9 to 11.5.10.2

    Documents followed
    Metalink Oracle Document ID : 316365.1 – Oracle Applications Release 11.5.10.2 Main. Pack Instlation Instructions
    Instructions
    Metalink Oracle Document ID : 259484.1 - Release 11.5.10 Maintenance Pack Installation

    Reference
    216205 – Database Initilization Parameters and Conf for Oracle Apps 11i

    Basic Maintenance

    1. Check the Disk space – Minimum space required 3 – 4 GB Free space.
    2. Add additional table space for this tablespace BISD, IGFD,ARD,AHLX,OZFX,OKSX,OKCD,IGSX,PNX

    ALTER DATABASE DATAFILE ‘path/okcd01.dbf’ RESIZE 150M; / EXTEND ON etc.

    3. Check the Invalid Objects
    4. Check the Missing files
    5. Recompile Apps Schema, Forms, Reports etc
    6. Regenerate Env, Jar Files etc.
    7. Check hostname, domainname
    8. Check file-max, Limit Processors etc.
    9. Check the kernel parameters


    1. Apply latest AD utility Patch – 4712852

    2. Apply patch 4238286 – TUMS MP

    3. Apply necessary patches as reported by TUMS

    4. Apply 4709948 – Technology Stack Validation Report

    5. Apply 3072811 – Oracle HTTP server patch [Stop the apache server and apply, before applying
    a. To stop apache $COMMON_TOP/admin/scripts/sid_host/adapcctl.sh stop
    a. export ORACLE_HOME = IAS_ORACLE_HOME path
    b. ./patch.sh install
    c. Unzip oprocmgr – check
    d. Start apache -$COMMON_TOP/admin/scripts/sid_hos/adappctl.sh start

    6. In Application Tier – In context file – SID_host.xml in $APPL_TOP/admin dir
    Symbolic link pointing to $COMMON_TOP, $JAVA_TOP, PORTAL to be replaced with direct link not through symbolic link for ex.

    /erpp – is s a symbolic link to /data/erpp & is available in / file system

    In Context file it might have mentioned as /erpp/erppcomn/html to be replaced with /data/erpp/erppcomn

    7. s_html, s_javatop, s_pt,s_oemcomment,s_toplevel domain - comment these lines in SID_host.xml – Application Context file.

    8. Apply patch 4318672 – Technology Stack Validation Utility

    9. _system_trig_enabled=false – initSID.ora

    10. REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE –initSID.ora

    11. orapwd file = /erpp/erppdb/9.2.0/dbs/orapw password=admin

    12. Grant sysdba to apps

    13. perl Txkrun.pl –script –InstSSLFix

    14. Apply 4948577 – Release 6i patch 18

    15. Apply 3966092 – one off patch 8.1.7.4 – IAS_ORACLE_HOME

    16. Apply 4968700 – Additional Developer 6i patch

    17. Apply 4261542 -

    18. Apply 4888294 - Application Interoperability patch for Developer 6i patch 18

    19. Apply 2376472 - 8.1.7.4 patchset for Oracle Data Server [Application].
    [8.0.6 Oracle Database used in 11.5.9 is obsolete].

    20. Apply 4029076 - Delivery of http client.jar [1022A],OJSP 11352 provider jar and SSL patch for IAS Technology Stack.

    21. Copy perl directory from SIDora/Apache to /SIDdb/9.2.0/Apache [Problems faced in perl installation available in SIDdb directory].

    22. DIRECTORY ACCESSBILITY=FALSE – initSID.ora

    23. _B_TREE_BITMAP_PLANS=FALSE – initSID.ora

    24. ALTER TABLESPACE SYSTEM ADD datafile ‘path/system12.dbf’ size 1024M;

    25. Apply patch 5035661 – Oracle Universal Installer 2.2

    26. Apply patch 4163445 - Database upgrade 9.2.0.3 to 9.2.0.7

    27. Apply 2617419 – O Patch

    28. Apply 4483951 – Query gives wrong results in 9.2.0.7 version

    29. Ensure 750 MB Free rollback segment space is available

    30. Ensure 512 Max Extents ??

    31. Apply patch 3180164 – Migrate to New table space system followed by 11.5.10.2

    32. Apply patch 3348000 – Maintenace Pack 11.5.10.2 – CU2 patch. [After applying the patch, patch itself will take care of
    a. Compiling Invalid Objects
    b. Running Auto Config
    c. Compile Flexfield
    d. Recreate grants and synonyms
    e. Main. Multiple Reporting Currencies etc.

    33. In Application Context file of apps tier and change the following
    "s_options_symlinks" from "Options -FollowSymLinks"
    "s_options_symlinks" to "Options FollowSymLinks"

    34. Start the Application Services

    Labels:

    posted by Srinivasan .R @ 11:39 AM  
    1 Comments:
    • At May 24, 2010 at 11:53 PM, Blogger RAJ said…

      Hi,

      First of all, you have done a great job in posting so much info.

      My question is regarding

      19. Apply 2376472 - 8.1.7.4 patchset for Oracle Data Server [Application].

      Going through Patch readme, it appears we can apply patch binaries on iAS 1022 home but regarding database portion of patch, how do we handle ?

      In the readme of patch set 2376472 do we ignore the database related steps as our Applications database is on 9.2.0.8 ?

      Any help is greatly appreciated. Thanks so much
      My email is information2100@yahoo.com

       
    Post a Comment
    << Home
     
    About Me

    Name: Srinivasan .R
    Home: Chennai, India

    About Me:
    I am working as an Oracle Applications DBA specializing in EBS 11i/R12 with Over 8+ years of experience, mainly in different versions of Oracle Database & Application administration on various platforms like HP-UX, SOLARIS, AIX, Red hat Linux & Windows
    See my complete profile
    High Availability
  • Oracle10g RAC Installation
  • A Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms
  • Implementing Oracle 10g RAC with ASM on AIX
  • Locked objects for whole RAC
  • Monitor Memory RAC
  • Sessions RAC
  • Install Oracle 11g RAC On Linux
  • Migrating Oracle10g DB to ASM
  • Helpful Links
  • Good Metalink Notes
  • Discoverer:Metalink Notes
  • Logs Scripts:Metalink Notes
  • Support:Metalink Notes
  • Previous Post
  • Single-node Installation
  • Upgrade to Oracle Database 10g
  • Flash Recovery Area
  • Database Patching
  • AD Control
  • Using AD Patch
  • Patching
  • Enterprise Manager 10g
  • Materialized Views
  • RMAN
  • Archives
    Download Software
  • Oracle 11g
  • Oracle 10g
  • 10g Express Edition
  • Oracle 9i
  • Oracle Apps
  • Oracle Linux
  • Oracle VM
  • App Server
  • Solaris
  • Fedora
  • Fedora
  • OpenSUSE
  • Ubuntu
  • Advertisement Links
    INTUIT Technology

    MACHS DATA

    Add Ons
    Locations of visitors to this page

    Add to Google Reader or Homepage

    Template by
    Sreene



    Oracle Application DBA Portal