ARCHIVED: Completed project: Oracle 10G R2 database infrastructure upgrade

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

Primary UITS contact: Dan Young, Manager, Enterprise Database Administration

Completed: October 22, 2008

Description: The currency, reliability, and longevity of enterprise data lie at the center of any efficient information technology solution. In our efforts to provide the most complete, recoverable, and robust data computing environment possible, the Oracle 10G R2 upgrade project will migrate the entire UITS enterprise database infrastructure to the most recent version of Oracle 10G. The upgrade will introduce new manageability and business continuity features as well as allow for the extension of premier vendor support through July 2010. (Oracle support for the currently deployed version, Oracle 10G R1, expires in January 2009.)

Outcome: Once complete, the enterprise database infrastructure will be fully supported by the Oracle Corporation until July of 2010 and platformed on the most stable version of the product. With the exception of required semiannual security patches, no further upgrades or major enhancements to the infrastructure are planned for the next 18-24 months, giving customers a significant block of uninterrupted database service.

Milestones and status:

Phase I (upgrade in place, non-PeopleSoft nodes):

  • April/May 2008: Planning and preliminary preparation of development environments Completed
  • May 2008: Upgrade of development database infrastructure Completed
  • June 2008: Upgrade of test database infrastructure Completed
  • July-October 2008: Upgrade of production database infrastructure
    • July 20, 2008: LIB1PRD, ODS7PRD, OB1PRD, ODS5PRD Completed
    • July 27, 2008: IE1PRD, ODS1PRD, ODS4PRD, GEN1PRD Completed
    • August 3, 2008: FIS1PRD, ODS3PRD, DPE2PRD Completed
    • August 10, 2008: WAS1PRD, ONS1PRD, TK1PRD, GEN2PRD Completed
    • October 5, 2008: ONC2PRD Completed
    • October 19, 2008: DSS1PRD, DSS2PRD, MMS1PRD Completed
    • To be determined with customer: MMS2PRD, ARC1PRD, VC1PRD, and the various training environments. These will typically be done during normal business hours and completed before October 19, 2008.
  • September 2008: Phase I complete (Upgrade in place, non-PeopleSoft nodes)

Phase II (Upgrade in place, PeopleSoft nodes)

  • August-September 2008: Upgrade of production database infrastructure
    • August 5, 2008: PS3DMOD, HR1DEV Completed
    • August 7, 2008: PS3DEV Completed
    • August 12, 2008: PS90BOX, PS3TST, HR1REG Completed
    • September 9, 2008: PS3STG, HR1STG, ODS6TST Completed
    • September 21, 2008: PS1PRD, HR1PRD Completed

Comment process: Email Dan Young.

Benefits:

  • Employs most current, supported, and stable release of Oracle 10G
  • Minimizes service disruption. No further upgrades will be required until July 2010.
  • Strategically positions the enterprise database infrastructure on the Release 2 cycle; this means all future upgrades will be made with the second service release of each major product version, thus maximizing features and minimizing risk.

Primary client: All Oracle-based enterprise software solutions, including systems such as PeopleSoft, FMS, DSS, and Oncourse

Client impact: It is the intent of the Enterprise Database Administration team to minimize client impact by performing this upgrade during standard published maintenance windows.

Project team: The Enterprise Database Administration team

Project sponsor: Rob Lowden, Director, Enterprise Infrastructure

This is document awuv in the Knowledge Base.
Last modified on 2018-01-18 16:10:24.