Work/Task Breakdown
Planning | - Project Brief
- Create project plan
- Identify stakeholders
- Identify risks
- Submit brief to WIS
- Sign-off of project brief
|
| Preliminary Analysis | - Training in use of Oracle 12c
- Preparation and sign off of TAD
- Analysis stage sign off
|
| Initial Build | - Build of DEV servers - includes TSM backups; set up admin scripts; TNS names
- Review of scripts
- Amend 12c scripts (e.g. backup & dataguard)
- Creation of 12c RMAN catalogue database with DataGuard set up
|
| System Analysis & Design | - Investigation of new 'technical' features
- Analysis of container database features
- Research of licensing costs of new features
- Discussion & decision on features to be adopted
- Prepare recommendation report
- Investigate patching strategy options
- Discuss and detail migration options
- Re-estimation of outstanding work on project
|
Build | - Evaluation of Oracle 12c features
- Migration strategy testing & recommendations
- Backup & recovery
- Review of technical documentation
- Build stage sign-off
|
Acceptance | - Build of TEST servers - includes TSM backups; set up admin scripts; TNS names
- Test migrations
- Testing of features
- Test backup and recovery
- Recommendation on patching strategy
- Handover to Production Management
- Acceptance sign-off
|
| Procurement | |
Deployment | - Release of DEV & TEST environments for use
- Sign-off of operational documentation
- Deployment sign-off
|
Closure | - Complete Closure Report
- Project closure
|
Resources Skills and Cost
The planning work for this project has involved colleagues from the following areas:
- IS Applications Development Technology
- IS Applications Technology Management
- IS Applications Project Services
- IS Applications Production Management
The remaining stages are expected to require work from the same areas, with some input too from the ITI Unix area. The estimated effort for IS applications is 120 days.
IS Applications Development Services have been advised of the work being done under this project but do not expect to have a role in it. This project should benefit from the co-operative approach followed during ITS100 and INF105 (TSM work) that has seen colleagues from Development Technology and Technology Management working together to learn from and support each other in the adoption of new or upgraded technologies.
