How cisco reduced cut over time for oracle 11i upgrade
This presentation is the property of its rightful owner.
Sponsored Links
1 / 23

How Cisco Reduced Cut-over Time for Oracle 11i upgrade PowerPoint PPT Presentation


  • 219 Views
  • Uploaded on
  • Presentation posted in: General

How Cisco Reduced Cut-over Time for Oracle 11i upgrade. Uma Desiraju, IT Project Manager, Cisco Systems David Joffe, Cisco 11i Upgrade Architect, Abacus Business Solutions January 24, 2006. Agenda. Oracle Applications at Cisco Key Drivers for Cut-over Reduction

Download Presentation

How Cisco Reduced Cut-over Time for Oracle 11i upgrade

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


How cisco reduced cut over time for oracle 11i upgrade

How Cisco Reduced Cut-over Time for Oracle 11i upgrade

Uma Desiraju, IT Project Manager, Cisco Systems

David Joffe, Cisco 11i Upgrade Architect, Abacus Business Solutions

January 24, 2006


Agenda

Agenda

  • Oracle Applications at Cisco

  • Key Drivers for Cut-over Reduction

  • Transition Organization and Overview

  • Tips & Techniques

  • Closing

  • Q & A


Oracle applications at cisco

Oracle Applications at Cisco

* Current state -Cisco has 9 production Oracle eBusiness Suite instances that are all on some version of 11i

New instances were gradually introduced to support different geographies and modules

1995

2003

2005

First Oracle implementation, 10.4

10.7 instances upgraded to 11i


11i upgrade project information

11i Upgrade Project Information


Key drivers for cut over reduction

Key Drivers for Cut-over Reduction

  • Minimal disruption to business

    • Backlog Conversion

    • Duration for normalization

  • Executive Reporting

    • Bookings

    • Revenue

  • Data availability to boundary systems


How cisco reduced cut over time for oracle 11i upgrade

“Transition" is the process of moving and normalizing a business/IT organizations’ group of interacting, interrelated, interdependent processes/technology from their current state to their desired state, aligned with the long term business objectives

Transition Team

Business Readiness

Systems Readiness

Infrastructure

&

Software Config

Mgmt (SCM)

Release

Command

Center

Systems

Planning &

Execution

Business

Planning &

Execution

Business

Operations

S-OX

OA/User

Training

  • Build & support of environments

  • Server Architecture

  • Upgrade

  • RAC Install

  • Code Deployment

  • Third-party application compliance and readiness

  • Command Center Logistics and communication

  • Transition Walk-throughs

  • Post Mortem Issue Resolution

  • Access Management

  • Custom Code and Data Migration

  • Boundary application management

  • Contingency Planning

  • Data Audits

  • Smoke Test

  • Business Normalization

  • Business Frontline Support

  • End-Of-Life

  • Backlog Processing

  • Customer Pre-planning

  • Executive Reporting

Communication, Status Reporting, Issue & Escalation Management

X-Flow Co-ordination


How cisco reduced cut over time for oracle 11i upgrade

Transition: Execution and Success Criteria

Transition Test ( TT )

Transition Planning & Operations

24x7

24x7

24x7

TTA

TTB

TTC

FPR

Walk-through

Walk-through

Walk-through

Walk-through

Walk-through

Go Live

Post Mortem Review

Post Mortem Review

Post Mortem Review

Post Mortem Review

Test Cycle (TC)

TC-A

TC-B

TC-C

Transition Test C & Final Practice Run

Transition Test A

Transition Test B

Go-live


Transition phase overview

Communications

Transition: Phase Overview

Advance & Ramp Down

Cutover

Ramp Up

BusinessNormalization

GO/NO-GO

Metered businessramp up

Business process activity level

Flushing

Custom Code Install / IT Verification

Pre-Data Audit

Upgrade and Custom Data Migration

Post Data Audit / Smoke Test

FrontlineSupport


How cisco reduced cut over time for oracle 11i upgrade

TIPS & TECHNIQUES


