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

Ricardo Rodrigues Brito; Roberto Cesar Mestrinho de Oliveira Filho; Rilmar Pereira Gomes; José Roberto Lira Pinto Júnior; David Barbosa de Alencar

doi:10.31686/ijier.vol9.iss7.3243

Authors

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

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.

Downloads

Download data is not yet available.

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