Overview
Background
The Identity Management (IDM) database provides identity data to other services within the University. This data could be pushed to downstream services or pulled from IDM by these services. IDM receives its data from a number of connectors or inbound services - EUCLID, HR, VRS, Alumni and Org Hierarchy. This data is stored in an Oracle 11g database. Downstream services that rely on IDM include EASE, Central Auth, MyEd, WebCt, Wiki, Polypoly, CCD, HR.
Oracle are withdrawing their extended support for version 11g at the end of 2020. To ensure that we maintain a reliable, supplier compliant platform for the University this project will deliver the migration of the IDM database to Oracle 12.2.
Scope
The scope of this project is to upgrade the Oracle 11g database to Oracle 12.2, and to ensure that that all the Golden Copy, downstream and processing data connections are all connecting to the new database correctly. The infrastructure we migrate to will be the new, existing Oracle 12.2 physical infrastructure.
Additionally the project will be tasked with communications relating to the upgrade and in making sure that all stakeholders have approved our migration timetable.
Objectives and Deliverables
| Number | Description |
Priority Moscow |
| Objective 1 | To migrate the IDM Database to Oracle 12.2 | |
|
D1.1 |
The completed migration of the IDM database to Oracle 12.2 on DEV, TEST and LIVE.
|
Must Have |
| D.1.2 | All Golden Copy, downstream and processing data connections and drivers are all connecting to the new database correctly | Must Have |
| Objective 2 | To provide a plan that is agreed by all stakeholders and that provides the best mitigation against prolonged service interruptions | |
| D2.1 | A signed off plan by the stakeholders for the rollout of the upgrade to the production environment | Must Have |
| Objective 3 |
To test services, checking that data is flowing successfully and as expected to their respective systems. |
|
| D3.1 |
All downstream and upstream data services are functioning as before the upgrade, pushing or pulling data to their respective systems |
Must Have |
| D3.2 | TestRail utilised for integration testing phase using test plans from the COM043 SOA upgrade | Must Have |
| D3.3 | Decommission legacy schemas / infrastructure | Must Have |
Benefits
- Supplier support for the IDM database will be maintained.
- Any updated features available in Oracle 12.2 will be available to our development teams.
- A secure platform for the IDM service
Success Criteria
- The upgrade is completed successfully with any post upgrade issues resolved
- The IDM service retains or improves upon its performance and stability
Project Milestones
| Plan | Planning sign off | 25-Jan-2019 |
| Build | DEV build sign off | 15-Mar-2019 |
| Integrate | Integration testing sign off | 11-Apr-2019 |
| Accept | Acceptance testing sign off | 02-May-2019 |
| Deliver | Deploy to LIVE | 08-May-2019 |
| Deliver | Deployment Sign Off Review | 22-May-2019 |
| Close | Project Closure | 07-Jun-2019 |