{"id":5019,"date":"2021-05-30T14:00:51","date_gmt":"2021-05-30T14:00:51","guid":{"rendered":"https:\/\/swiv.com.br\/patching-db-system-grid-infrastructure\/"},"modified":"2026-05-27T20:02:31","modified_gmt":"2026-05-27T19:02:31","slug":"patching-db-system-grid-infrastructure","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/05\/30\/patching-db-system-grid-infrastructure\/","title":{"rendered":"Patching DB System (GRID Infrastructure)"},"content":{"rendered":"\n

Neste artigo, vamos explorar a atualiza\u00e7\u00e3o do nosso DB System, especificamente a camada GRID. <\/p>\n\n\n\n

Na console do OCI, podemos ver a vers\u00e3o vigente do DB System em sua p\u00e1gina principal:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Acessando nosso DB System:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Aqui conseguimos constatar que o OCI console reporta a vers\u00e3o 19.9.0.0.0:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Vamos baixar o nosso banco de dados para que a atualiza\u00e7\u00e3o possa prosseguir:<\/p>\n\n\n

\n[opc@luxor ~]$ sudo su - oracle\nLast login: Sun May 30 12:04:08 UTC 2021\n[oracle@luxor ~]$ srvctl stop database -db $ORACLE_UNQNAME -stopoption immediate -verbose\n[oracle@luxor ~]$ srvctl status database -database $ORACLE_UNQNAME\nInstance CORTEX is not running on node luxor\n[oracle@luxor ~]$\n<\/pre><\/div>\n\n\n
Para a atualiza\u00e7\u00e3o, vou usar o utilit\u00e1rio DB CLI. Validando as vers\u00e3o dispon\u00edveis:<\/p>\n\n\n
\n[oracle@luxor ~]$ exit\nlogout\n[opc@luxor ~]$ sudo su -\nLast login: Sun May 30 11:56:29 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.9.0.0.0            19.11.0.0\nDB                                        12.2.0.1.201020       12.2.0.1.210420\n<\/pre><\/div>\n\n\n
Com o comando abaixo, \u00e9 verificado todos os pr\u00e9-requisitos necess\u00e1rios no ambiente para que a atualiza\u00e7\u00e3o aconte\u00e7a. Um novo Job \u00e9 criado:<\/p>\n\n\n
\n[root@luxor ~]# dbcli update-server --precheck\n{\n  "jobId" : "f61589e1-4dd9-4247-91f1-2430e899d78c",\n  "status" : "Created",\n  "message" : null,\n  "reports" : [ ],\n  "createTimestamp" : "May 30, 2021 12:10:13 PM UTC",\n  "resourceList" : [ ],\n  "description" : "Server Patching Prechecks",\n  "updatedTime" : "May 30, 2021 12:10:13 PM UTC",\n  "percentageProgress" : "0%"\n}\n<\/pre><\/div>\n\n\n
Podemos acompanhar a evolu\u00e7\u00e3o da execu\u00e7\u00e3o do Job com o comando abaixo, usando o JOB ID fornecido acima:<\/p>\n\n\n
\n[root@luxor ~]# dbcli describe-job -i "f61589e1-4dd9-4247-91f1-2430e899d78c"\n \nJob details\n----------------------------------------------------------------\n                     ID:  f61589e1-4dd9-4247-91f1-2430e899d78c\n            Description:  Server Patching Prechecks\n                 Status:  Running\n                Created:  May 30, 2021 12:10:13 PM UTC\n               Progress:  49%\n                Message:\n \nTask Name                                                                Start Time                          End Time                            Status\n------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------\nPre-operations for Server Patching                                       May 30, 2021 12:10:14 PM UTC        May 30, 2021 12:11:24 PM UTC        Success\nServer Patching                                                          May 30, 2021 12:11:24 PM UTC        May 30, 2021 12:11:24 PM UTC        Running\n<\/pre><\/div>\n\n\n
Valida\u00e7\u00e3o finalizada com sucesso:<\/p>\n\n\n
\n[root@luxor ~]# dbcli describe-job -i "f61589e1-4dd9-4247-91f1-2430e899d78c"\n \nJob details\n----------------------------------------------------------------\n                     ID:  f61589e1-4dd9-4247-91f1-2430e899d78c\n            Description:  Server Patching Prechecks\n                 Status:  Success\n                Created:  May 30, 2021 12:10:13 PM UTC\n               Progress:  100%\n                Message:\n \nTask Name                                                                Start Time                          End Time                            Status\n------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------\nPre-operations for Server Patching                                       May 30, 2021 12:10:14 PM UTC        May 30, 2021 12:11:24 PM UTC        Success\nServer Patching                                                          May 30, 2021 12:11:24 PM UTC        May 30, 2021 12:15:09 PM UTC        Success\n<\/pre><\/div>\n\n\n
Agora podemos realizar a atualiza\u00e7\u00e3o do GRID:<\/p>\n\n\n
\n[root@luxor ~]# dbcli update-server\n{\n  "jobId" : "af7719eb-7174-4363-b70b-720eb8c8655b",\n  "status" : "Created",\n  "message" : null,\n  "reports" : [ ],\n  "createTimestamp" : "May 30, 2021 12:16:21 PM UTC",\n  "resourceList" : [ ],\n  "description" : "Server Patching",\n  "updatedTime" : "May 30, 2021 12:16:21 PM UTC",\n  "percentageProgress" : "0%"\n}\n<\/pre><\/div>\n\n\n
Acompanhando evolu\u00e7\u00e3o do Job criado:<\/p>\n\n\n
\n[root@luxor ~]# dbcli describe-job -i "af7719eb-7174-4363-b70b-720eb8c8655b"\n \nJob details\n----------------------------------------------------------------\n                     ID:  af7719eb-7174-4363-b70b-720eb8c8655b\n            Description:  Server Patching\n                 Status:  Running\n                Created:  May 30, 2021 12:16:21 PM UTC\n               Progress:  25%\n                Message:\n \nTask Name                                                                Start Time                          End Time                            Status\n------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------\nPre-operations for Server Patching                                       May 30, 2021 12:16:21 PM UTC        May 30, 2021 12:17:20 PM UTC        Success\nServer Patching                                                          May 30, 2021 12:17:20 PM UTC        May 30, 2021 12:17:20 PM UTC        Running\n<\/pre><\/div>\n\n\n
Processo finalizado com sucesso:<\/p>\n\n\n
\n[root@luxor ~]# dbcli describe-job -i "af7719eb-7174-4363-b70b-720eb8c8655b"\n \nJob details\n----------------------------------------------------------------\n                     ID:  af7719eb-7174-4363-b70b-720eb8c8655b\n            Description:  Server Patching\n                 Status:  Success\n                Created:  May 30, 2021 12:16:21 PM UTC\n               Progress:  100%\n                Message:\n \nTask Name                                                                Start Time                          End Time                            Status\n------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------\nPre-operations for Server Patching                                       May 30, 2021 12:16:21 PM UTC        May 30, 2021 12:17:20 PM UTC        Success\nServer Patching                                                          May 30, 2021 12:17:20 PM UTC        May 30, 2021 1:40:51 PM UTC         Success\n<\/pre><\/div>\n\n\n
Validando ambiente ap\u00f3s a atualiza\u00e7\u00e3o. Percebemos que agora o GRID ficou como “up-to-date”:<\/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.201020       12.2.0.1.210420\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":"
Neste artigo, vamos explorar a atualiza\u00e7\u00e3o do nosso DB System, especificamente a camada GRID. Na console do OCI, podemos ver a vers\u00e3o vigente do DB System em sua p\u00e1gina principal: Acessando nosso DB System: Aqui conseguimos constatar que o OCI console reporta a vers\u00e3o 19.9.0.0.0: Vamos baixar o nosso banco de dados para que a […]<\/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-5019","post","type-post","status-publish","format-standard","hentry","category-oci"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5019","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=5019"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5019\/revisions"}],"predecessor-version":[{"id":9120,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5019\/revisions\/9120"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=5019"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=5019"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=5019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}