{"id":1169,"date":"2020-06-02T20:57:00","date_gmt":"2020-06-02T23:57:00","guid":{"rendered":"http:\/\/soudba.com.br\/?p=1169"},"modified":"2020-06-02T20:57:00","modified_gmt":"2020-06-02T23:57:00","slug":"upgrade-exadata-at-customer-database-and-oracle-home","status":"publish","type":"post","link":"https:\/\/www.soudba.com.br\/?p=1169","title":{"rendered":"Upgrade your database using  dbaascli in your exadata at customer"},"content":{"rendered":"\n<p>So easy to upgrade de dbhome and database. Let&#8217;s see the steps below:<\/p>\n\n\n<pre class=\"wp-block-code\"><code>&#091;root@techdb01 ~]# dbaascli patch db list --oh `hostname`:\/u02\/app\/oracle\/product\/12.2.0\/dbhome_8\nDBAAS CLI version 19.4.4.1.0\nExecuting command patch db list --oh techdb01.pbh:\/u02\/app\/oracle\/product\/12.2.0\/dbhome_8\nINFO : EXACS patching\nAvailable Patches\npatchid :29708720 (DB 12.2.0.1.190716 DATABASE RELEASE UPDATE (Jul 2019))\npatchid :30116802 (DB 12.2.0.1.191015 DATABASE RELEASE UPDATE (Oct 2019))\npatchid :30501932 (DB 12.2.0.1.200114 DATABASE RELEASE UPDATE (Jan 2020))\npatchid :30920127 (DB 12.2.0.1.200414 DATABASE RELEASE UPDATE (Apr 2020))\nInstall database patch using\ndbaascli patch db apply --patchid 30920127 --dbnames &lt;&gt;\n&#091;root@techdb01 ~]# dbaascli patch db apply --patchid 30920127 --dbnames boston\nDBAAS CLI version 19.4.4.1.0\nExecuting command patch db apply --patchid 30920127 --dbnames boston\nINFO : EXACS patching\nThis might take some time, please take a look at file \/var\/opt\/oracle\/log\/exadbcpatch\/exadbcpatch.log for progress\nPatch installation successful\n&#091;root@techdb01 ~]#\ndbaascli patch db list --oh `hostname`:\/u02\/app\/oracle\/product\/19.0.0.0\/dbhome_4 --dbname boston\ndbaascli patch db prereq --patchid 30899722 pdb01:\/u02\/app\/oracle\/product\/19.0.0.0\/dbhome_3 --dbnames boston\nPlease apply the apply with nohup clause and &amp; at final this will take time:\nnohup dbaascli patch db apply --patchid 30899722\npdb01:\/u02\/app\/oracle\/product\/19.0.0.0\/dbhome_3 --dbnames boston &amp;\ncheck logs for dbaascli - and outputs and ps -ef | grep dbaascli<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>So easy to upgrade de dbhome and database. Let&#8217;s see the steps below:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[356,363,373,374],"class_list":["post-1169","post","type-post","status-publish","format-standard","hentry","category-sem-categoria","tag-ace","tag-dbaascli","tag-exadata-gen2","tag-exadata-patch-19c"],"_links":{"self":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1169"}],"version-history":[{"count":0,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1169\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}