How cisco reduced cut over time for oracle 11i upgrade
Download
1 / 23

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


  • 301 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' How Cisco Reduced Cut-over Time for Oracle 11i upgrade' - jon


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



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


“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


Transition: Execution and Success Criteria 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 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 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: 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


TIPS & TECHNIQUES 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


Tips advance phases
Tips: Advance Phases 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

  • Purge / Archive Data

  • Rebuild Tables

  • Gather Statistics beforehand


Tips pre upgrade phases
Tips: Pre-Upgrade Phases 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

  • 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 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

  • 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 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(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 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

  • 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 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

  • 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 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

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) 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

  • 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 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

  • 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 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

  • Practice! Practice! Practice!

  • Precision Planning!

  • Promote excellence through post mortem reviews!

  • Teamwork !!!


For more information
For More Information 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

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”


Q and 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


Backup 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


ad