EXADATA Hardware Migration - X9 to X10

As part of an EXADATA hardware upgrade, the client planned to migrate from X9 servers to X10 servers, beginning with NON-PROD environments, followed by PRODUCTION and the recently upgraded 19c databases. While the PROD and NON-PROD migrations were successful, significant challenges arose in stabilizing the 19c upgraded instances. To resolve this, critical system adjustments were made, ensuring operational stability and enabling further upgrades.

Problem

Statement

The migration of 19c upgraded instances presented several challenges that hindered progress:

The client could not proceed with further upgrades until the existing 19c instance issues were addressed.
A critical autoconfig issue in the 4-NODE RAC environment needed resolution.
The issue became a showstopper, preventing any further upgrade activities.

Solution

Proposed

To restore system stability, all XML and TNS file modifications directing configurations to the new X10 servers were removed and the process was restarted from scratch.

After attempting 30+ solutions and consulting an external Centroid DBA without success, the issue was finally resolved after 25 days of troubleshooting using a combination of four key solutions:

Redirecting TNS entries to the GLOBAL name instead of PDB or CDB.
Configuring the correct limit values in SQLNET.ORA.
Ensuring proper service parameter settings for the GRID listener.
Setting LOCAL LISTENER values to use the hostname instead of the IP address, following 19c best practices.

Post-implementation testing confirmed that all systems were fully operational.

Business

Values

With the issue resolved, the client was able to proceed with the next upgrade instance, which had been on hold for over a month. The successful migration allowed the upgrade process to continue, leading to the decommissioning of the legacy X9 servers and a smooth transition to the X10 infrastructure.

Other Case Studies

QA Test Automation

The OMS Web Application is a critical system managing inventory, load handling, invoicing, deliveries and order processing...

BB Support Portal - Centralized Data Management

Managing data for over 250+ employees using Excel spreadsheets was inefficient and prone to errors. To address this, the BB Support Portal Application...

Onelign Traceability

FDA's Drug Supply Chain Security Act (DSCSA) mandates an electronic tracing system for drugs at the package level to ensure the verification of legitimacy of the drugs ...

OMS Online

The challenge lies within a prominent wholesale supply chain services company in the United States, operating over 70 distribution centers catering to both Retas...

IT Modernization

The existing applications, which were built using Struts 1.x and Vaadin 7.x, are outdated and hard to maintain. These technologies had several security flaws, as...

SourceLink, UAM, MESA - Angular and Java

The primary challenge was to enhance and keep the performance and security of existing applications while concurrently...

Sail Point IIQ

SailPoint IdentityIQ (IIQ) is an identity and access management (IAM) solution designed to help organizations manage user identities, access rights and permissions...

Order Spikes Analysis

Order Spikes Analysis is the process of identifying, analyzing and understanding sudden increases in order volume within a specific timeframe...

Product Data Hub Implementation

Phase 1 of PDH led to redundant attributes, causing data inefficiencies. To address this, custom scripts were developed...

Devops

Migrating CI/CD pipelines from Bamboo and Bitbucket to Azure DevOps (ADO) enhanced scalability, automation and efficiency. Jira automation streamlined release...

Empowering Data-Driven Decision Making for Manhattan

An automated data integration system and real-time interactive dashboard were implemented to streamline analytics...