Tips advance phases

Tips: Advance Phases

  • Purge / Archive Data

  • Rebuild Tables

  • Gather Statistics beforehand


Tips pre upgrade phases

Tips: Pre-Upgrade Phases

  • Determine relevant Pre and Post Upgrade Steps

  • Automate and parallelize Pre and Post Upgrade Steps

  • Clear interface tables as early as possible


Tips autoupgrade maintenance pack patches

Tips: AutoUpgrade, Maintenance Pack, & Patches

  • Play with # of workers for upgrade and patch

  • Use Staged APPL_TOP

    (metalink notes 217370.1 and 242480.1 )

  • Use Distributed AD

    (metalink note 236469.1 )

  • Use OM Bifurcation

    (metalink Note 121200.1)


Tips autoupgrade maintenance pack and patches continued

Tips: AutoUpgrade, Maintenance Pack, and Patches (continued)

  • Find long-running and bottleneck jobs

  • Use optimal adpatch options

    • (phtofile, nocompiledb, nocopyportion, nogenerateportion)

  • Monitor Job Timings

  • Maintain error history / Anticipate Errors

  • Merge Patches


Tips custom code install phase

Tips: Custom Code Install Phase

  • Use FNDLOAD, WFLOAD, and other Oracle APIs for deploying Custom Setups

  • Deploy custom objects efficiently / in parallel

  • Build custom code tree out of the critical path

  • Consider impacts to external / boundary systems


Tips environments infrastructure

Tips: Environments / Infrastructure

  • Use production-like hardware

  • Use recent copies of production databases

  • Analyze space requirements

  • Take backups during the cutover process

  • Create temporary environments for use during upgrade


Advanced techniques

Advanced Techniques

Cisco extensively CUSTOMIZED Oracle’s upgrade and patch scripts themselves to reduce cutover time further

Only recommended if:

  • You have experienced personnel who understand how to read patches and upgrade scripts

  • Other techniques do not satisfy go live targets

  • You have enough bandwidth to do many practice runs

  • You cannot get Oracle to fix long-running upgrade scripts by logging bugs


Advanced techniques continued

Advanced Techniques (continued)

  • Pre-create indexes using parallelization

  • Avoid index re-creation

  • Drop indexes during mass DML

  • Adjust FREELISTS parameters

  • Utilize AD_PARALLEL package

  • Combine similar scripts

  • Embed custom data migration scripts

  • Comment out unnecessary scripts


Tips environment certification

Tips: Environment Certification

  • Establish Clear “Go” Criteria

  • Affirm business stakeholder acceptance of audit and test strategy and results

  • Document and archive certification procedures and results


Recap of top lessons

Recap of Top Lessons

  • Practice! Practice! Practice!

  • Precision Planning!

  • Promote excellence through post mortem reviews!

  • Teamwork !!!


For more information

For More Information

Read our Whitepaper Posted at www.norcaloaug.org

  • Oracle Applications Manuals

    (available at: http://www.oracle.com/technology/documentation/applications.html)

    • Upgrading Oracle Applications Release 11i (11.5.10)

    • Oracle Applications Maintenance Procedures

    • Oracle Applications Maintenance Utilities

  • Oracle Metalink notes

    (available at http://metalink.oracle.com)

    • 121200.1 “Order Management Release 11i Upgrade Instructions”

    • 217370.1 “Reduce Downtime by Using a Test APPL_TOP for a Production Upgrade”

    • 225165.1 “Patching Best Practices and Reducing Downtime”

    • 230538.1 “TUMS (The Upgrade Migration Script)”

    • 233428.1 “Sharing the Application Tier File System in Oracle Applications 11i”

    • 236469.1. “Using Distributed AD in Applications Release 11.5”

    • 242480.1. “Using a Staged Applications 11i System to Reduce Patching Downtime”


How cisco reduced cut over time for oracle 11i upgrade

Q and A


How cisco reduced cut over time for oracle 11i upgrade

Backup


  • Login