APPS Database Oracle Upgrade/ Migration

100%

Status

Completed [Completed]

100% complete, updated on Thu 4/4/24 9:02 AM by Jim Nelson

Changed Status from In Process to Completed.
Project completed successfully

Details

Dates
Mon 4/17/23 - Thu 4/4/24
Acct/Dept
Enterprise Applications
Service
Business Applications / Existing business application support
Type
Operational / Maintenance Projects / Division of IT Maintenance Operations Projects
Health
Green - On track
Portfolio(s)
Classification
Large Project (Generally Over 230 Hours Effort)
Requirements
Newest version of Oracle with long term support.
All applications and services successfully cut over to new database.
Created
Fri 5/26/23 2:21 PM
Modified
Thu 4/4/24 9:02 AM
Closed
Thu 4/4/24 9:02 AM

Change Impact

How will you measure the impact of this project?
What are some metrics or KPIs that will be used to measure success? Think about the five metrics to measure: quality, quantity, timeliness, cost, and customer satisfaction.
The decommission of the old APPS database will be measured by security metrics and reduced risk to campus.
What are the consequences of not doing this project?
For example: direct significant negative consequences to the University, unable to conduct basic services; failure to resolve customer complaints or requests; loss of opportunity for improved service delivery or efficiency. Please explain.
We run the risk of dozens of applications, services, integrations breaking if there are issues with the current database. Being out of support, we would not have access to Oracle support and resolution.
How many employees will be impacted by this change?
Select the size of the employee population that will be impacted by this request.
A few
How many students will be impacted by this change?
Select the size of the student population that will be impacted by this request.
None

Project Costs

Funding Status
Funding is not necessary

Project Details

Project Champion
Person who voluntarily takes special interest in the adoption, implementation, and success of the project. They will help enforce the project solution with internal resources and promote it across campus.
Divisional VP Support
Does your divisional VP support this request?
No
What would a successful solution look like?
What outcome will you have at the conclusion of this project? If this proposal is one of a multi-phase project, please explain your plans, goals, and timelines for subsequent phases.
All systems, applications and integrations utilizing the APPS database successfully migrate to new database with minimal impact or disruption.
Executive Sponsor Division
The executive sponsor's campus division.
Information Technology
Is there a mandated or requirement driving this request?
Please indicate whether or not this request is mandated or required. If it’s mandated or required, you will be asked to attach supporting documentation.
Required (not mandated) to keep a campus system running properly
Project Urgency
Indicate if there is a mandate or requirement driving this request.
Required to keep a campus system running properly
Campus Enduring Commitments & Strategic Goals
For more information about the Campus Enduring Commitments and Strategic Priorities, please go to https://www.csuchico.edu/strategicplan/enduring... and https://www.csuchico.edu/strategicplan/.
Strategic Priority: Resilient and Sustainable Systems

Project Resources & Effort

What resources will this project require?
Identify the department and/or individuals that might need to work on this project and the estimated number of hours required for each individual.
EAPP, ESYS, NOP, ISEC.
DoIT Departments Involved
Any Division of IT departments that will be involved in this project.
EAPP (Enterprise Applications)
ESYS (Enterprise Systems)
ISEC (Information Security)
Complexity of Implementation
What is the complexity of the project?
Moderate (multiple interfaces/impacts/dependencies)
What is the solution type?
The solution type translates to the level of impact on IT staffing and technology maintenance. Based on consultation with your IT representative, pick the best fit for your proposed solution.
Complete new system or complete replacement of existing system

Description

The shared APPS Oracle database, used to host application and system database schemas is beyond end of life and needs to be replaced. ESYS will provision a new Oracle database with the latest version of Oracle and EAPP will migrate schemas/data and update applications for all EAPP managed systems. Additionally, there will be users on the database outside DoIT. ESYS and EAPP will work collaboratively to identify and assist outside groups with their migration.

Manager

Jim Nelson
Jim Nelson

Alternate Manager(s)

CB
Craig Bentley
Alisha Johns
Alisha Johns
WB
Wendy Bentley

Sponsor

Jim Nelson
Jim Nelson

Stakeholders (2)

Scott Kodai
Scott Kodai
Senior Director, Enterprise Applications
Informed
Informed.
Fri 5/26/23 2:05 PM
SK
Steve Krok
Chico State
Informed
Informed.
Fri 5/26/23 2:05 PM