Oracle Version Upgrade and Performance Tuning

Client is a manufacturer of filtration systems and packaging materials based in Franklin, Tennessee for the past 100 years and expanded their business operations to United Kingdom.
Business Needs
  • Oracle EBS is being utilized for Financials, Procure to Pay cycles by
    customer. Client was using version. Client wanted to upgrade to EBS R12.2 with end-to-end Oracle application performance monitoring tools.
  • Improve end-user response time (application performance).
  • Improve database performance.
  • Accelerate root-cause identification for performance problems.
  • Improve collaboration between DBAs,VMs, developers, operations and other IT teams.
Our Solutions
  • Helped customer upgrade to R12.2 using a like to like model.
  • Migrated/Implemented new functionality and nice to have customizations after upgrade to minimize cost and to reduce risk on the upgrade project.
  • Installed Oracle OEM 12c monitoring tool for database and application issues. It has a single interface for all databases and applications.
  • OS (UNIX) and network related issues, installed DevOps tool (Nagios).
  • Using Nagios tool DBAs and VM admins can now collaborate to resolve issues in a smoother manner.
  • Reduced the amount of finger poin ng and instead let us focus on resolving the issues
Business Benefits
  • All customizations in 11i were successfully migrated to R12.2 post upgrade and included complex upgrades in financials and procurement.
  • Increased database performance and end user experience Improved visibility into their environment and improved collaboration (less finger pointing for troubleshooting).
  • Achieved faster problem resolution and more proactive management of databases.
  • Has the ability to find problems and resolved.