Overview

Background

This proposal is to upgrade the existing Oracle database owned by Web Integration, from Oracle 9.2 to 11.2.

The current version of the Oracle EUPS DEV, TEST and LIVE databases is 9.2. Oracle 9.2 is past its Extended Support date. The three EUPS schemas should be upgraded to lower the cost to the University, to mitigate security issues and to enable the business owner to take advantage of new features which IS will implement in the future.

The EUPS Oracle 9.2 schemas in DEV, TEST and LIVE will therefore be moved to the corresponding APPS database upgraded to Oracle 11g

Scope, Objectives and Deliverables

The scope of the project centres on the DEV, TEST and LIVE instances of the EUPS database with the objective of utilising a version of the underlying database that is supported by the supplier, is more stable , secure and better performing . The deliverables will be the DEV, TEST and LIVE instances of EUPS databases moved to the APPS database and upgraded to the Oracle version 11g. Applications using the database

• The U@Ed or Mobile Campus application and

MyEd Channels (EPS)

• Student Personal Details
• Student Courses
• Student Program of Study

and

•  EVE student voting

will continue to perform with no degradation in function or performance.

No existing errors or issues with the current system will be addressed as part of the project.

Benefits

Upgrading the EUPS schemas will bring the following benefits:

• 11g is supported by the vendor and security patches are regularly produced and are applied by IS Applications. This will ensure continued support for the applications used by the business owner.
• New features are available in 11g which the business owner may be able to take advantage of.
• The cost to the university will be reduced due to the benefits of a consolidated technology layer. Management tools available do not operate fully on older versions, so maintenance of service is fractured. Single version level (or more consistent) will give ability to keep patching and proactive management streamlined.

Success Criteria

Upgraded instances of the EUPS schemas are moved to APPS DEV, TEST and LIVE at version Oracle 11g.

The applications identified by the business owners continue to function with no adverse affect on current service levels.