{"id":5214,"date":"2021-06-05T12:53:33","date_gmt":"2021-06-05T12:53:33","guid":{"rendered":"https:\/\/swiv.com.br\/upgrading-databases-in-oci-db-systems\/"},"modified":"2026-05-27T20:02:31","modified_gmt":"2026-05-27T19:02:31","slug":"upgrading-databases-in-oci-db-systems","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/06\/05\/upgrading-databases-in-oci-db-systems\/","title":{"rendered":"Upgrading Databases in OCI DB Systems"},"content":{"rendered":"\n
Podemos dizer que realizar o processo de Upgrade de banco de dados no OCI \u00e9 menos complicado do que em ambientes on-premises, por conta do encapsulamento\/automatiza\u00e7\u00e3o de diversas etapas. Neste artigo, vamos explorar como realizar o Upgrade de um banco 12C para 19C.<\/p>\n\n\n\n
Validando se nossa vers\u00e3o de S.O \u00e9 o Oracle Linux 7:<\/p>\n\n\n
\n[opc@luxor ~]$ sudo su -\nLast login: Mon May 31 08:34:49 UTC 2021\n[root@luxor ~]# cat \/etc\/*release*\nOracle Linux Server release 7.9\nNAME="Oracle Linux Server"\nVERSION="7.9"\nID="ol"\nID_LIKE="fedora"\nVARIANT="Server"\nVARIANT_ID="server"\nVERSION_ID="7.9"\nPRETTY_NAME="Oracle Linux Server 7.9"\nANSI_COLOR="0;31"\nCPE_NAME="cpe:\/o:oracle:linux:7:9:server"\nHOME_URL="https:\/\/linux.oracle.com\/"\nBUG_REPORT_URL="https:\/\/bugzilla.oracle.com\/"\n \nORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"\nORACLE_BUGZILLA_PRODUCT_VERSION=7.9\nORACLE_SUPPORT_PRODUCT="Oracle Linux"\nORACLE_SUPPORT_PRODUCT_VERSION=7.9\nRed Hat Enterprise Linux Server release 7.9 (Maipo)\nOracle Linux Server release 7.9\ncpe:\/o:oracle:linux:7:9:server\n<\/pre><\/div>\n\n\n
Confirmando se a vers\u00e3o do nosso GRID \u00e9 19C:<\/p>\n\n\n
\n[root@luxor ~]# dbcli describe-component\nSystem Version\n---------------\n21.1.3.3.0\n \nComponent Installed Version Available Version\n---------------------------------------- -------------------- --------------------\nGI 19.11.0.0.0 up-to-date\nDB 12.2.0.1.210420 up-to-date\n<\/pre><\/div>\n\n\n
Validando se os PDBs est\u00e3o abertos, e que o banco de dados est\u00e1 em modo Archivelog:<\/p>\n\n\n
\n[root@luxor ~]# exit\nlogout\n[opc@luxor ~]$ sudo su - oracle\nLast login: Sat Jun 5 07:25:25 UTC 2021\n[oracle@luxor ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 5 07:28:08 2021\n \nCopyright (c) 1982, 2016, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production\n \nSQL> show pdbs;\n \n CON_ID CON_NAME OPEN MODE RESTRICTED\n---------- ------------------------------ ---------- ----------\n 2 PDB$SEED READ ONLY NO\n 3 HIPOFISE1 READ WRITE NO\nSQL> ARCHIVE LOG LIST;\nDatabase log mode Archive Mode\nAutomatic archival Enabled\nArchive destination USE_DB_RECOVERY_FILE_DEST\nOldest online log sequence 8\nNext log sequence to archive 10\nCurrent log sequence 10\n<\/pre><\/div>\n\n\n
Confirmando que o banco possui o recurso de Flashback Database habilitado:<\/p>\n\n\n
\nSQL> SELECT NAME,FLASHBACK_ON FROM V$DATABASE;\n \nNAME FLASHBACK_ON\n--------- ------------------\nCORTEX YES\n<\/pre><\/div>\n\n\n
O upgrade pode ser realizar de 2 maneiras: OCI Console ou API (ou seja, DB CLI n\u00e3o \u00e9 poss\u00edvel), al\u00e9m de ser aplic\u00e1vel em ambientes BM ou VM. Aqui, vamo realizar o processo via Console. Em ambientes corporativos, \u00e9 extremamente indicado realizar um backup de seu ambiente. Caso exista alguma associa\u00e7\u00e3o de Data Guard, \u00e9 mister retir\u00e1-la. Se houver backups agendados, o ideal \u00e9 desabilit\u00e1-los, para n\u00e3o serem disparados durante o Upgrade. Al\u00e9m disso, \u00e9 importante realizar o Pr\u00e9-Check, para validarmos que o ambiente est\u00e1 apto para o Upgrade. E o \u00faltimo detalhe: caso o upgrade fosse de um banco 11G para 19C, o banco de dados n\u00e3o \u00e9 convertido automaticamente para arquitetura Multitenant (CDB).<\/p>\n\n\n\n
Na console do OCI, vamos na p\u00e1gina inicial do DB Sytem:<\/p>\n\n\n\n<\/figure>\n\n\n\n
Em Resources, clicamos em “Databases” e clicamos em nosso banco de dados:<\/p>\n\n\n\n<\/figure>\n\n\n\n<\/figure>\n\n\n\n
Na p\u00e1gina principal do Database, vamos em Resource, clicamos em “Updates” e identificamos a vers\u00e3o desejada:<\/p>\n\n\n\n<\/figure>\n\n\n\n
Clicamos no Menu da vers\u00e3o desejada, e vamos na op\u00e7\u00e3o de Pr\u00e9-Check:<\/p>\n\n\n\n<\/figure>\n\n\n\n
Confirmando:<\/p>\n\n\n\n<\/figure>\n\n\n\n
O status do Database \u00e9 alterado devido esse Pr\u00e9-Check que disparamos:<\/p>\n\n\n\n<\/figure>\n\n\n\n
Conseguimos acompanhar a evolu\u00e7\u00e3o do processo na parte de “Work Request”:<\/p>\n\n\n\n<\/figure>\n\n\n\n<\/figure>\n\n\n\n
Finalizado:<\/p>\n\n\n\n<\/figure>\n\n\n\n
Como o pr\u00e9-check n\u00e3o reportou nenhuma anomalia em nosso ambiente, podemos proceder com a migra\u00e7\u00e3o em si. Importante salientar que o Upgrade executa nos bastidores um pr\u00e9-check, cria um GRP (Guaranteed Restore Point), cria um novo DB Home, e executa o utilit\u00e1rio DBUA (Database Upgrade Assinstant). Clicando em “Upgrade”:<\/p>\n\n\n\n<\/figure>\n\n\n\n
Confirmando:<\/p>\n\n\n\n<\/figure>\n\n\n\n
Status do Banco fica em Upgrading:<\/p>\n\n\n\n<\/figure>\n\n\n\n
Acompanhando evolu\u00e7\u00e3o da Task:<\/p>\n\n\n\n<\/figure>\n\n\n\n<\/figure>\n\n\n\n
Depois de pouco mais de 3 horas, o Upgrade \u00e9 finalizado com sucesso:<\/p>\n\n\n\n<\/figure>\n\n\n\n
Validando nova vers\u00e3o do Banco de Dados:<\/p>\n\n\n
\n[oracle@luxor ~]$ exit\nlogout\n[opc@luxor ~]$ sudo su -\nLast login: Sat Jun 5 11:59:16 UTC 2021\n[root@luxor ~]# dbcli describe-component\nSystem Version\n---------------\n21.1.3.3.0\n \nComponent Installed Version Available Version\n---------------------------------------- -------------------- --------------------\nGI 19.11.0.0.0 up-to-date\nDB {\n[ OraDB12201_home1 ] 12.2.0.1.210420 up-to-date\n[ OraDB19000_home2 ] 19.11.0.0.0 up-to-date\n}\n<\/pre><\/div>\n\n\n
Percebemos que o DB Home antigo ainda permanece, e deve ser removido por n\u00f3s, ap\u00f3s o upgrade. Validando os DB Homes existentes:<\/p>\n\n\n
\n[root@luxor ~]# dbcli list-dbhomes\n \nID Name DB Version Home Location Status\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\n8bc7f0a5-6230-4b99-b568-b73cf0038525 OraDB12201_home1 12.2.0.1.210420 \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1 Configured\nd08b9441-b181-42b1-b6be-11616fa9580c OraDB19000_home2 19.11.0.0.0 \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_2 Configured\n<\/pre><\/div>\n\n\n
Removendo DB Home antigo:<\/p>\n\n\n
\n[root@luxor ~]# dbcli delete-dbhome -i 8bc7f0a5-6230-4b99-b568-b73cf0038525\n \nJob details\n----------------------------------------------------------------\n ID: 342f6cb1-295f-4fee-8b6e-4974f8584a92\n Description: Database Home OraDB12201_home1 Deletion with id 8bc7f0a5-6230-4b99-b568-b73cf0038525\n Status: Running\n Created: June 5, 2021 12:43:51 PM UTC\n Progress: 0%\n Message:\n \nTask Name Start Time End Time Status\n------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------\n<\/pre><\/div>\n\n\n
Acompanhando processo de remo\u00e7\u00e3o:<\/p>\n\n\n
\n[root@luxor ~]# dbcli describe-job -i 342f6cb1-295f-4fee-8b6e-4974f8584a92\n \nJob details\n----------------------------------------------------------------\n ID: 342f6cb1-295f-4fee-8b6e-4974f8584a92\n Description: Database Home OraDB12201_home1 Deletion with id 8bc7f0a5-6230-4b99-b568-b73cf0038525\n Status: Running\n Created: June 5, 2021 12:43:51 PM UTC\n Progress: 5%\n Message:\n \nTask Name Start Time End Time Status\n------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------\nDelete dbhome with ID: 8bc7f0a5-6230-4b99-b568-b73cf0038525 June 5, 2021 12:43:54 PM UTC June 5, 2021 12:43:54 PM UTC Running\n<\/pre><\/div>\n\n\n
Sucesso:<\/p>\n\n\n
\n[root@luxor ~]# dbcli describe-job -i 342f6cb1-295f-4fee-8b6e-4974f8584a92\n \nJob details\n----------------------------------------------------------------\n ID: 342f6cb1-295f-4fee-8b6e-4974f8584a92\n Description: Database Home OraDB12201_home1 Deletion with id 8bc7f0a5-6230-4b99-b568-b73cf0038525\n Status: Success\n Created: June 5, 2021 12:43:51 PM UTC\n Progress: 100%\n Message:\n \nTask Name Start Time End Time Status\n------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------\nDelete dbhome with ID: 8bc7f0a5-6230-4b99-b568-b73cf0038525 June 5, 2021 12:43:54 PM UTC June 5, 2021 12:46:13 PM UTC Success\n<\/pre><\/div>\n\n
\n[root@luxor ~]# dbcli list-dbhomes\n \nID Name DB Version Home Location Status\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\nd08b9441-b181-42b1-b6be-11616fa9580c OraDB19000_home2 19.11.0.0.0 \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_2 Configured\n<\/pre><\/div>\n\n\n
Al\u00e9m disso, \u00e9 bom validarmos tamb\u00e9m o par\u00e2metro COMPATIBLE, conforme abaixo:<\/p>\n\n\n
\n[root@luxor ~]# exit\nlogout\n[opc@luxor ~]$ sudo su - oracle\nLast login: Sat Jun 5 12:46:15 UTC 2021\n[oracle@luxor ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 5 12:47:36 2021\nVersion 19.11.0.0.0\n \nCopyright (c) 1982, 2020, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\nVersion 19.11.0.0.0\n \nSQL> show parameter COMPATIBLE\n \nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ncompatible string 12.2.0.0\nnoncdb_compatible boolean FALSE\n<\/pre><\/div>\n\n\n
Alterando o seu valor para 19.0.0:<\/p>\n\n\n
\nSQL> ALTER SYSTEM SET COMPATIBLE='19.0.0.0' SCOPE=SPFILE;\n \nSystem altered.\n \nSQL> exit\nDisconnected from Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\nVersion 19.11.0.0.0\n[oracle@luxor ~]$ srvctl stop database -db $ORACLE_UNQNAME -stopoption immediate -verbose\n[oracle@luxor ~]$ srvctl start database -db $ORACLE_UNQNAME\n[oracle@luxor ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 5 12:50:43 2021\nVersion 19.11.0.0.0\n \nCopyright (c) 1982, 2020, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production\nVersion 19.11.0.0.0\n \nSQL> SHO PARAMETER COMPATIBLE\n \nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ncompatible string 19.0.0.0\nnoncdb_compatible boolean FALSE\n<\/pre><\/div>\n\n\n
Por \u00faltimo, \u00e9 bom confirmarmos se o .bashrc est\u00e1 com as vari\u00e1veis exportadas para o novo DB Home:<\/p>\n\n\n
\n[oracle@luxor ~]$ cat .bashrc\n# .bashrc\n \n# Source global definitions\nif [ -f \/etc\/bashrc ]; then\n. \/etc\/bashrc\nfi\n \n# Uncomment the following line if you don't like systemctl's auto-paging feature:\n# export SYSTEMD_PAGER=\n \n# User specific aliases and functions\n## WARNING!! Modifying this file can cause failures in API\/CLI provided by Cloud Tooling!!\nORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_2; export ORACLE_HOME\nPATH=$PATH:\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_2\/bin; export PATH\nLD_LIBRARY_PATH=\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_2\/lib; export LD_LIBRARY_PATH\nORACLE_UNQNAME=CORTEX_phx1hb;export ORACLE_UNQNAME\nORACLE_SID=CORTEX; export ORACLE_SID\n[oracle@luxor ~]$\n<\/pre><\/div>\n\n\n
Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":"
Podemos dizer que realizar o processo de Upgrade de banco de dados no OCI \u00e9 menos complicado do que em ambientes on-premises, por conta do encapsulamento\/automatiza\u00e7\u00e3o de diversas etapas. Neste artigo, vamos explorar como realizar o Upgrade de um banco 12C para 19C. Validando se nossa vers\u00e3o de S.O \u00e9 o Oracle Linux 7: Confirmando […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-5214","post","type-post","status-publish","format-standard","hentry","category-oci"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=5214"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5214\/revisions"}],"predecessor-version":[{"id":9109,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5214\/revisions\/9109"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=5214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=5214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=5214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-70.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-71.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-72.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-73-1024x359.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-74.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-75.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-76.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-77-1024x312.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-78.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-79.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-80.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-81-1024x223.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-82.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-83-1024x288.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-84.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-85.png\")
<\/figure>\n\n\n\n