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 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 … Testing and evaluation … Product to Production … Oracle Applications 11i The upgrade to 11i via CRP 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: 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-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 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 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 MetaLink 316366.1 AD MiniPack I Delta 4 ATG Technology Family Pack Additional Family Packs and MiniPacks JInitiator Upgrade Personalization …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 FND: Personalization Region Link Disable Self-Service Personal Corporate Branding Image FND: Diagnostics Local Login Mask -orGeneral Preferences Show Flag Yes <Self-Service Personalization> Yes <Self-Service Personalization> No <Self-Service Personalization> liggett_logo.jpg Yes <Apache “About This Page”> 32 < If Multi-Language> 40 <Password-Hint/Forgot URL> 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… Wrap-Up Q&A Wrap-Up Thanks for your time! David Channell Jim Sizemore Michael Barone [email protected] [email protected] [email protected]