260 likes | 462 Views
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
E N D
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 CRP Definition: –CRP is a Conference Room Pilot –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 … Oracle Applications 11i Testing and evaluation … The upgrade to 11i via CRP Product to Production … 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 …
Just like riding a bike! The Process or Approach Taken: CRPs An upgrade using previous CRP documents goes like this…
The Process or Approach Taken: CRPs An upgrade using previous CRP documents goes like this… • Technical Upgrades are applied • Rudimentary testing is performed • Repeat until successful • Patches/Fixes/Setups/Profiles • User Unit testing • User Acceptance Testing • Final approval • …and then • Select the GoLive date, and • Upgrade production! UAT
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 … why wait? • eBusiness Suite fully supports the migration: • From: Proprietary UNIX hardware/OS • To: 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-RISCHP-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 11i Process • Create a new Oracle eBusiness Suite 11i environment via Oracle eBusinss Suite RapidWiz (RapidInstall). • 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 • Oracle8i Enterprise Edition Release 8.1.7 or • Oracle9i Enterprise Edition Release 2 (9.2.0) • The Target-Linux-Server (import into) MUST use • Oracle9i 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 2291496 AD MiniPack F 2141471 Applications Export/Import Consolidated Patch 2826013 Materialized Views 11.5.7-Only 2447246 New Improved Database Preparation Scripts 2096242
Some Technical Details … TechStack version eBusiness Suite: IBM/HPUX/Sun Lightening Fast Linux • Oracle 11.5.10 Release 2 Information • Oracle Database Executables 9.2.0.6 • Oracle RDBMS Home 8.0.6 • Oracle Applications Server (Includes HTTP) 1.0.2.2.2 • Oracle Discoverer 4.1.48 • Jinitiator 1.3.1.21 • Oracle Developer6i (Forms/Reports/Graphics) 6.0.8.25 • RapidWiz (rapidwiz/RapidWizVersion) 11.5.10.35
Some Technical Details … Post Upgrade eBusiness Suite: IBM/HPUX/Sun Lightening Fast Linux Consolidated Update Patch 2 MetaLink 316366.1 AD MiniPack I Delta 4 ATG Technology Family Pack Additional Family Packs and MiniPacks JInitiator Upgrade Personalization
But Wait There’s More: New eBusiness Suite Personalization AutoConfig VS. Personalize Self-Service Defn Yes <Self-Service Personalization> FND: Personalization Region Link Yes <Self-Service Personalization> Disable Self-Service Personal No <Self-Service Personalization> Corporate Branding Image liggett_logo.jpg FND: Diagnostics Yes <Apache “About This Page”> Local Login Mask 32 < If Multi-Language> -or- 40 <Password-Hint/Forgot URL> General Preferences Show Flag Yes <General Preferences Menu>
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 Q & A
Wrap-Up Thanks for your time! David Channell dchannell@liggettgroup.com Jim Sizemore jsizemore@liggettgroup.com Michael Barone mbarone@liggettgroup.com