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.
