Transcript www.jrpjr.com

Taking the plunge,
migrating to LINUX
John Peters
JRPJR, Inc.
[email protected]
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
1
Before We Start A Quick
Audience Survey
• How many of you have considered running
the OraApps on LINUX?
• How many of you are in the process of
migrating to LINUX?
• How many of you are currently running the
OraApps on LINUX?
• How many are currently running on:
HP/UX? Solaris? AIX? Windows?
• How many of you are on 11.5.10? 11.5.9?
• How many of you are using 10G of the DB?
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
2
What we are going to cover
•
•
•
•
•
•
What migrates to LINUX?
When would you want to migrate to LINUX?
Why migrate to LINUX?
The steps to migrate to LINUX
Other Considerations
Case study of a LINUX migration
–
–
–
–
–
Original Environment
LINUX Environment
Performance comparisons
11.5.10.2 Upgrade Information
10G DB Upgrade Information
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
3
What migrates to LINUX?
• This paper will deal primarily with running the
OraApps code on LINUX, while leaving the DB on an
existing non-LINUX server, (HP/UX).
– No OraApps code on any non-LINUX server.
– Single OS for OraApps Patches and DB Patches
– Only the DB on non-LINUX server.
• This is probably the most straight forward migration.
This has been Oracle’s recommended approach for
some time now.
– Migrating the DB requires a full DB export/import.
– You probably have the original server still available.
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
4
OraApps Linux Configuration
All OraApps Code
All OraApps Tech Stack
Only the database and
SQL*Net Listener
Many ORACLE_HOMEs
- Application Servers
- Forms Server
- Concurrent Managers
Applications
Tier
Typically only tier to require
OraApps Patching
One ORACLE_HOME
Typically only DB Patches
Database
Tier
SAN Device
DB
• DB resides on a SAN device
• OraApps components on single LINUX server
• Local LINUX disks used for OraApps code
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
5
When to migrate to LINUX?
• Typically advantageous when existing system
resources become constrained and RAM/CPU
upgrades are required.
Or
• When hardware additions are required for
security reasons, (reverse proxy DMZ server)
• Probably also done during an OraApps
upgrade, (due to testing requirements).
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
6
Why migrate to LINUX
Intel won the CPU battles
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
7
Why migrate to LINUX
• Lower Systems Cost
– HP RP7410 HP9000, $130K (2002)
• 4 – 750MHZ Processors
• 12GB
• HP/UX
– DL385 Proliant, $15K
• 2 – 2.4GHZ Processors
• 16GB
• RedHat LINUX
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
8
Why migrate to LINUX?
• Lower Component Cost (for Upgrades)
– CPU
• HP9000, 750MHz -> $8,000
• Intel/AMD, 2GHZ -> $600
– Memory
• HP9000, 2GB -> $3,000
• Intel/AMD, 2GB -> $700
– Internal Disks
• HP9000, 72GB 10k -> $1,000
• Intel/AMD, 72GB 10k -> $300
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
9
The steps to migrate to LINUX
• Start with Oracle’s Note 238276.1
‘Migrating to Linux with Oracle Applications
Release 11i’, last update Oct. 17, 2005
• However, there are many extra steps I will
discuss in a few minutes.
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
10
Migrate to LINUX
before or after upgrade
• No single answer for everyone.
• No recommendation from Oracle.
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
11
Migrate to LINUX before upgrade
• Benefits
– You get the performance benefits on the LINUX
servers during the upgrade
– You can pre-stage the LINUX server, not done
during downtime weekend
• Drawbacks
– You are committed to LINUX, no fall back strategy
– You must make this decision at the beginning of
the upgrade project
– Requires pre-upgrade patching to perform LINUX
migration
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
12
Migrate to LINUX after upgrade
• Benefits
– You can roll back to the existing server if issues
come up
– If you run out of time during the upgrade
weekend you can go live with the existing server
– Final version TechStack (off of 11.5.10.2 CD)
• Drawbacks
– Dual testing of OraApps on the existing and LINUX
server (to support roll back)
– Slower upgrade performance
• I prefer this migration path
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
13
Summary of Steps
• Install Tech Stack on LINUX
• Copy non-Tech Stack (OraApps) code
from source server to LINUX
• Apply customer specific patch which
provides LINUX libraries
• Relink bin code
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
14
High Level Steps
• Prep work on the source server
(Note 238276.1, Section 1)
– Probably all steps you have already done, or should have done
– If not they probably require user testing
• Migration from source to destination server
(Note 238276.1, Section 2)
– Majority of steps can be done prior to down time
– Oracle does not specify down time steps
• Finishing Tasks
(Note 238276.1, Section 3)
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
15
Prep work on the source server
1.
2.
3.
4.
5.
DB must be minimum of 8.1.7.4
Must be on 11i AD, G
Autoconfig must be implemented
Maintain snapshot (adadmin)
Software Version (source server)
–
–
–
PERL 5.005 (usually not an issue)
JVM 1.4.2 (requires JInitiator 1.3.1.21)
See note 246105.1, (run with single JVM version)
6. LINUX Kernal Parms/Packages
(target server)
–
See note 287453.1
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
16
Prep work on the source server
•
Get these steps in PROD before starting Migration
Project, possibly with other testing cycles.
•
Then each TEST clone will have them ready to go.
•
There are a few more steps in the later sections to
also include. I will flag them.
•
Order LINUX OraApps Rapid Install Pack for final
version
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
17
Migration from source to
destination server
1. Apply Platform Migration Utility Patch
(get this in PROD in advance)
2. Generate and Upload Manifest
–
–
–
–
–
Run a script on your server, then upload to Oracle Support
This builds a list of all your Oracle Supplied lib files
This will be used to generate a custom patch just for your
environment
Patch is generally ready to download from Metalink within
a day
Don’t do this until you have frozen the PROD environment,
step probably belongs after 11
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
18
Migration from source to
destination server
3. Create the Target System APPL_TOP
–
Copy the following file systems from source to target
•
•
•
•
•
–
APPL_TOP
OA_HTML
OA_JAVA
COMMON_TOP/util
COMMON_TOP/_pages
Copy JInitiator security files
•
JInitiator 1.3.1.21 uses a different security file mechanism
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
19
Migration from source to
destination server
4. Clone the AutoConfig XML file
(on target system)
5. Install Middle Tier Tech Stack
(on target system)
–
–
Rapid Install Wizard –techstack option
Installs: ORACLE_HOME & IAS_ORACLE_HOME
6. Apply Oracle InterOp Patches for Linux
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
20
Migration from source to
destination server
7. AutoConfig Target System
–
Critical to include INSTE8_SETUP option
8. Download and Apply Customer
Specific Update Patch
(on target system)
–
Probably belongs after step 11
9. Apply Patch if Source System is
Windows
(on target system)
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
21
Migration from source to
destination server
10. Reapply Tech Stack Patches
(on target system)
11. Apply TechStack InterOp Patch
(on target system)
This is where I would insert customer
specific patch (steps 2 & 8)
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
22
Migration from source to
destination server
12. Regenerate File System Objects
(on target system)
– This regenerates all bin files, using lib’s in
customer specific patch
– Messages, Forms, Reports, Graphics and
JAR files regenerated
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
23
Migration from source to
destination server
This requires down time at this point.
13. AutoConfig Target System
– Stop all OraApps processes on Source
System
– Messages, Forms, Reports, Graphics and
JAR files regenerated
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
24
Finishing Tasks
1. 3rd Party Libraries
– ILOG (any MFG modules)
– QUANTUM (Vertex Tax Integration)
– ROGUEWAVE (???)
2. Customizations
– Forms
– C Code
3. OraApps Printer Name Changes
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
25
Finishing Tasks
4. Update Workflow Cartridge Config
(AutoConfig changed values)
5. Verify and Fix CLASSPATH
6. Start Target Services
Down Time Completed
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
26
Real World
1. Perform the above three groups of
steps in the TEST instance.
2. Copy TEST LINUX server to PROD
LINUX server
3. RapidClone
4. AutoConfig
This process takes less than an hour
during the downtime weekend
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
27
Other Considerations
• Post Processing Printing
– Printing now occurs on LINUX Concurrent Processing Tier
– RSH/RCP script to send output back to source server
• Email
– Email is sent on the LINUX server by Notification Mailer
• Startup and Shutdown Scripts
– Start DB Tier (source server)
– Start OraApps Tier (target server)
– No Oracle Solution
– Manually, or use RSH to automate
• User access URL changes
– Virtual DNS Entry, prod.mycompany.com
• iPayment Integrations
– Certificates
– Custom Code
• Positive Pay Transfer Routines
– Custom Executable Per Bank
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
28
Case Study
• Bay Area company
–
–
–
–
–
–
Financials (AP, AR, GL, FA)
Discrete Manufacturing
Order Management
Service Contracts/Installed Base
iStore/iPayment
Currently Domestic OraApps Users Only
• ~75 Concurrent Users
• 150GB Database
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
29
What was changed
•
•
•
•
HP/UX OS Patching
OraApps from 11.5.9 to 11.5.10.2
JVM Upgrade
License/Patch new modules
•
•
•
•
Oracle Security Patches
JInitiator upgrade (required desktop rollout)
Web ADI
Migrate OraApps to LINUX
–
–
–
–
–
ICM
Field Service
Customer Care/Call Center
Email Center
EPB
• Started on 11/23 17:00, Finished on 11/27 10:00
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
30
Original Configuration
• Single Tier Server
– HP9000, RP7410
• 4 - CPU 750MHZ
• 12GB
–
–
–
–
–
OraApps 11.5.9
DB 8.1.7.4
9i instance for Content Management System
OFA, Oracle Express
Experienced performance issues
• CPU 100% from time to time through out day
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
31
New Configuration
• DB Tier Server
– HP9000, RP7410
• 4 - CPU 750MHZ
• 12GB
– DB 10.1.0.4 (OraApps Instance)
– 9i instance for Content Management
System
– OFA, Oracle Express (to be phased out by EPB)
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
32
New Configuration
• OraApps Tier Server
– HP DL385 Proliant Server
• 2 - CPU 2.4GHZ
• 16GB
• RedHat LINUX
– All OraApps Code
• Allows for future Reverse DMZ Server for
iStore Users
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
33
New Configuration
• We can run 3 OraApps TEST Instances
on a single LINUX server
• CPU Utilization >95% idle
• Plenty of free memory
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
34
Performance
• DB Tier now rarely hits 100% CPU utilization
• OraApps Tier rarely goes over 5% CPU
utilization
• HTML users noticeable improvement in speed
• OraApps Forms users have seen a mixed bag,
primarily due to 11.5.10.2/10G DB
Performance Issues
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
35
DB CPU Performance
Before, 10/12/2005
CPU Idle Comparison
After, 12/14/2005
90
79
80
66
% CPU Idle
70
73
62
60
57
54
52
48
50
42
43
35
39
36
29
20
51
36
40
30
56
54
27
16
10
19
19
11
12
33
23
0
6
7
8
9
10
13
14
15
16
17
Time of Day
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
36
DB CPU Performance
Performance Spikes
14
14
12
10
Minutes <5% CPU Idle
10
8
6
5 5
6
5
4
4
3
4
3
2
1
2
0 0
1
0
1
1
0
00
0
00
0
6
7
8
9
10
11
12
13
Time of Day
Before, 10/12/2005
01/24/06 NorCal OAUG Training
Day, Paper 3.9
14
15
16
17
After, 12/14/2005
John Peters, JRPJR, Inc.
37
MRP Performance
MRP Run Times
2:52
Run Time (HH:MM)
2:24
1:55
1:26
0:57
0:28
0:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Sample Days
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
38
Summary
• I think it is inevitable that OraApps customers will be
running the OraApps on LINUX based Intel
architecture CPU’s due to the following:
– Cost vs Performance
– Phase out of proprietary RISC CPU’s
• HP has already phased out PA-RISC
• SUN is using AMD CPU’s, what is the future of SPARC?
– Oracle’s Support for other OS’s (limited availability of patches)
– The ease to migrate OraApps to LINUX
• Next will be the Database, many new OraApps
customers are just starting off on LINUX.
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
39
• My contact information:
John Peters
[email protected]
http://www.jrpjr.com
• Additional reference papers can be found
at:
http://www.norcaloaug.org
http://www.jrpjr.com
01/24/06 NorCal OAUG Training
Day, Paper 3.9
John Peters, JRPJR, Inc.
40