A Framework for Near-Zero Downtime Oracle Database Upgrades and Grid Infrastructure Patching in Mission-Critical Enterprise Environments: A Production-Validated Approach
DOI:
https://doi.org/10.22399/ijcesen.3670Keywords:
Upgrade, Downtime, DBMS_ROLLING, TLS, Ansible, PatchingAbstract
In this paper, a production-proven methodology of zeroing down in times during Oracle database upgrades and Grid Infrastructure patching in corporate networks is a subject of introduction. It combines DBMS_ROLLING, Transient Logical Standby and Ansible orchestration to allow upgrades and rolling patches to be carried out seamlessly. The framework was implemented on 5,000+ databases and 40+ key applications without ever affecting service availability and the cutover took less than 5 minutes. Some of the notable characteristics are real-time lag monitoring, readiness to roll off and automated validations. The solution yielded cost savings of more than $100 million and safeguarded over $850 million of the revenue stream and has shown a scalable, resilient and completely automated roadmap towards consistent availability of the Oracle system
References
[1]Malhotra, A., Elsayed, A., Torres, R. and Venkatraman, S., 2023. Evaluate solutions for achieving high availability or near zero downtime for cloud native enterprise applications. IEEe Access, 11, pp.85384-85394.
[2]Oloruntoba, O., 2024. Business continuity in database systems: The role of data guard and oracle streams. World Journal of Advanced Research and Reviews, 22(3), pp.2266-85.
[3]Manda, P., 2023. Migrating Oracle Databases to the Cloud: Best Practices for Performance, Uptime, and Risk Mitigation. International Journal of Humanities and Information Technology, 5(02), pp.1-7.
[4]Brian, P., George, T. and Edward, W., 2023. Enhancing Disaster Recovery and Failover Strategies in Oracle Cloud Databases.
[5]Lasantha, N.C., Abeysekara, R. and Maduranga, M.W.P., 2023. Enhancing Security in Database Grid Infrastructure for Storage Clusters. WSEAS Transactions on Computers, 22, pp.233-242.
[6]Santoso, M.H. (2021). Application of Association Rule Method Using Apriori Algorithm to Find Sales Patterns Case Study of Indomaret Tanjung Anom. Brilliance: Research of Artificial Intelligence, 1(2), pp.54–66. Available at: https://doi.org/10.47709/brilliance.v1i2.1228
[7]Higginson, A.S., Bostock, C., Paton, N.W. and Embury, S.M. (2022). Placement of Workloads from Advanced RDBMS Architectures into Complex Cloud Infrastructure. Research Explorer The University of Manchester. [online] Available at: https://doi.org/10.48786/edbt.2022.43
[8]Hallin, J. (2025). Evaluation of TLS and mTLS in Internet of things systems. [online] DIVA. Available at: https://www.diva-portal.org/smash/record.jsf?pid=diva2:1937634 [Accessed 5 Aug. 2025].
[9]WilliamDAssafMSFT (2025). Serverless compute tier - Azure SQL Database. [online] Microsoft.com. Available at: https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql [Accessed 5 Aug. 2025].
[10]Oracle (2025). Using DBMS_ROLLING to Perform a Rolling Upgrade. [online] Oracle.com. Available at: https://docs.oracle.com/database/121/SBYDB/dbms_rolling_upgrades.htm [Accessed 5 Aug. 2025].
[11]Orlando, K.R. (2021). Automating Virtual Patching via Application Security Testing Tools. Ntnu.no. [online] Available at: no.ntnu:inspera:74730471:46733353 [Accessed 5 Aug. 2025].
[12]Bekir Tolga Tutuncuoglu (2025). Zero-Downtime AI: Predictive and Autonomous Server Restoration Without Human Input. [online] Available at: https://doi.org/10.2139/ssrn.5249062
[13]Simon (2022). 21c, Zero-Downtime Oracle Grid Infrastructure Patching - Fernando Simon. [online] Fernando Simon. Available at: https://www.fernandosimon.com/blog/21c-zero-downtime-oracle-grid-infrastructure-patching/ [Accessed 5 Aug. 2025].
[14]Hansen, D.O. (2024). xtts – Databases Are Fun. [online] Databases Are Fun. Available at: https://dohdatabase.com/tag/xtts/ [Accessed 5 Aug. 2025].
[15]Ma, Z., Austgen, J., Mason, J., Durumeric, Z. and Bailey, M. (2021). Tracing your roots. Proceedings of the 21st ACM Internet Measurement Conference, pp.179–194. Available at: https://doi.org/10.1145/3487552.3487813
[16]Kasarapu, S., Shukla, S. and Sai, D. (2024). Enhancing IoT Malware Detection through Adaptive Model Parallelism and Resource Optimization. [online] arXiv.org. Available at: https://arxiv.org/abs/2404.08808 [Accessed 5 Aug. 2025].
[17]Nicolazzo, S., Nocera, A. and Pedrycz, W. (2024). Service Level Agreements and Security SLA: A Comprehensive Survey. [online] arXiv.org. Available at: https://arxiv.org/abs/2405.00009
[18]Punithavathy, E. and Priya, N. (2024). Auto retry circuit breaker for enhanced performance in microservice applications. International Journal of Electrical and Computer Engineering (IJECE), [online] 14(2), p.2274. Available at: https://doi.org/10.11591/ijece.v14i2.pp2274-2281
[19]Raval, V. (2025). Recommendations to Improve Project Delivery Process for Better Customer Experience and Trust. Theseus.fi. [online] Available at: http://www.theseus.fi/handle/10024/892298
[20]Parker, S.K. and Grote, G. (2022). Automation, Algorithms, and Beyond: Why Work Design Matters More than Ever in a Digital World. Applied Psychology, 71(4), pp.1171–1204. Available at: https://doi.org/10.1111/apps.12241
[21]Andile Dlamini (2024). Machine Learning Techniques for Optimizing Recurring Billing and Revenue Collection in SaaS Payment Platforms. Journal of Computational Intelligence, Machine Reasoning, and Decision-Making, [online] 9(10), pp.1–14. Available at: https://morphpublishing.com/index.php/JCIMRD/article/view/2024-10-04 [Accessed 5 Aug. 2025].
[22]Fu, G. and Bryk, G. (2024). BrM Quantity-Based Bridge Element Deterioration/Improvement Modeling and Software Tools. [online] Available at: https://doi.org/10.36501/0197-9191/24-005
[23]Jagruti Jasleniya (2018). Using DBMS_ROLLING to Upgrade the Oracle Database - ORACLE-HELP. [online] ORACLE-HELP. Available at: http://oracle-help.com/dataguard/using-dbms_rolling-to-upgrade-the-oracle-database/ [Accessed 5 Aug. 2025].
[24]Mensah, I.O., Barrett, B. and Cahalane, C. (2024). Assessing Change Point Detection Methods to Enable Robust Detection of Early Stage Artisanal and Small-Scale Mine (Asm) in the Tropics Using Sentinel-1 Time Series Data A*Mensah Isaac Obour, Bbarrett Brian, and Acahalane Conor a Department of Geography, Maynooth University, Ireland. B School of Geographical and Earth Sciences, University of Glasgow, Scotland, UK. [online] Available at: https://doi.org/10.2139/ssrn.4991469
[25]Baljon, K., Romli, M.H., Ismail, A.H., Khuan, L. and Chew, B.-H. (2022). Effectiveness of Breathing Exercises, Foot Reflexology and Massage (BRM) on Maternal and Newborn Outcomes Among Primigravidae in Saudi Arabia: A Randomized Controlled Trial. International Journal of Women’s Health, Volume 14, pp.279–295. Available at: https://doi.org/10.2147/ijwh.s347971
[26]oracle.com (2025). Zero Downtime Database Upgrade Using Oracle GoldenGate. [online] Oracle.com. Available at: https://www.oracle.com/technetwork/middleware/goldengate/overview/ggzerodowntimedatabaseupgrades-174928.pdf [Accessed 6 Aug. 2025].
[27]Balbekov, A. (2013). Using EM 12c repository to find ASM growth rate. [online] OracleQuest. Available at: https://oraclequest.wordpress.com/2013/01/09/using-em-12c-repository-to-find-asm-growth-rate/ [Accessed 6 Aug. 2025].
[28]Sun, R. (2023). What should you know about Graph Database’s Scalability? [online] Medium. Available at: https://blog.devgenius.io/what-should-you-know-about-graph-databases-scalability-47c794da5c0b?gi=208d862cb7de [Accessed 6 Aug. 2025].
[29]Precedence research (2025). Robotic Process Automation Market Size, Report 2023-2032. [online] www.precedenceresearch.com. Available at: https://www.precedenceresearch.com/robotic-process-automation-market [Accessed 6 Aug. 2025]..
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 International Journal of Computational and Experimental Science and Engineering
This work is licensed under a Creative Commons Attribution 4.0 International License.
