Oracle DB upgrade & migration
Project goals:
- Upgrade Oracle database from 11.2.0.4 to 12.2.0.1
- Migrate the database to the new high-end server
- De-fragment and consolidate data within the database to reclaim space and improve performance
- Implement In-Memory database option
- Implement Multitenant database architecture
Accomplishments:
- The upgrade and migration has been performed, meeting 1 month project deadline
- Meeting such a tight deadline became possible because of merging the upgrade and migration activities under one Oracle DataPump export/import process
- Complex post-migration ETL performance issues have been resolved, by optimizing target configuration DB parameters
- Multitenant and In-Memory options have been implemented
Technologies:
- Oracle Database
- Oracle Database Multitenant option
- Oracle Database In-Memory option
- Oracle Enterprise Linux
Workload:
- 95 hours
Project team:
- Senior Oracle Database Architect
- Senior Oracle DBA
Client’s feedback:
«UCGP Consult is one of the best Oracle teams I’ve met, and I’ve worked with many. Their knowledge levels are incredible, feels like they can answer any question and solve any problem. They solved our slowdown issue and we can recommend them to anyone who is dealing with complex projects and big data.”
Want to make a successful project?
Need to save costs and consolidate your data assets? Tweak the database performance or execute 0% downtime database migration? Our creative approach unlocks business potential and focus on creating newer possibilities