Our logistics client, who is one of the largest international logistics providers driving economic growth via Airfreight, Seafreight, Road and Rail, required a comprehensive health check and ongoing support for their two critical Oracle databases, which power the JD Edwards Logistics package and are crucial for their distribution function.
The JD Edwards innovation
JD Edwards is an enterprise resource planning suite for small to medium organisations. The system is traditionally hosted on-premises, but through the Blue Crystal and NDevr collaboration, we can enable any customer to run it from the cloud.
The Challenge
Our client faced multiple challenges that hindered its operational efficiency. Paramount was the burden of outdated database versions. Struggling with Oracle version 112.0.3, our client was facing instability and lacking assurances of future support. Additionally, performance issues plagued the system, exacerbated by non-scalable custom code. As the client base grew, so did the strain on the system, with persistent memory errors hinting at underlying bugs. Backup and recovery concerns loomed large as well, as the existing Veeam snapshot-based backups proved inadequate. Our client urgently needed a robust, dedicated database backup strategy. To compound matters, the absence of a Disaster Recovery (DR) environment left the company vulnerable to potential business disruptions.
How We Stepped In
Blue Crystal Solutions embarked on a journey to revitalise our client’s Oracle databases. Our approach was comprehensive, addressing each of their pain points with precision. Our client required a comprehensive health check and ongoing support for their two critical Oracle databases, which support the JD Edwards Logistics package and are essential for their distribution function. Firstly, we advocated and facilitated a seamless upgrade to Oracle 12c, ensuring enhanced features and comprehensive support. With performance optimisation as a priority, we delved deep into diagnostics and tuning, targeting and rectifying bottlenecks, particularly within custom code segments. We crafted a tailored RMAN backup strategy to fortify our client’s data integrity and slash recovery times. Additionally, we introduced a bespoke data purging and archiving regimen, streamlining database size management for smoother operations.
The Transformation
Our intervention sparked a remarkable transformation for our client. The upgrade to Oracle 12c and the resolution of scalability issues injected newfound stability and turbocharged system performance. With our robust RMAN backup strategy, our client gained confidence in data integrity and resilience against potential threats. Moreover, our purging and archiving strategy lightened the database load, fostering faster access and smoother operations. We fortified our client’s resilience and readiness for future challenges by laying the groundwork for a potential DR environment.
In partnership with Blue Crystal Solutions, our client overcame immediate obstacles and emerged stronger, more agile, and with a more secure environment, poised for future success.
Oracle and Blue Crystal Solutions
We have been Oracle Partners since our beginning in 2004. Our history has enabled us to become experts in Oracle technology and the innovations their tools can enable.
Our longevity in the market tells us that technology isn’t one-size-fits-all. That’s why, as an Oracle partner, we always collaborate to create joint solutions for our clients.
We have been implementing solutions with every Oracle Database release since 10g, as well as with Oracle Middleware and Oracle eBusiness Suite (EBS), on-premises and in the cloud.
As an Oracle Partner since our beginning, we’ve grown into a specialised supplier of cloud, application, database, infrastructure and operating system management, modernisation and transformation services, all fortified by our integrated outage protection tool – BlueDiamond.
