Migrating Oracle applications to Linux A real life case study

1
Migrating Oracle applications to Linux - A real
life case study

• Presentation _at_ Winter 2004 NCOAUG Training Day

2
Agenda

• Why Enterprise Linux
• Platform Migration Planning
• Platform Migration Approach
• City of Bloomington Real life Linux
• Question and Answers

3
Why Enterprise Linux

• Like everything else in the world, Sturgeon's Law
  - 90 of everything is crud, applies to Open
  Source Software.
• Points to consider before you embark
• Has it been through the development cycle more
  than once or twice? -- level of maturity
• Reputation of the package is the key
• The current install base
• How much time, cost and effort does your company
  spend managing software licenses

4
Platform Migration Planning

• The Architecture
• OS selection Linux readiness
• Hardware sizing Intel platform
• Patch level compatibility Data base and
  Applications
• Customizations and Reports The key
• Network and Security
• Time line
• Key process - Data base and Application
  compatibility
• Change over impacts People Skills, Training
• Cut over window The Critical window

5
Hardware Sizing

• There are multiple ways
• Rule of thumb
• Trend Analysis
• Utilization of CPU
• Utilization of Memory
• Statistics based (Unix)
• System Activity Reporter (sar)
• Input/Output Statistics (iostat)
• Virtual Memory Statistics (vmstat)
• Know your data growth assumptions and need for
  accuracy
• Know your deployment Architecture
• Service level assurance
• Financial/technical planning
• Support of business decision making

6
Hardware sizing Intel platform

• Depending on the architecture of the Oracle
  Applications environment to be implemented, the
  following should be included in the sizing
• Production database/application server(s)
• Web server(s)
• Reporting/Batch server(s)
• Development/Test/Training server(s)
• Mass storage, backup, and high-availability
  solutions
• Workload scenarios
• Minimum. The shortest response time
• Average. The average of response times for
  all transactions,
• Maximum. The single worst-case response time,
  
• 90th percentile

7
Oracle Applications on Linux
8
Pilot-centric Project Methodology

• A major emphasis in the Pilot-centric method.
  It is recurrent cycles of continuous improvement
  before you perform final Platform migration
• Create a test plan for
• Functional Test
• System Test
• Performance
• Test, test, test
• Production Rehearsal - Final cut over to
  production is always a time-limited process as
  porting can start to become tricky

9
Setting up the Linux environment

• New Hardware
• Licensing
• Internal training
• Linux acceptability
• Tuning for performance
• Other monitoring, patching applications
• Create and re create your environment

10
The Critical

• Backup the database and APPL_TOP prior to
  upgrade, just prior to running auto install,
  after running autoinstall, and immediately after
  upgrade
• Create an online copy of the production database
  prior to the upgrade. This will provide a working
  snapshot of the database, which can be referred
  to when resolving missing or corrupted components
• Check for all current patches. Allowing
  additional patches to be installed after testing
  and prior to production increases the project risk

11
Platform Migration Approach

• Before migrating perform O/S or a technology
  stack component check OracleMetaLink for
  certified combinations
• Track every patch applied to the system
• Create most recent copy of Production
• Key lies in simulating environment as close as
  production migration like month end closing
• This will help in planning, developing test
  cases and scenarios
• Reduce or eliminate customizations
• Minimize post-migration patchs
• It is 2 step process
• Upgrade (At least re patch)
• Migrate to Linux

12
Database Migration Steps

• Recreating the Database
• Export the source Applications Release 11i
  database instance
• Prepare a target Applications Release 11i
  database instance
• Import the Applications Release 11i database
  instance
• Update the imported Applications Release 11i
  database instance
• If you want to move to 9i database first migrate
  to 8i
• Perform the actual upgrade process at least 2
  times, and preferably three 3 time if significant
  problems when encountered during the previous dry
  runs.
• Ref Metalink document 204015.1

13
City of Bloomington

• The Project Profile

14
The Project Profile

• Upgrade from 11.0.3 to 11i
• Migrate from HP US 11.0 to RedHat Linux 2.1
• Go live before year end 2003
• Fixed Bid, fixed price, fixed time
• The schedule allowed approximately 3 months to
  perform the 2 test upgrades and migrations
• 3 day window for database migration and testing
• 20 weeks and 2 monthly closing and 1 year end
  closing
• Oracle public sector with GL, AP, FA, INV, Pur,
  HRMS, Payroll

15
Key challenges

• Sizing As HP system was running at maximum
  utilization
• Optimization of size of tablespaces. Tablespace
  utilization was higher then recommended values -
  grounding to start from previous step
• Managing Schema for CUBS (Utilities invoicing)
  Application
• Report server implementation
• Concurrent optimization
• Automated testing

16
Mission accomplished

• Go live as planned
• Successful month end closing
• Successful year end closing
• 4-6 times faster payroll processing and improved
  performance from day one
• Improved process using 11i

17
Summary

• Planning
• Sizing
• Testing
• Production cut over window
• Patching
• Right partner

Linux Migration
18
Thank You!

• Mascon Global Limited1699 E. Woodfield Road,
  Suite 200Schaumburg, IL 60173847-619-5005www.ma
  sconit.com