Transcript Case Study 11.5.5 to 11.5.9 Function US German Reduction File

Improving Maintenance and
Reducing Patching Downtime in 11i
Ric Ginsberg
Vice President
Applications Release Engineering
Oracle Corporation
Topics
 Patching Best Practices
 Enhancements In Release 11i
 Maintenance Initiatives
Best Practices (#1)
 Schedule periodic downtime for proactive
maintenance
 Keep up-to-date on latest AD code
 Keep your test system current with production
 Perform “uptime” maintenance
–
Gather schema stats
–
Patch help system
–
Apply translation database updates
Best Practices (#2)
 Use a shared APPL_TOP and Distributed AD
 Avoid extent allocation errors with autoextend
 Combine patches with AD Merge Patch
 Use AD Patch ‘novalidate’ option
(default as of AD.H)
 Use a staged APPL_TOP
Enhancements In
Release 11i
11i Installation Enhancements
 Eliminates error prone OUI/ORCA based
install
 Uses Cloning architecture
 Installs in about an hour
 Installs translation filesystem (11.5.9)
 Rapid Install “-techstack” option
–
iAS 1.0.2.2.2
11i Performance Enhancements (#1)
 Faster driver read (50x faster)
 Faster prereq checking
 Faster file copy
 Faster Patch History processing
 Reduced worker idle time
 Increased worker parallelism
11i Performance Enhancements (#2)
 Create PL/SQL packages directly
 Generate reports in parallel
 Significant performance tuning for:
–
FNDLOAD
AKLOAD
–
Multi-Lingual Synch
–
 Synchronize Multi-lingual tables in parallel
 Tuning based on large volume upgrade tests
11i Patch Utility Enhancements (#1)
 Checkfile feature
–
Activated with database drivers
–
Records file and version information in the database
–
Executes commands only if they have not executed
previously for the highest onsite version of the file
–
Eliminates need for package revision cache
 Automatic job deferral
–
Re-tries failed jobs at the end of the phase
–
Replaces auto restart
11i Patch Utility Enhancements (#2)
 Unified Driver
–
Requires a single AD Patch run
 AD Merge Patch improvements
–
–
–
Can merge all patch types and driver types
Characterset is converted during merge
Significant performance improvement
 Automated Pre-requisite checking
–
–
–
AD Patch confirms prerequisite is satisfied
Allows for smaller patches, less overhead
Duplicate patch avoidance
11i Patch Utility Enhancements (#3)
 Password Hider
–
Passwords automatically removed from log files
 Manual Step Elimination
–
Automatically compiles Apps
–
Automatically Maintains MRC
–
Automatically compiles JSP
 Technology Stack Validation Utility
–
Confirms minimum techstack requirements
–
Refers to appropriate MetaLink notes
11i Patch Utility Enhancements (#4)
Distributed AD
–
adpatch
adworker01
…
adworker05
Apply patches using all your middle tier horsepower to
significantly reduce downtime
adworker06
…
adworker10
adworker11
…
adworker15
adworker16
…
adworker20
Case Study
 11.5.5(+) to 11.5.9
 300 GB database
 Languages: US English & German
 Characterset: UTF8
Case Study 11.5.5 to 11.5.9
Function
US
German
File system update
3.5 hours
2.5 hours
Database update
20 hours
10 hours
n/a
9 hours
3 hours
3 hours
MultiLingual Synch
File Generation
Total
51 hours
Reduction
Case Study 11.5.5 to 11.5.9
Function
US
German
Reduction
File system update
2 hours
.5 hour
60%
Database update
20 hours
10 hours
n/a
9 hours
3 hours
3 hours
MultiLingual Synch
File Generation
Total
51 hours
3.5 hour reduction for file system update:
reduced AD overhead
faster driver read
prior charset conversion
Case Study 11.5.5 to 11.5.9
Function
File system update
Database update
MultiLingual Synch
File Generation
Total
US
German
Reduction
2 hours
.5 hour
60%
14.5 hours
3 hours
40%
n/a
9 hours
3 hours
3 hours
51 hours
12.5 hour reduction for database update:
checkfile
loader performance
direct PL/SQL
increased parallelism
reduced overhead
reduced worker idle
Case Study 11.5.5 to 11.5.9
Function
File system update
Database update
MultiLingual Synch
File Generation
Total
US
German
Reduction
2 hours
.5 hour
60%
14.5 hours
3 hours
40%
n/a
1 hour
90%
3 hours
3 hours
51 hours
8 hour reduction MultiLingual Synch:
runs in parallel
performance improvements
Case Study 11.5.5 to 11.5.9
Function
File system update
Database update
MultiLingual Synch
File Generation
Total
US
German
Reduction
2 hours
.5 hour
60%
14.5 hours
3 hours
40%
n/a
1 hour
90%
2 hours
2 hours
35%
51 hours
2 hour reduction file generation:
parallel report generation
less overhead
Case Study 11.5.5 to 11.5.9
Function
File system update
Database update
US
German
Reduction
2 hours
.5 hour
60%
14.5 hours
3 hours
40%
n/a
1 hour
90%
2 hours
2 hours
35%
MultiLingual Synch
File Generation
Total
26 hour total reduction.
25 hours
50%
Case Study 11.5.5 to 11.5.9
Function
US
German
Reduction
File system update
2 hours
.5 hour
60%
Database update
5 hours
.5 hour
80%
n/a
1 hour
90%
.5 hour
.5 hour
85%
MultiLingual Synch
File Generation
Total
10 hours
80%
Additional 15 hour reduction using distributed AD.
Case Study 11.5.5 to 11.5.9
Function
File system update
Database update
MultiLingual Synch
File Generation
Total
US
German
Reduction
none
none
100%
5 hours
.5 hour
90%
n/a
1 hour
90%
none
none
100%
6.5 hours
87%
Additional 3.5 hour reduction using staged APPL_TOP.
Case Study 11.5.5 to 11.5.9
Function
File system update
Database update
MultiLingual Synch
File Generation
Total
US
German
Reduction
none
none
100%
5 hours
none
90%
n/a
none
100%
none
none
100%
5 hours
90%
Additional 1.5 hour reduction “hot patching” translation.
11i Patch Process Enhancements
50% step reduction in 11.5.9
Recreate Grants and Synonyms 
Compile Apps Schema

Maintain MRC

Compile Java Server Pages

Compile Flexfield Data
²
Gather Schema Statistics
¹ ²
Generate Message Files
¹
Run multiple patch drivers
¹
45% reduction in product steps
¹
¹Maintenance Pack only
²Concurrent Request
11i Quality Improvements (#1)
 Generated database drivers
 Internal standards compliance checker
–
Automatically checks over 200 standards
 SQL Repository
–
Parses over 400,000 SQL statements per release
–
Explain plans created against 5 volume databases
 Automated testing
–
WinRunner based infrastructure
–
400% increase in coverage
11i Quality Improvements (#2)
 Release Engineering process changes
–
Earlier testing of
 Product integration
 Pseudo-translations
–
Additional pre-release testing of
 Translations (by countries)
 OCS business flows
 EBSO customer business flows
 Internal production instances
 Release Engineering Internal Early Access Program
11i Translation Improvements

Simultaneous release of all languages for:
–
–

Translation escalation process
–

Usually available next day
Merged translations
–

Maintenance Packs
Family Packs/Minipacks
Immediate availability with no translation regression
Translation quality improvements
–
97% reduction in translation bugs 2001 - 2003
Configuration Management
Rapid Install
config.txt
OAM
Context Editor
AutoConfig
Applications
Context File
<sid> <host>.xml
Generated
Configuration
Files
jserv.properties
appsweb.cfg
httpd.conf
Generated
Database
Updates
Applications
Configuration
Templates
APPS_WEB_AGENT
ICX_FORMS_LAUNCHER
TCF:PORT
TCF:HOST
Oracle Applications Manager
OAM Configuration Context Editor
Oracle Applications Manager
Configuration History
Oracle Applications Manager
Compare and Restore Settings
Oracle Applications Manager
Search Patches
Oracle Applications Manager
Search Patches – Advanced
Oracle Applications Manager
Patch Summary
Oracle Applications Manager
Files Copied by a Patch
Oracle Applications Manager
Database Driver Actions
Oracle Applications Manager
File History
Oracle Applications Manager
Patch Advisor
Oracle Applications Manager
Create Patch Filter
Oracle Applications Manager
View Advice
Oracle Applications Manager
View Patch Details
Oracle Applications Manager
View Patch Impact
Oracle Applications Manager
Patch Impact Details
MetaLink Patch Search 2.0
Simple Patch Search
MetaLink Patch Search 2.0
Product/Family Search
MetaLink Patch Search 2.0
Saved Search
MetaLink Patch Search 2.0
Advanced Search
MetaLink Patch Search 2.0
Product Name Search
MetaLink Patch Search 2.0
Product Hierarchy Search
MetaLink Patch Search 2.0
Search Results
MetaLink Patch Search 2.0
Saved Searches
MetaLink Patch Search 2.0
Superseded Patch Details
MetaLink Patch Search 2.0
Quick Links
MetaLink Patch Search 2.0
Quick Links Mouseover
MetaLink Patch Search 2.0
Server/Tools Quick Links
Maintenance Initiatives
MetaLink Patch Search
 Improved flow to download patches
 Automated notifications
 Translation escalation/merge requests
 Electronic Product Delivery
Install/Cloning Technology
 Rapid Install “-techstack” option
–
RDBMS 9.2.0.3 / 9.2.0.4
 RAC Install
 Complex cloning
–
Multi-node to single-node
–
RAC support
 iSetup Integration
Patching Enhancements
 Parallel index creation
 In progress patch status
 Improved patch reporting
 Improved Patch Advisor
 Additional impact analysis
 Eliminate MRC schema
 Concurrent AD sessions
Admin
Forms A, B
Web A, B
CP A, B
Multi-Node Environment
One Admin Node
Two Forms Nodes
Two Web Nodes
Two Concurrent Processing Nodes
Not using Shared APPL_TOP
Standard AD
Admin
1)
2)
3)
4)
5)
6)
7)
Forms A, B
C driver on Admin node
C driver on Forms node A
C driver on Forms node B
C driver on Web node A
C driver on Web node B
C driver on CP node A
C driver on CP node B
Web A, B
CP A, B
8) D driver on Admin node
9) G driver on Forms node A
10) G driver on Forms node B
11) G driver on Web node A
12) G driver on Web node B
13) G driver on CP node A
14) G driver on CP node B
Admin
Forms A, B
Web A, B
CP A, B
1) C driver on ALL nodes simultaneously
2) D driver on admin node and G driver on all nodes simultaneously
AD Concurrent Sessions
Linux Migration Utility
 Quickly (~8 hours) and easily (~9 steps)
migrate middle-tier to Linux
 Can cut over with only a few minutes of
downtime
 Retains current patch level
 Retains many customizations
 Includes tech stack upgrade
Linux Migration Utility
Port-specific files
Generic files
ARU/MetaLink
Old System
(Windows/Unix)
New Linux
Middle Tier
Tech stack
Rapid Install
Techstack CDs
Long-term Initiatives
 Fully Distributed AD
 “Pre-downtime” patching
–
Schema Clone to pre-stage PL/SQL and view changes
 Granular linking & generation
 Manual step infrastructure
 AutoConfig Integration with OEM
For more Information…
MetaLink Information
Cloning Oracle Applications 11i
Using Autoconfig
Oracle Applications Manager
Using a Shared APPL_TOP
Distributed AD
Using a Staged APPL_TOP
Linux Migration Utility
Maintaining Apps FAQ
Note ID
230672.1
165195.1
166762.1
233428.1
236469.1
242480.1
238276.1
(coming soon)
Q U E S T I O N S
A N S W E R S