Transcript ES-OAUG
Oracle eBusiness Suite From: IBM/HPUX/SUN/et.al
To: Lightening-Fast-Linux Presented by: Michael Barone, OATC DBA David Channell, Liggett
Eastern States Oracle Applications Users Group
Friday May 18, 2007
Agenda
Review Process/Approach taken Review Core Team Review some technical details… Questions and Answers (maybe!) Wrap-up
The Process or Approach Taken: CRPs
The Process or Approach Taken: CRPs
CRP Definition: –
CRP is a Conference Room P
ilot –
Prototyping, according to APICS
…a CRP is “a product model constructed for testing and evaluation to see how the product performs before releasing the product to production” –
In this case:
Product … Testing and evaluation … The upgrade to 11i via CRP Product to Production … Oracle Applications 11i Releasing 11i to the end users!
The Process or Approach Taken: CRPs A typical upgrade using the CRP method goes like this…
The Process or Approach Taken: CRPs
Some important things to keep in mind:
Liggett upgraded from 10.7 to 11i (11.5.6) in … ‘2003 Preserving/reusing Upgrade/Testing material : Reusing Upgrade/Testing Materials saved time & money!
End users … (familiarity, reproducible results) Auditors …
The Process or Approach Taken: CRPs An upgrade using previous CRP documents goes like this… Just like riding a bike!
The Process or Approach Taken: CRPs An upgrade using previous CRP documents goes like this…
1) Technical Upgrades are applied 2) Rudimentary testing is performed • Repeat until successful • Patches/Fixes/Setups/Profiles 3) User Unit testing 4) User Acceptance Testing 5) Final approval …and then 4) Select the GoLive date, and 5) Upgrade production!
UAT
Our team!
Our Core Team Members
David Channell, Project Manager
Michael Barone, OATC DBA Jim Sizemore, DBA Lisa Over, Applications Technical Lead Various testers
Our Core Team Members
Project Manager
Hardware Selection/Negotiations/OS Licensing
Systems Set up/Administration/Backup Strategies
DBA
eBusiness Suite Certification Matrix
eBusiness Suite Migration/Upgrade scripts eBusiness Suite Migration/Upgrade AIM documentation
Developers
Technical and Functional Testing
Some Technical Details
Some Technical Details … why wait? eBusiness Suite fully supports the migration: From: To: Proprietary UNIX hardware/OS
Lightning Fast Linux OS …
there really isn’t a reason to wait any longer.
Save money Save hardware-resources Save-software resources
Technical Environment … Hardware
Current System: eBusiness Suite 11.5.6
PA-RISC HP-UX Servers – Single Node Installation HP Direct Attached Storage Tape Backup
Target System: eBusiness Suite 11.5.10.2
HP C Class Blade Servers – Single Node Installation Network Appliance SAN/NAS Storage Disk to Disk to Tape Backup
Technical Environment … Software
Current System: eBusiness Suite 11.5.6
Operating System -
HP-UX version 11.0
Database – Oracle 8.1.7
CA Brightstor ARCServe Backup for Windows
Target System: eBusiness Suite 11.5.10.2
VMWare 3.0.1 w/Virtualized Red Hat Linux Enterprise version 4 Network Appliance - FCP, iSCSI, CIFS, Snapshot, SnapRestore, Cluster Disk to Disk to Tape using CA Brightstor ARCServe Backup for Windows
Some Technical Details … overview!
eBusiness Suite: IBM/HPUX/Sun
Lightening Fast Linux
Metalink Note: 230627.1
Export/Import eBusiness Suite Release 11
i
Process Create a new Oracle eBusiness Suite 11
i
eBusinss Suite RapidWiz (RapidInstall). environment via Oracle Export (exp) and Import (imp) utilities then move the existing data to the new Hardware/OS Platforms No ugly Export-FileSize limits Table-Level Row-Count/Confirmation Update the Imported eBusiness Suite 11i Database
Some Technical Details … beware!
The Oracle-Squeeze -- Caveat Emptor
The Source-IBM/HP/Sun (export-from) MUST use Oracle8
i
Enterprise Edition Release 8.1.7 or Oracle9
i
Enterprise Edition Release 2 (9.2.0) The Target-Linux-Server (import into) MUST use Oracle9
i
Enterprise Edition Release 2 (9.2.0).
Fortunately, eBusiness Suite 11.5.10
eBusiness Suite Rapidwiz Installs … Oracle9i (9.2.0.6)
Some Technical Details … MiniPacks!
eBusiness Suite: IBM/HPUX/Sun
Lightening Fast Linux
Pre-Requisites:
Source 11i (IBM/HP/Sun) Database (Oracle8i/Oracle9i)
AD MiniPack PreRequisite AD MiniPack F Applications Export/Import Consolidated Patch Materialized Views 11.5.7-Only New Improved Database Preparation Scripts 2291496 2141471 2826013 2447246 2096242
Some Technical Details … TechStack version
eBusiness Suite: IBM/HPUX/Sun
Lightening Fast Linux
Oracle 11.5.10 Release 2 Information Oracle Database Executables Oracle RDBMS Home Oracle Applications Server (Includes HTTP) Oracle Discoverer Jinitiator Oracle Developer6i (Forms/Reports/Graphics) RapidWiz (rapidwiz/RapidWizVersion) 9.2.0.6
8.0.6
1.0.2.2.2
4.1.48
1.3.1.21
6.0.8.25
11.5.10.35
Some Technical Details … Post Upgrade
eBusiness Suite: IBM/HPUX/Sun
Lightening Fast Linux
Consolidated Update Patch 2 AD MiniPack I Delta 4 ATG Technology Family Pack Additional Family Packs and MiniPacks JInitiator Upgrade Personalization
MetaLink 316366.1
…and there is more to 11i than meets the eye!
But Wait There’s More: New eBusiness Suite Personalization AutoConfig VS.
Personalize Self-Service Defn Yes FND: Personalization Region Link Yes Disable Self-Service Personal Corporate Branding Image FND: Diagnostics Local Login Mask -or No liggett_logo.jpg
Yes 32 40
But Wait There’s Even More: New eBusiness Suite Personalize AutoConfig
Metalink 270519.1 (February 2007) Customizing an AutoConfig Environment
Review and migrate existing customizations
AppsTier: $AD_TOP/bin/adcustomizer.sh
DBTier: $ORACLEME/appsutil/bin/adcustomizer.sh
Implementing AutoConfig customizations
cp -i $FND_TOP/admin/template/appsweb.cfg \ $FND_TOP/admin/template/custom/appsweb.cfg
Execute AutoConfig
Wrap-up…
Wrap-Up
Q & A
Wrap-Up
Thanks for your time!
David Channell Jim Sizemore Michael Barone [email protected]