Home Clients Case study Upgrading the database for CAMGSM – CAMBODIA

Upgrading the database for CAMGSM – CAMBODIA

INTRODUCTION TO CELLCARD

Cellcard is the brand of CamGSM Co. Ltd, a company established in 1996 as a joint stock company between Luxembourg-based Millicom International Cellular S.A. and Cambodia’s Royal Group of Companies.

Established in 1998, Cellcard is one of the pioneering companies in Cambodia, fully integrated with all types of telecommunications services, providing comprehensive mobile communications and entertainment services to individual customers and the business market. This includes advanced services such as voice, messaging, international roaming services, wireless broadband, and value-added services.

CHALLENGES - PROJECT REQUIREMENTS

Objectives

  • Transfer the entire database to a new server because the old server can no longer be upgraded or expanded in terms of hardware.

  • Upgrade the entire database from version 11G R2 to version 19C.

  • Optimize the new system.

  • Meet future scalability needs, avoiding scattered investments.

  • Utilize the new features of version 19C to speed up data processing, reduce response time to customer requests, and increase competitiveness compared to rivals. 

  • Move the database to a server with a strong configuration and high-speed SAN to serve data exploitation for new business strategies.

Challenges

  • The customer is a large telecommunications company in Cambodia, operating 24/7.

  • The project involves both onsite implementation at Cellcard in Cambodia and remote work from Ho Chi Minh City, Vietnam, with engineers communicating through software.

  • Upgrade the database from version 11G to 19C while migrating to a new server, ensuring that the new server has the same public IPs, private IPs, VIP IPs, and Scan IPs as the old system.

  • The customer’s applications should not require any changes to connect to the upgraded database.

  • The old system must continue to operate normally. 

  • Transfer and upgrade the entire Oracle Real Application Cluster (RAC) database, with a total capacity of up to 25 Terabytes (TB), within a very short downtime of 3 hours.

SERVICES PROVIDED BY HPT

  • Set up public IPs, private IPs, VIP IPs, and Scan IPs identical to the running database system.

  • The network system department uses techniques to prevent IP conflicts between the new and old systems.

  • Install the Oracle RAC 3 nodes 11G system on the new server.

  • On the new system, create an additional IP with a different address to synchronize the database from the old system to the new one through this IP.

  • After synchronization, the DBA team upgrades the database version from 11GR2 to 19C simultaneously for all three databases on the new system, with three engineers working concurrently on the three RAC nodes.

BENEFITS BROUGHT

  • The project was completed within the allowed downtime, with the entire database transferred and upgraded to the new system.

  • It meets the customer’s future development needs and supports new development strategies that require the operational capabilities of the new system.

  • The customer highly appreciates the engineers’ efforts, the quick handling of issues, and the coordinated implementation.

Posted News