Sparity’s collaboration with client leading global technology & engineering company providing innovative solutions for customers in industrial and residential markets, involved crucial task of upgrading their database from 12C to 19C, with the objective of reducing the turnaround time for delivering critical information to the applications team.
ClientEngineering and Technology ServicesDatabase, Upgrades, System Management Year 2023
Key Challenges
- Client required Applications upgrade from 12.1.3 to R12.2.10 along with Code level upgrade while maintaining uninterrupted 24/7 system access.
- They faced difficulty of delayed ticket resolution due to the complexity of database network .
- Manual data collection and formatting process for error log data retrieval adds to the ticket resolution challenge.
Technologies
Solution
- Sparity Functional and Technical teams conducted rigorous testing of the upgraded non-production environments to identify any issues post upgrade
- Sparity Conducted weekly, monthly, quarterly checks to monitor Health checks of the database.
- Our DBA team coordinated with the company’s IT department to reduce Severity 1 alerts.
- Also provided ongoing support by monitoring tools and implementing innovative solutions.
- We verified backup accuracy through test databases and introduced architectural changes for streamlined administration.
- We worked with the Oracle support team on the identified issues in upgraded environments and transitioned to RMAN for database backups instead of disk-level backups.
Benefits
- Improved performance and new features with the upgraded version of the database benefitted the client by boosting productivity and competitiveness.
- Cloning now got easier with RMAN automation which supports production for high-end reports usage, leading to cost savings and operational efficiency.
- Significantly reduced Turn Around Time for Application Team by 35%, resulting in increased productivity and faster project delivery.
- Facilitated database upgrade in minimal downtime and zero issues, ensuring minimized business disruptions.
