Oracle E-Business Suite hosted on AWS for a leading pipe manufacturers delivering strong uptime and high flexible infrastructure.

A company that immensely believes in “The systems is Quality & Reliability”, have been certified by quality Assurance Services, Australia. The ISO 9001 certification are recent development with a high prestigious certification. As the business of the company had higher expectation on uptime of the ERP, investments to ensure the same were proposed with the management. With the new process in progress, requirement of a new IT setup was required with minimum TCO. They also did not want to refresh the current IT infrastructure by investing on Capex and invest the funds for business enhancement instead. Maintaining the quality and adhering to the processes in place, Oracle E business suite ERP was finalized. The management wanted the systems to be available as per the operation demand with a lower investment on infrastructure. PSSPL being an advanced tier solution provider, introduced AWS to the customer to host its ERP and managed services to optimize the infrastructure and application performance with high availability, capacity planning to meet the demand of the IT operations.

On multiple discussion with the CXO’s in-line with the future roadmap of the company, we noted down few challenges faced by them which needed immediate solutions.

1. Customer being a manufacturer with distributed operations and manufacturing units, accessing the application and availability was a major challenge.
2. Multiple downtime in the past due to local problems like power failure and system errors had already impacted the goodwill of the customer to its customers and 10-12% business loss for them.
3. With an upfront investment on the licenses, they were looking for a solution which will help them avoid any initial investment and projected infrastructure provisioning.
4. Being an exporter, the operations and transactions are more during month end and the servers were under-utilized throughout the month.
5. Maintaining an in-house data center was becoming difficult due system management, achieving uptime and non-availability of skilled technical resources.

PSSPL along with AWS, prepared a solution on the challenges faced by the customer. In order to achieve a better customer experience, we not only worked with them for the ERP hosting but on a holistic restructuring of the network and security across offices and manufacturing units. With a redefined LAN setup and connecting the offices through SD WAN we ensured that the users are well connected and have better accessibility to the applications.

Versions: Oracle 12c 12.1.0.1.v1

PSSPL along with the IT and business team of the client conducted an extensive infrastructure evaluation which included assessment, migration strategy and DBA support for oracle 12c database as well as application. Understanding the customer concern, we initiated a POC to test the application performance on AWS platform. We also listed all the findings and evaluated the Migration of Oracle EBS application to cloud infrastructure in AWS Singapore region. Post successful POC, the deployment was implemented in Production.
The 2 Tier application Oracle EBS application and Oracle DB was deployed in 2 Subnets for Isolation. Required NACL & security Group was applied to ensure required IP’s have access. Oracle EBS application was deployed with auto-scaling in-place to mitigate scalability & availability of application as and when number of users accessing the application increases.

Oracle 12c Database was configured in Multi-AZ which helped to automatically provision and maintain a secondary standby DB instance in a different Availability Zone. The primary DB instance is synchronously replicated across Availability Zones to the secondary instance. This approach helped to provide data redundancy and failover support, also to eliminate I/O freezes, and minimize latency spikes during system backups. We also configured A separate Read Replica to provide enhanced performance and durability for RDS database (DB) instances. It made easy to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads that customer was performing. AWS Web application Firewall (WAF) service was suggested for application security, Data Encryption at rest was configured, as the management had concerns on security. Implementation of Nagios tool to monitor & notification for the performance of the system and auto scaling to match the infrastructure requirement were setup.

The deployment of Oracle EBS on AWS was delivered on reliable and cost-effective solution meeting all the business-critical needs of the client. Scheduled backups for data protection and snapshots were implemented to meet the application availability with define RTO and RPO of 1 hour. PSSPL, approach of structuring the infrastructure so as to assure the committed infrastructure uptime & rapid adaptation of solution were discussed and implemented. Configured lambda and SNS for reporting and notification. DB tuning, cloning, performance optimization, space administration, RMAN backup for oracle database.