{"id":1218,"date":"2020-11-09T15:02:43","date_gmt":"2020-11-09T17:02:43","guid":{"rendered":"http:\/\/www.soudba.com.br\/?p=1218"},"modified":"2020-11-09T15:02:43","modified_gmt":"2020-11-09T17:02:43","slug":"error-to-apply-patch","status":"publish","type":"post","link":"https:\/\/www.soudba.com.br\/?p=1218","title":{"rendered":"Error to apply patch – OPATCHAUTO-72043"},"content":{"rendered":"

To solve the problem, change the permission\/owner to your owner like oracle or grid.<\/strong><\/h1>\n

See below the steps:<\/p>\n

[root@machine01 30920127]# cat \/etc\/oratab
\n#
\n+ASM2:\/u01\/app\/19.0.0\/grid:N
\nteste:\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1:N
\n[root@machine01 ~]# . oraenv
\nORACLE_SID = [root] ? teste
\nThe Oracle base has been set to \/u01\/app\/oracle
\n[root@machine01 ~]# \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/OPatch\/opatchauto apply \/stage\/midia\/30920127 -oh $ORACLE_HOME<\/p>\n

OPatchauto session is initiated at Mon Nov 7 13:50:27 2020<\/p>\n

System initialization log file is \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/cfgtoollogs\/opatchautodb\/systemconfig2020-11-07_02-50-29PM.log.<\/p>\n

Session log file is \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/cfgtoollogs\/opatchauto\/opatchauto2020-11-07_02-50-37PM.log
\nThe id for this session is 3CTC
\nOPATCHAUTO-72043: Patch collection failed.
\nOPATCHAUTO-72043: Failed to create bundle patch object.
\nOPATCHAUTO-72043: Please verify the patch supplied.
\nOPatchAuto failed.<\/p>\n

OPatchauto session completed at Mon Nov 7 13:50:38 2020
\nTime taken to complete the session 0 minute, 11 seconds<\/p>\n

opatchauto failed with error code 42
\n[root@machine01 ~]# pwd
\n\/root
\n[root@machine01 ~]# cd \/stage\/midia\/30920127\/
\n[root@machine01 30920127]# ls
\n26839277 30869447 30882603 30886680 30888810 automation bundle.xml README.html README.txt
\n[root@machine01 30920127]# chown oracle:oinstall * -Rf
\n[root@machine01 30920127]# \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/OPatch\/opatchauto apply \/stage\/midia\/30920127 -oh $ORACLE_HOME<\/p>\n

OPatchauto session is initiated at Mon Nov 7 13:50:59 2020<\/p>\n

System initialization log file is \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/cfgtoollogs\/opatchautodb\/systemconfig2020-11-07_02-51-01PM.log.<\/p>\n

Session log file is \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/cfgtoollogs\/opatchauto\/opatchauto2020-11-07_02-51-09PM.log
\nThe id for this session is RB4L
\nOPATCHAUTO-72043: Patch collection failed.
\nOPATCHAUTO-72043: Failed to create bundle patch object.
\nOPATCHAUTO-72043: Please verify the patch supplied.
\nOPatchAuto failed.<\/p>\n

OPatchauto session completed at Mon Nov 7 13:51:10 2020
\nTime taken to complete the session 0 minute, 11 seconds<\/p>\n

opatchauto failed with error code 42
\n[root@machine01 30920127]# chown oracle:oinstall ..\/* -Rf<\/strong><\/p>\n

or<\/strong>
\nchown oracle:oinstall \/stage\/midia\/30920127 -Rf<\/strong><\/p>\n

##############################################################################
\nProblem solved !!!!
\n##############################################################################<\/p>\n

[root@machine01 30920127]# \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/OPatch\/opatchauto apply \/stage\/midia\/30920127 -oh $ORACLE_HOME<\/p>\n

OPatchauto session is initiated at Mon Nov 7 13:51:24 2020<\/p>\n

System initialization log file is \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/cfgtoollogs\/opatchautodb\/systemconfig2020-11-07_02-51-26PM.log.<\/p>\n

Session log file is \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/cfgtoollogs\/opatchauto\/opatchauto2020-11-07_02-51-33PM.log
\nThe id for this session is WH1A<\/p>\n

Executing OPatch prereq operations to verify patch applicability on home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1
\nPatch applicability verified successfully on home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1<\/p>\n

Verifying SQL patch applicability on home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1
\nNo step execution required………<\/p>\n

Preparing to bring down database service on home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1
\nNo step execution required………<\/p>\n

Performing prepatch operation on home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1
\nPerpatch operation completed successfully on home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1<\/p>\n

Start applying binary patch on home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1
\nBinary patch applied successfully on home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1<\/p>\n

Performing postpatch operation on home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1
\nPostpatch operation completed successfully on home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1<\/p>\n

Preparing home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1 after database service restarted
\nNo step execution required………<\/p>\n

Trying to apply SQL patch on home \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1
\nNo step execution required………<\/p>\n

OPatchAuto successful.<\/p>\n

——————————–Summary——————————–<\/p>\n

Patching is completed successfully. Please find the summary as follows:<\/p>\n

Host:machine01
\nRAC Home:\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1
\nVersion:12.2.0.1.0
\nSummary:<\/p>\n

==Following patches were SKIPPED:<\/p>\n

Patch: \/stage\/midia\/30920127\/30869447
\nReason: This patch is not applicable to this specified target type – “rac_database”<\/p>\n

Patch: \/stage\/midia\/30920127\/26839277
\nReason: This patch is not applicable to this specified target type – “rac_database”<\/p>\n

Patch: \/stage\/midia\/30920127\/30888810
\nReason: This patch is not applicable to this specified target type – “rac_database”<\/p>\n

==Following patches were SUCCESSFULLY applied:<\/p>\n

Patch: \/stage\/midia\/30920127\/30882603
\nLog: \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2020-11-07_14-51-45PM_1.log<\/p>\n

Patch: \/stage\/midia\/30920127\/30886680
\nLog: \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/cfgtoollogs\/opatchauto\/core\/opatch\/opatch2020-11-07_14-51-45PM_1.log<\/p>\n

OPatchauto session completed at Mon Nov 7 13:54:01 2020
\nTime taken to complete the session 2 minutes, 37 seconds<\/p>\n

[root@machine01 30920127]#<\/p>\n","protected":false},"excerpt":{"rendered":"

To solve the problem, change the permission\/owner to your owner like oracle or grid. See below the steps: [root@machine01 30920127]# cat \/etc\/oratab # +ASM2:\/u01\/app\/19.0.0\/grid:N teste:\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1:N [root@machine01 ~]# . oraenv ORACLE_SID = [root] ? teste The Oracle base has been set … Continue lendo →<\/span><\/a><\/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":[381,382],"class_list":["post-1218","post","type-post","status-publish","format-standard","hentry","category-sem-categoria","tag-opatch","tag-opatchauto-72043"],"_links":{"self":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1218","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=1218"}],"version-history":[{"count":0,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1218\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}