All case studies
Case study

Oracle Database upgrade to 12.2 and migration to a new server

We upgraded Oracle Database from 11.2.0.4 to 12.2.0.1 and moved it to a new high-end server within a one-month deadline.

Effort
95 hours
Engagement model
Outstaff
Client
Enterprise

Project goals

  • Upgrade Oracle Database from 11.2.0.4 to 12.2.0.1
  • Move the database to a new high-end server
  • Defragment and consolidate data inside the database to reclaim space and improve performance
  • Implement the Oracle Database In-Memory option
  • Implement the Multitenant database architecture

What we delivered

  • Completed the upgrade and the migration within the one-month project deadline
  • Made the tight deadline possible by combining the upgrade and the migration into a single Oracle Data Pump export/import process
  • Resolved complex ETL performance issues that appeared after the migration by optimizing the database parameters of the target configuration
  • Implemented the Multitenant and In-Memory options

Project team

  • Senior Oracle Database architect
  • Senior Oracle DBA

Need a similar project?

Book a free 30-minute consultation and we will explain how we would approach it.