NorthAlley

The collaboration between us and the leading global technology and engineering company aimed to upgrade their database from version 12C to 19C.
The primary objective was to reduce turnaround time for delivering critical information to the applications team.
Key challenges included the requirement for applications to upgrade from 12.1.3 to R12.2.10 with a code-level upgrade while maintaining uninterrupted 24/7 system access.
The complexity of the database network led to delayed ticket resolution, and manual data collection and formatting for error log data retrieval added to the challenge.

Our functional and technical teams conducted rigorous testing of the upgraded non-production environments to identify any issues post-upgrade.
Conduct weekly, monthly, and quarterly checks to monitor the health of the database.
The DBA team coordinated with the company's IT department to reduce Severity 1 alerts.
Provided ongoing support through monitoring tools and implementing innovative solutions.
Verified backup accuracy through test databases and introduced architectural changes for streamlined administration.
Collaborated with the Oracle support team to address identified issues in upgraded environments and transitioned to RMAN for database backups instead of disk-level backups.

Improved performance and new features with the upgraded database version, boosting client productivity and competitiveness.
Simplified cloning with RMAN automation, supporting production for high-end reports usage, leading to cost savings and operational efficiency.
Reduced Turnaround Time for the Application Team by 35%, resulting in increased productivity and faster project delivery.
Facilitated database upgrade with minimal downtime and zero issues, ensuring minimized business disruptions.

Upgrade the database from version 12C to 19C.
Reduce turnaround time for delivering critical information to the applications team.

Project outcomes