Migrate/Upgrade to Oracle12c

Oracle 12c is perhaps one of the biggest releases of Oracle database ever. With features such as Oracle Multitenant, online datafile movement, cross-platform movement and many more, Oracle Database 12c provides and even stronger feature set, providing power and flexibility for both administrators and users. 

In these tough economic times, organizations are trying to lower costs in all of their business operations. One key method for cutting IT costs is migration: migration to hardware that is less expensive to purchase and operate; migration to less costly operating systems; and migration away from older versions of Oracle to reduce costs of extended support contracts.  The key challenges of migrations relate to their potential to disrupt the business. Therefore, organizations need strategies to minimize user downtime

There are many methods, tools and technologies for migrating your database to Oracle 12c but generally speaking they fall into two broad categories: physical migration and logical migration. While there are several factors that determine which method is best, the decision making process is usually dominated by one key factor, the available down time to complete the move. The good news is that DBORA Consulting has hands on experience in migrating life production databases to Oracle 12c and have developed there are several strategies to help you get there. 

The following are the main phases we use for Oracle Exadata migration projects:-

1. Planning and Discovery phase.

In this phase we establish some perimeters on the best migration strategy given the business service level, system attributes and the source database version. A high level project plan would also be developed during this phase.

2. Data Collection and Analysis phase.

In this phase, resource (CPU, I/O and Memory) capacity analysis of the source database/s is performed using our in-house performance forecasting tools to ensure we take into consideration when using the various Oracle 12c features. The exercise would also take into account weather Oracle 12c is being used for database consolidation hence the use of Oracle Multitenant feature.  

3. Detail Migration Strategy and Plan phase. 

In this phase a detail technical discussion and analysis is conducted to develop the most appropriate migration strategy that meets the requirement of the business. Certain critical acid test would also be carried out to firm out migration plan timeline. The plan would also incorporate necessary migration checkpoint and fall-back strategy. 

4. Migration phase

In this phase the migration is executed as per the detail migration plan developed. This plan is assumed to have gone through the relevant change and risk management process including audit.

5. Post migration phase

Although performance improvement and optimized resource optimization is a pre-conceived expectation in moving to Oracle 12c, its not uncommon to find some application codes not performing as expected. Hence there is a need to carry out the usual performance fine tuning activities.  In this phase, a complete performance analysis is conducted to fine-tune the business application from the Oracle 12c perspective and establish a performance baseline.


We highly recommed customers to conduct SQL performance test using Oracle Real Application Testing tool (RAT) to quality assure the performance of the SQL code when migrating into Oracle 12c if the source database is below Oracle 10g. Although this is not part of our standard Oracle 12c migration service option, we are more than capable of undertaking this task as part of the overall migration strategy. 



There is absolutely no substitute for experience. We have significant hand-on experience in undertaking Oracle 12c migration/upgrade to ensure it is succesfully completed. 

We promote high skills transfer in undertaking Oracle 12c migration/upgrade projects to ensure in-house DBA's are sufficiently trained to handle first level support.