How to perform oracle database 11g version update to oracle database 19C

Authors

  • Ricardo Rodrigues Brito FAMETRO Author
    • Roberto Cesar Mestrinho de Oliveira Filho FAMETRO Author https://orcid.org/0000-0001-7440-3863
      • Rilmar Pereira Gomes FAMETRO Author
        • José Roberto Lira Pinto Júnior FAMETRO Author
          • David Barbosa de Alencar ITEGAM Author

            DOI:

            https://doi.org/10.31686/ijier.vol9.iss7.3243

            Keywords:

            Oracle 11g, Oracle 19c, Update off Version, Roadmap

            Abstract

            Due to the discontinuity of support for one of the database versions most used by organizations, Oracle Database 11g, it is important that companies that still use this version, pay attention to the next upgrade from Oracle. This work was elaborated by means of exploratory research, using as methods and research techniques the documentary and bibliographic analysis, with the purpose of providing steps with techniques and methods of how to proceed with two oracle projects, one of migration from the Linux operating system Red Hat 4.4.7-3 for Oracle Linux 7.7, and a version upgrade from Oracle Database 11g to Oracle Database 19c, presenting strategies using tools and following Oracle's recommendations. This study was built based on real demands that companies have been facing with this great dilemma, the discontinuity of support for the Oracle database 11g version. The observed results were, official support from Oracle, architectural change in order to be prepared for a supposed intervention with updating and migration of services to the cloud.

            Author Biographies

            • Ricardo Rodrigues Brito, FAMETRO

              Graduate department of the university center

            • Roberto Cesar Mestrinho de Oliveira Filho, FAMETRO

              Graduate department of the university center

            • Rilmar Pereira Gomes, FAMETRO

              Graduate department of the university center

            • José Roberto Lira Pinto Júnior, FAMETRO

              Graduate department of the university center

            References

            GIL, A. C. (2008). MÉTODOS E TÉCNICAS DE PESQUISA SOCIAL. SÃO PAULO: EDITORA ATLAS S.A.

            ORACLE. (2001). INTRODUCTION TO ORACLE DATABASE. Acesso em 2020, disponível em INTRODUCTION TO ORACLE DATABASE: https://docs.oracle.com/database/121/CNCPT/intro.htm#CNCPT001

            ORACLE. (2016). UPGRADINGAND MIGRATINGTO ORACLE DATABASE 12CRELEASE 2(12.2.0.1). Acesso em 2021, disponível em UPGRADINGAND MIGRATINGTO ORACLE DATABASE 12C RELEASE 2(12.2.0.1): https://www.oracle.com/technetwork/database/upgrade/overview/upgrading-oracle-database-wp-122-3403093.pdf

            ORACLE. (2019). UPGRADE AND MIGRATE TO ORACLE DATABASE 19C. Acesso em 2021, disponível em UPGRADE AND MIGRATE TO ORACLE DATABASE 19C: https://www.oracle.com/africa/a/tech/docs/twp-upgrade-oracle-database-19c.pdf

            ORACLE. (2021). DATABASE UPGRADE GUIDE. Acesso em 2021, disponível em DATABASE UPGRADE GUIDE: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/index.html

            ORACLE. (2021). ORACLE DATABASE 11G DOCUMENTATION. Acesso em 2021, disponível em ORACLE DATABASE 11G DOCUMENTATION: https://docs.google.com/document/d/1mp8erFFM2HnaFRImk9GrWz9Fy7LM0GTiWlB91m_hMII/edit#

            ORACLE. (2021). ORACLE DATABASE 19C. Acesso em 2021, disponível em ORACLE DATABASE 19C: https://www.oracle.com/br/database/technologies/

            ORACLE. (2021). ORACLE LINUX. Acesso em 2021, disponível em ORACLE LINUX: https://www.oracle.com/linux/

            ORACLE. (2021). ORACLE MULTITENANT . Acesso em 2021, disponível em ORACLE MULTITENANT : https://www.oracle.com/br/database/multitenant/

            ORACLE. (2021). ORACLE RECOVERY MANAGER (RMAN). Acesso em 2021, disponível em ORACLE RECOVERY MANAGER (RMAN): https://www.oracle.com/database/technologies/high-availability/rman.html

            Downloads

            Published

            2021-07-01

            How to Cite

            Brito, R. R., Filho, R. C. M. de O., Gomes, R. P., Júnior, J. R. L. P., & Alencar, D. B. de. (2021). How to perform oracle database 11g version update to oracle database 19C. International Journal for Innovation Education and Research, 9(7), 361-371. https://doi.org/10.31686/ijier.vol9.iss7.3243