A very complex Oracle EBS 12.2.9 upgrade made easy

A very complex Oracle EBS 12.2.9 upgrade made easy

Buxton helped an American biopharmaceutical company headquartered in Foster City, California, with upgrading a very large, complex Oracle EBS, OBIEE application and the corresponding databases in a record time using a custom solution.

Client Profile

Industry: Pharmaceuticals and Biotechnology

Location: Foster City, CA

Specialty: Research & Development of Antiviral Drugs

Challenges

Client wanted to upgrade its large and extremely complex Oracle EBS and OBIEE environments running on an older hardware platform. With strict healthcare compliance requirements and very high documentation standards, client was looking for an error-free upgrade with minimal disruption to the business. Scope also included migrating to new hardware, implementing high availability, establishing new disaster recovery processes, testing for site failover, and implementing reverse proxy and TLS security at every layer. Additionally, this client needed to integrate the Oracle EBS system with a newly acquired company.

Our Solution

Buxton’s team of DBAs migrated the client’s Oracle EBS environment to new hardware, upgraded Oracle databases to 12c and upgraded Oracle EBS (12.2.9) and OBIEE environments using Buxton proprietary tools in record time per Oracle Corporation’s “audit” findings. Buxton Implemented High Availability using Oracle RAC. We also implemented TLS security at every layer of OS, Network, Storage, Database, application, and web. Implemented disaster recovery solution with a minimal failover time. Solution also included reverse proxy for external users. Buxton helped fine-tune several poorly performing custom programs as well. Buxton exceeded client’s documentation standards. This project was executed with a combination of onshore and offshore resources.

Business Impact

The traditional method of platform migration would have taken several days to migrate. With Buxton’s Innovative custom solution, databases and applications were migrated to new hardware server. Buxton completed the DB and Applications upgrade along with platform migration in a single short downtime(2.5 days) window. Oracle audited Buxton’s process and certified the Buxton solution was the best possible solution and that there were no alternative ways to improve system performance or upgrade. There were no single “point” of failure in the entire architecture. Project was executed flawlessly.

For further information on this project or to discuss a similar requirement