Nos artigos anteriores, realizamos a atualiza\u00e7\u00e3o da camada de Sistema Operacional e GRID, e agora vamos avan\u00e7ar na camada de DB Home. <\/p>\n\n\n\n
Validando vers\u00e3o vigente pelo utilit\u00e1rio DB CLI e a sugerida para atualiza\u00e7\u00e3o (de modo que, se aplicada, o DB Home ficar\u00e1 up-to-date):<\/p>\n\n\n
\n[opc@luxor ~]$ sudo su -\nLast login: Mon May 31 07:00:55 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 12.2.0.1.201020 12.2.0.1.210420\n<\/pre><\/div>\n\n\nPara garantir que o Data Patch ser\u00e1 aplicado ao nosso banco de dados, devemos garantir que o mesmo est\u00e1 up:<\/p>\n\n\n
\n[root@luxor ~]# exit\nlogout\n[opc@luxor ~]$ sudo su - oracle\nLast login: Mon May 31 07:01:02 UTC 2021\n[oracle@luxor ~]$ srvctl status database -db $ORACLE_UNQNAME\nInstance CORTEX is not running on node luxor\n[oracle@luxor ~]$ srvctl start database -db $ORACLE_UNQNAME\n[oracle@luxor ~]$ srvctl status database -db $ORACLE_UNQNAME\nInstance CORTEX is running on node luxor\n<\/pre><\/div>\n\n\nNessa etapa, precisamos coletar o DB Home ID conforme comando abaixo:<\/p>\n\n\n
\n[oracle@luxor ~]$ exit\nlogout\n[opc@luxor ~]$ sudo su -\nLast login: Mon May 31 07:01:15 UTC 2021 on pts\/0\n[root@luxor ~]# dbcli list-databases\n \nID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID \n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\n4c906765-68ea-4e05-ba3f-c54152f912cf CORTEX Si 12.2.0.1.201020 true Oltp ASM Configured 8bc7f0a5-6230-4b99-b568-b73cf0038525\n<\/pre><\/div>\n\n\nCaso queiramos nos certificar que todos os pr\u00e9-requisitos s\u00e3o atendidos e que o ambiente est\u00e1 apto para atualiza\u00e7\u00e3o, podemos rodar o pr\u00e9-check abaixo:<\/p>\n\n\n
\n[root@luxor ~]# dbcli update-dbhome --precheck\nMissing\/invalid Arguments\nPlease refer usage: dbcli update-dbhome -h\n[root@luxor ~]# dbcli update-dbhome -i "8bc7f0a5-6230-4b99-b568-b73cf0038525" --precheck\n{\n "jobId" : "1e436ec5-136d-4760-80d0-d7cf62e4f2d2",\n "status" : "Created",\n "message" : null,\n "reports" : [ ],\n "createTimestamp" : "May 31, 2021 07:11:14 AM UTC",\n "resourceList" : [ ],\n "description" : "DBHome Prechecks",\n "updatedTime" : "May 31, 2021 07:11:14 AM UTC",\n "percentageProgress" : "0%"\n}\n<\/pre><\/div>\n\n\nAcompanhando a evolu\u00e7\u00e3o do Job que foi criado:<\/p>\n\n\n
\n[root@luxor ~]# dbcli describe-job -i "1e436ec5-136d-4760-80d0-d7cf62e4f2d2"\n \nJob details\n----------------------------------------------------------------\n ID: 1e436ec5-136d-4760-80d0-d7cf62e4f2d2\n Description: DBHome Prechecks\n Status: Running\n Created: May 31, 2021 7:11:14 AM UTC\n Progress: 50%\n Message:\n \nTask Name Start Time End Time Status\n------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------\nPre-operations for DBHome patching May 31, 2021 7:11:15 AM UTC May 31, 2021 7:12:28 AM UTC Success\nDBHome patching May 31, 2021 7:12:28 AM UTC May 31, 2021 7:12:28 AM UTC Running\n<\/pre><\/div>\n\n\nJob de verifica\u00e7\u00e3o finalizado com sucesso:<\/p>\n\n\n
\n[root@luxor ~]# dbcli describe-job -i "1e436ec5-136d-4760-80d0-d7cf62e4f2d2"\n \nJob details\n----------------------------------------------------------------\n ID: 1e436ec5-136d-4760-80d0-d7cf62e4f2d2\n Description: DBHome Prechecks\n Status: Success\n Created: May 31, 2021 7:11:14 AM UTC\n Progress: 100%\n Message:\n \nTask Name Start Time End Time Status\n------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------\nPre-operations for DBHome patching May 31, 2021 7:11:15 AM UTC May 31, 2021 7:12:28 AM UTC Success\nDBHome patching May 31, 2021 7:12:28 AM UTC May 31, 2021 7:17:30 AM UTC Success\nPost-operations for DBHome patching May 31, 2021 7:17:30 AM UTC May 31, 2021 7:17:35 AM UTC Success\n<\/pre><\/div>\n\n\nDisparando efetivamente o patching do DB Home:<\/p>\n\n\n
\n[root@luxor ~]# dbcli update-dbhome -i "8bc7f0a5-6230-4b99-b568-b73cf0038525"\n{\n "jobId" : "65e8f05e-fc9d-4df5-9363-b380317792ca",\n "status" : "Created",\n "message" : null,\n "reports" : [ ],\n "createTimestamp" : "May 31, 2021 07:19:42 AM UTC",\n "resourceList" : [ ],\n "description" : "DBHome Patching: Home ID is 8bc7f0a5-6230-4b99-b568-b73cf0038525",\n "updatedTime" : "May 31, 2021 07:19:42 AM UTC",\n "percentageProgress" : "0%"\n}\n<\/pre><\/div>\n\n\nAcompanhando o Job:<\/p>\n\n\n
\n[root@luxor ~]# dbcli describe-job -i "65e8f05e-fc9d-4df5-9363-b380317792ca"\n \nJob details\n----------------------------------------------------------------\n ID: 65e8f05e-fc9d-4df5-9363-b380317792ca\n Description: DBHome Patching: Home ID is 8bc7f0a5-6230-4b99-b568-b73cf0038525\n Status: Running\n Created: May 31, 2021 7:19:42 AM UTC\n Progress: 20%\n Message:\n \nTask Name Start Time End Time Status\n------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------\nPre-operations for DBHome patching May 31, 2021 7:19:43 AM UTC May 31, 2021 7:20:48 AM UTC Success\nDBHome patching May 31, 2021 7:20:48 AM UTC May 31, 2021 7:20:48 AM UTC Running\n<\/pre><\/div>\n\n\nProcesso finalizado com \u00eaxito:<\/p>\n\n\n
\n[root@luxor ~]# dbcli describe-job -i "65e8f05e-fc9d-4df5-9363-b380317792ca"\n \nJob details\n----------------------------------------------------------------\n ID: 65e8f05e-fc9d-4df5-9363-b380317792ca\n Description: DBHome Patching: Home ID is 8bc7f0a5-6230-4b99-b568-b73cf0038525\n Status: Success\n Created: May 31, 2021 7:19:42 AM UTC\n Progress: 100%\n Message:\n \nTask Name Start Time End Time Status\n------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------\nPre-operations for DBHome patching May 31, 2021 7:19:43 AM UTC May 31, 2021 7:20:48 AM UTC Success\nDBHome patching May 31, 2021 7:20:48 AM UTC May 31, 2021 8:03:07 AM UTC Success\nPost-operations for DBHome patching May 31, 2021 8:03:07 AM UTC May 31, 2021 8:06:59 AM UTC Success\n<\/pre><\/div>\n\n\nValidando a vers\u00e3o atual do DB Home:<\/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\nAtualiza\u00e7\u00e3o realizada com sucesso conforme evid\u00eancias:<\/p>\n\n\n
\n[root@luxor ~]# exit\nlogout\n[opc@luxor ~]$ sudo su - oracle\nLast login: Mon May 31 08:06:53 UTC 2021\n[oracle@luxor ~]$ cd $ORACLE_HOME\/OPatch\n[oracle@luxor OPatch]$ ll\ntotal 200\n-rw-r----- 1 oracle oinstall 2980 Feb 1 10:40 README.txt\ndrwxr-x--- 6 oracle oinstall 4096 Apr 22 2020 auto\ndrwxr-x--- 2 oracle oinstall 4096 May 31 07:20 config\n-rwxr-x--- 1 oracle oinstall 589 Feb 1 10:40 datapatch\n-rwxr-x--- 1 oracle oinstall 627 Feb 1 10:40 datapatch.bat\ndrwxr-x--- 2 oracle oinstall 4096 May 31 07:20 docs\n-rwxr-x--- 1 oracle oinstall 23550 Feb 1 10:40 emdpatch.pl\ndrwxr-x--- 2 oracle oinstall 4096 May 31 07:20 jlib\ndrwxr-x--- 6 oracle oinstall 4096 May 31 07:20 jre\ndrwxr-x--- 9 oracle oinstall 4096 May 31 07:20 modules\ndrwxr-x--- 5 oracle oinstall 4096 May 31 07:20 ocm\n-rwxr-x--- 1 oracle oinstall 49564 Feb 1 10:40 opatch\n-rwxr-x--- 1 oracle oinstall 16458 Feb 1 10:40 opatch.bat\n-rw-r----- 1 oracle oinstall 2551 Feb 1 10:40 opatch.pl\n-rwxr-x--- 1 oracle oinstall 4290 Feb 1 10:40 opatch_env.sh\n-rwxr-x--- 1 oracle oinstall 1763 Feb 1 10:47 opatchauto\n-rwxr-x--- 1 oracle oinstall 393 Feb 1 10:47 opatchauto.cmd\ndrwxr-x--- 4 oracle oinstall 4096 May 31 07:20 opatchprereqs\n-rwxr-x--- 1 oracle oinstall 3159 Feb 1 10:40 operr\n-rwxr-x--- 1 oracle oinstall 4218 Feb 1 10:40 operr.bat\n-rw-r----- 1 oracle oinstall 3177 Feb 1 10:40 operr_readme.txt\ndrwxr-x--- 2 oracle oinstall 4096 May 31 07:20 oplan\ndrwxr-x--- 3 oracle oinstall 4096 Apr 22 2020 oracle_common\ndrwxr-x--- 3 oracle oinstall 4096 Apr 22 2020 plugins\ndrwxr-xr-x 2 oracle oinstall 4096 May 31 07:20 private\ndrwxr-x--- 2 oracle oinstall 4096 May 31 07:20 scripts\n-rw-r----- 1 oracle oinstall 27 Feb 1 10:40 version.txt\n[oracle@luxor OPatch]$ .\/opatch lsinventory | grep escript\nARU platform description:: Linux x86-64\nPatch description: "UPDATE PERL IN 12.2.0.1 DATABASE ORACLE HOME TO V5.32"\nPatch description: "JDK BUNDLE PATCH 12.2.0.1.210420"\nPatch description: "Database Apr 2021 Release Update : 12.2.0.1.210420 (32507738)"\nPatch description: "OJVM RELEASE UPDATE 12.2.0.1.201020 (31668898)"\nPatch description: "OCW OCT 2020 RELEASE UPDATE 12.2.0.1.201020 (31802727)"\n<\/pre><\/div>\n\n\nObs: 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":"
Nos artigos anteriores, realizamos a atualiza\u00e7\u00e3o da camada de Sistema Operacional e GRID, e agora vamos avan\u00e7ar na camada de DB Home. Validando vers\u00e3o vigente pelo utilit\u00e1rio DB CLI e a sugerida para atualiza\u00e7\u00e3o (de modo que, se aplicada, o DB Home ficar\u00e1 up-to-date): Para garantir que o Data Patch ser\u00e1 aplicado ao nosso banco […]<\/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-5040","post","type-post","status-publish","format-standard","hentry","category-oci"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5040","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=5040"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5040\/revisions"}],"predecessor-version":[{"id":9119,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5040\/revisions\/9119"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=5040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=5040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=5040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}