Closure Report
Project Summary
COM044 delivered ahead of schedule, whilst coping with some production delays
COM044 was a very successful smooth running project due to the project team working well together
COM044 decommissioned the old Serengeti databases before closure
Scope
The priorities were as follows:
The requirements were the migration / upgrade of the Serengeti databases to new 12c Oracle databases on the existing Oracle 12c servers.
Objectives & Deliverables
Objective 2 was completed in Test Rail, but full information of what was delivered is covered in Deliverable 4
In addition COM044 provided the decommissioning in Objective (O3) and Deliverables (D5-7) as well in this project
|
Deliverables |
MoSCoW |
Achieved | |||
| O1 |
To provide migrated/upgraded databases |
|
|||
| D1 |
Migrated and upgraded databases to Oracle 12C Dev |
Must have |
Y | ||
| D2 | Migrated and upgraded databases to Oracle 12C Test | Must have | Y | ||
| D3 | Migrated and upgraded databases to Oracle 12C Live | Must have | Y | ||
| O2 | To provide repeatable test scripts in Test Rail | ||||
| D4 |
Run existing / create Test Rail scripts to verify that the Serengeti Applications works as expected [What was provided was that the existing business Test scripts were used to verify that the Serengeti Applications worked as expected] |
Could have
[Completed]
|
N
[Y]
|
||
| O3 | To decommission the old databases | ||||
| D5 | Decommissioned databases in Oracle 11G Dev | [Completed] | [Y] | ||
| D6 | Decommissioned databases in Oracle 11G Test | [Completed] | [Y] | ||
| D7 | Decommissioned databases in Oracle 11G Live | [Completed] | [Y] |
Benefits
|
Item |
Benefits | Achieved |
|
|
Ongoing security updated and support on newer server infrastructure | Y - security updates were carried out by production separately from COM044, but planned and worked along side with COM044 replanning to suit the supplier's dates |
|
|
Documentation updated for future software development processes | Y - TAD has been updated |
|
|
The old databases in Dev, Test and Live were decommissioned, which clears up old data | Y - completed 3-Apr |
Success Criteria
| Item | Success Criteria | Achieved |
|
|
Serengeti databases on Dev, Test and Live have been successfully migrated and upgraded to Oracle 12 (Must Have) | Y |
|
|
The software maintains its current working condition and causes minimal disruption during the upgrade | Y |
|
|
That the Serengeti application works as expected | Y |
|
|
Serengeti databases on Dev, Test and Live have been successfully decommissioned in Oracle 11 |
Analysis of Resource Usage:
Staff Usage Estimate: 61 days
- Proposal: 50 days
- Brief: 61 days
- Approved: 46 days
Staff Usage Actual: 40.5 days
Other Resource Estimate: £xxx
Other Resource Actual: £xxx
Other Resource Variance: xx%
Outcome
Explanation for variance
Production had to complete Serengeti application security patching in Live (that had previously been completed in Test and Live before COM044 started )
- this was arranged for 13-Feb and this took the supplier until 14-Feb to complete
- after it was completed it was realised that Live had been upgraded to a more recent security patch than what had been applied to Dev and Test
- the supplier then arranged to patch Weblogic in Dev and Test on 28-Feb (both were 1/2 hour patches). Further information can be found in
- This production work delayed the COM044 plan, however while this delay was occurring -
- Dev Tech pro-actively suggested that there was one piece of work that could be completed in Live in the meantime, in preparation for the Go Live work
- This resulted in some slight replanning so that the project could continue on schedule
- The project successfully completed with a lower budget, due to the smooth running of the project and a good project team
Key Learning Points
Production Support and COM044 project team worked well alongside each other to ensure the Security patches were taken into account in the COM044 plan
Excellent Dev Tech WIKI implementation plan. Apps Support requested a link to, so that it could be maintained in the Apps Support WIKI.
Outstanding Issues
- No outstanding issues