This presentation is for informational purposes only and may not be incorporated into a contract or

1
This presentation is for informational purposes
only and may not be incorporated into a contract
or agreement.
2
The following is intended to outline our general
product direction. It is intended for
information purposes only, and may not be
incorporated into any contract. It is not a
commitment to deliver any material, code, or
functionality, and should not be relied upon in
making purchasing decision. The development,
release, and timing of any features or
functionality described for Oracles products
remains at the sole discretion of Oracle.
3
(No Transcript)
4
Ric GinsbergVice President Oracle Corporation
This presentation is for informational purposes
only and may not be incorporated into a contract
or agreement.
5
Improving Maintenance and Reducing Patching
Downtime in 11i Session ID S782
This presentation is for informational purposes
only and may not be incorporated into a contract
or agreement.
6
Topics

• Patching Best Practices
• Maintenance Improvements
• Oracle Applications Manager
• Maintenance Initiatives

7
Best Practices

• Keep up-to-date on latest AD/OAM code
• Schedule periodic, proactive maintenance
• Combine patches with AD Merge Patch
• Perform uptime maintenance
• Gather schema stats
• Apply translation database updates
• Patch help system
• Select data migrations
• Use a Shared Application Tier File System and
  Distributed AD
• Use a Staged APPL_TOP
• Use cheaper, faster hardware

8
Shared Application Tier File System and
Distributed AD
adpatchworkers 1-10
adpatchworkers 1-10
Admin/CMServer
adpatchworkers 1-10
FormsServer
adpatchworkers 1-10
DatabaseServer
WebServer
adpatchworkers 1-10
WebServer
9
Staged APPL_TOP
Production

• Apply patches
• Copy files
• Link executables
• Compile jsps
• Generate jarfiles
• Update database
• Generate Forms
• Generate Reports
• etc.

10
Cheaper, Faster Middle-tier Hardware

• Linux RHAS 3.0, SLES 8
• 2 CPU / 6GB with shared storage
• Shared Application Tier File System (merge
  APPL_TOP process now available)
• Linux Migration Process

11
Linux Migration Process

• Migrate middle-tier in about 13 easy steps
• Only a few minutes of downtime
• Retains current patch level
• Retains many customizations
• Includes tech stack upgrade

12
Linux Migration Process
Port-specific files
Generic files
ARU/MetaLink
Old System(Windows/Unix)
Tech stack
New Linux Middle Tier
Rapid InstallTechstack CDs
13
Maintenance Improvements

• Patching Enhancements
• Quality Improvements
• Translation Improvements
• Configuration Management

14
Previous 11i Patching Enhancements

• Reduced AD overhead
• Increased parallelism
• Loader performance improvements
• Significant tuning of upgrade scripts
• Checkfile feature
• Automatic job deferral

15
Previous 11i Patching Enhancements (continued)

• Unified Driver
• Password Hider
• Manual Step Elimination
• Discoverer Integration with AutoPatch

16
New 11i Patching Enhancements

• 11i10
• Elimination of MRC schema
• Continued tuning of upgrade scripts
• Pre-Downtime data migrations
• Merge APPL_TOP
• Multi to Single node cloning

17
New 11i Patching Enhancements

• AD Minipack I
• AD Merge Patch zip support and metadata based
  merge
• AutoConfig Integration with AutoPatch
• Parallel Index Creation
• Improved Distributed AD
• Maintenance Mode
• Improved Patch UI in OAM
• RAC Support for Rapid Clone

18
(No Transcript)
19
(No Transcript)
20
Proof Point

• 200 GB database with 2 languagesupgraded to
  11i.10 in just under 5 hours

21

• System tuned for upgrade
• SGA, Redo, etc.
• Pre-downtime migration for OKS
• Saves up to 7 hours
• On-Demand Dedicated Upgrade Servers
• 4 Dell 2850 middle tiers (Shared Application Tier
  File System)
• 1 Dell 6650 Database node
• Cuts the upgrade time in half
• Distributed AD
• 10-20 on DB, 75 on generate
• Staged Appltop
• Eliminates filesystem update time
• Hot patch translations and online help.

22
11i Quality Improvements

• Internal standards compliance checker
• SQL Repository
• WinRunner based automated testing infrastructure
• Release Engineering process changes
• Earlier Product integration
• Pre-release testing
• Translations (by countries)
• OCS/EBSO business flows
• Internal production instances
• Specific large customers

23
11i Software Translation Improvements

• Simultaneous software release of all languages
  for all patchsets
• Translation escalation process for patches
• Merged translations for immediate availability
• Continued improvement in translation quality

24
Configuration Management
AutoConfig
25
Context File Management
26
Edit Context Values
27
Configuration History
28
Compare and Restore Settings
29
Custom Parameters
30
Add Custom Parameters
31
Edit Custom Parameter Values
32
Configuration Wizards
33
Configuration Wizards
34
Configuration Wizard Example
35
OAM Patch Information
36
Search Patches
37
Advanced Patch Search
38
Patch Details
39
Files Copied
40
Action Summary
41
Timing Details
42
Job Timing Report
43
Exception Report
44
OAM Patch Timing Reports
45
View Timing Reports
46
In Progress Timing Report
47
OAM Patch Wizard
48
Download Patches
49
Recommend Patches
50
Recommendation Results
51
Impact Summary
52
File Details
53
Applications being Patched
54
Diagnostic Tests to Run
55
Affected Menus and Responsibilities
56
Affected Menu Navigation Paths
57
OAM Cloning Home Page
58
Express Cloning Step 1
59
Express Cloning Step 2
60
Advanced Cloning
61
Advanced Cloning - Ports
62
Advanced Cloning Data Purge
63
Advanced Cloning - Diagnostics
64
Maintenance Initiatives
65
Patch Utility Enhancements

• Support for Required Code levels
• Flagged Files
• Patch Wizard Enhancements
• Aggregate impact analysis
• Patch dashboard
• View log files
• Improved recommendations
• Translation Synchronization Patch
• Manual Step Infrastructure

66
Long-term Initiatives

• Maintenance Utilities
• EM Integration
• Provisioning (Install/Clone/Refresh)
• AutoConfig
• Patch initiation
• Fully Distributed AD
• Change Management System

67
Long-term Initiatives (continued)

• Maintenance Downtime Reduction
• Hot patching for significant portions of patch
• Use of RDBMS parallel slaves for data
  transformation
• Cloning improvements
• Data transformations (scrambling)
• RMAN integration
• Data Reduction

68
MetaLink Information Note IDs Cloning Oracle
Applications 11i / FAQ 230672.1 /
216664.1 Using Autoconfig / FAQ
. 165195.1 / 218089.1 Using a Shared File
System / FAQ 233428.1 / 243880.1 Oracle
Applications Manager 166762.1 Distributed
AD 236469.1 Using a Staged APPL_TOP
242480.1 Linux Migration Utility
.. 238276.1 Patching FAQ
.. 174436.1 Merging APPL_TOPS
233428.1
69
For More Information

• Other Recommended Sessions
• S1612 Applications Lifecycle Management for
  Oracle E-Business Suite, Today and Beyond
• Michael Mast Wed. Sept. 21, 1100 AM, Rm 2004 -
  West
• E-Business Suite Applications Technology Experts
  Corner Located at the DEMOground near Pod D39
• RAC, DMZs, High-Availability, Integration,
  Security, Identity Management, Portal, Upgrades,
  Cloning and Maintenance

70
A
71
(No Transcript)