ijier logo

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

    https://orcid.org/0000-0001-7440-3863

    Author

  • Rilmar Pereira Gomes

    FAMETRO

    Author

  • José Roberto Lira Pinto Júnior

    FAMETRO

    Author

  • David Barbosa de Alencar

    ITEGAM

    Author

Keywords:
Array, Array, Array, Array
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
  1. Ricardo Rodrigues Brito, FAMETRO

    Graduate department of the university center

  2. Roberto Cesar Mestrinho de Oliveira Filho, FAMETRO

    Graduate department of the university center

  3. Rilmar Pereira Gomes, FAMETRO

    Graduate department of the university center

  4. 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
Section
Journal Articles
License

Copyright (c) 2021 Ricardo Rodrigues Brito, Roberto Cesar Mestrinho de Oliveira Filho, Rilmar Pereira Gomes, José Roberto Lira Pinto Júnior, David Barbosa de Alencar

Creative Commons License

This work is licensed under a Creative Commons Attribution-NoDerivatives 4.0 International License.

Copyrights for articles published in IJIER journals are retained by the authors, with first publication rights granted to the journal. The journal/publisher is not responsible for subsequent uses of the work. It is the author's responsibility to bring an infringement action if so desired by the author for more visit Copyright & License.

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