Oracle Database Upgrade for Life Sciences Manufacturer

This case study outlines the successful upgrade of the Oracle database and applications for a US-based manufacturer in the life sciences sector. The client, a privately owned company in Massachusetts, faced the challenge of upgrading from Oracle DB version 12.1, which was nearing the end of extended support. The upgrade involved a complex migration of over 1000 heavily customized database and application objects within a tight six-month deadline. Apptread developed a detailed project plan that included two test upgrade rounds, a mock run, and the final Go Live cutover. Collaboration among various stakeholders, including database administrators and performance teams, was crucial throughout the process. Load testing was conducted to simulate a 150-user environment, ensuring the system's performance met the necessary standards. The successful execution of this upgrade resulted in improved system reliability and positioned the client to leverage future technological advancements in the life sciences industry.