{"id":1423,"date":"2022-05-16T17:36:16","date_gmt":"2022-05-16T09:36:16","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=1423"},"modified":"2022-05-17T12:22:53","modified_gmt":"2022-05-17T04:22:53","slug":"oracle-19c-%e5%8d%95%e5%ae%9e%e4%be%8b-ru-%e4%bb%8e19-3-%e5%8d%87%e7%ba%a7%e5%88%b019-15","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=1423","title":{"rendered":"Oracle 19c \u5355\u5b9e\u4f8b RU \u4ece19.3 \u5347\u7ea7\u523019.15"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<label for=\"ez-toc-cssicon-toggle-item-6a020099d479e\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a020099d479e\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#1_%E6%9F%A5%E8%AF%A2Oracle_PSU\" >1. \u67e5\u8be2Oracle PSU<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#2_%E4%BB%8EMOS%E4%B8%8B%E8%BD%BD_1915_%E7%9A%84RU_%E8%A1%A5%E4%B8%81\" >2. \u4eceMOS\u4e0b\u8f7d 19.15 \u7684RU \u8865\u4e01<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#21_%E4%BB%80%E4%B9%88%E6%98%AFRU\" >2.1. \u4ec0\u4e48\u662fRU<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#22_%E4%B8%8B%E8%BD%BD%E8%A1%A5%E4%B8%81%E5%8C%85\" >2.2. \u4e0b\u8f7d\u8865\u4e01\u5305<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#3_%E8%A1%A5%E4%B8%81-p33806152\" >3. \u8865\u4e01-p33806152<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#31_%E5%81%9C%E6%AD%A2%E6%95%B0%E6%8D%AE%E5%BA%93\" >3.1. \u505c\u6b62\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#32_%E5%A4%87%E4%BB%BD%E5%AE%B6%E7%9B%AE%E5%BD%95ORACLE_HOME\" >3.2. \u5907\u4efd\u5bb6\u76ee\u5f55(ORACLE_HOME)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#33_%E6%9B%BF%E6%8D%A2_OPatch\" >3.3. \u66ff\u6362 OPatch<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#34_%E9%AA%8C%E8%AF%81_Oracle_Inventory\" >3.4. \u9a8c\u8bc1 Oracle Inventory<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#35_%E6%A3%80%E6%9F%A5Patch_%E6%98%AF%E5%90%A6%E5%86%B2%E7%AA%81\" >3.5. \u68c0\u67e5Patch \u662f\u5426\u51b2\u7a81<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#36_%E5%BA%94%E7%94%A8patch\" >3.6. \u5e94\u7528patch<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#37_%E5%8A%A0%E8%BD%BD%E5%8F%98%E5%8C%96%E7%9A%84SQL%E5%88%B0%E6%95%B0%E6%8D%AE%E5%BA%93\" >3.7. \u52a0\u8f7d\u53d8\u5316\u7684SQL\u5230\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#38_%E5%A4%84%E7%90%86%E6%97%A0%E6%95%88%E5%AF%B9%E8%B1%A1\" >3.8. \u5904\u7406\u65e0\u6548\u5bf9\u8c61<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#39_Upgrade_Oracle_Recovery_Manager_Catalog\" >3.9. Upgrade Oracle Recovery Manager Catalog<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"http:\/\/dba.qishuo.xin\/?p=1423\/#310_%E6%9C%80%E5%90%8E%E6%A3%80%E6%9F%A5%E5%8D%87%E7%BA%A7%E5%90%8E%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93%E7%89%88%E6%9C%AC\" >3.10. \u6700\u540e\u68c0\u67e5\u5347\u7ea7\u540e\u7684\u6570\u636e\u5e93\u7248\u672c<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p><strong><span style='color:red'>\u90d1\u91cd\u63d0\u9192\uff1a\u5347\u7ea7\u524d\u5fc5\u987b\u5907\u4efd\u6570\u636e\u5e93\uff0c\u5907\u4efdOracle\u5bb6\u76ee\u5f55\u3002\u5e76\u4e14\u4ed4\u7ec6\u7814\u8bfb\u5347\u7ea7\u5305\u4e2d\u7684README.html \u6587\u4ef6\uff01\uff01\uff01<\/span><\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_%E6%9F%A5%E8%AF%A2Oracle_PSU\"><\/span>1. \u67e5\u8be2Oracle PSU<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u901a\u8fc7\u6587\u6863 <span style='color:red'> ID:  2118136.2 <\/span> \u5728my oracle support\u4e2d\u641c\u7d22Oracle\u6bcf\u5b63\u5ea6\u6700\u65b0\u7684PSU\u7b49\u8865\u4e01\u3002<\/p>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/image-1652686293271.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/image-1652686293271.png\" alt=\"file\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_%E4%BB%8EMOS%E4%B8%8B%E8%BD%BD_1915_%E7%9A%84RU_%E8%A1%A5%E4%B8%81\"><\/span>2. \u4eceMOS\u4e0b\u8f7d 19.15 \u7684RU \u8865\u4e01<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"21_%E4%BB%80%E4%B9%88%E6%98%AFRU\"><\/span>2.1. \u4ec0\u4e48\u662fRU<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u53c2\u8003\uff1a<a target=\"_blank\" href=\"https:\/\/www.cnblogs.com\/dbapro\/p\/13587070.html\">https:\/\/www.cnblogs.com\/dbapro\/p\/13587070.html<\/a><\/p>\n<p>\u4ee5\u524d Oracle\u7684\u5468\u671f\u662f\u7ea65\u5e74\u5347\u7ea7\u4e00\u4e2a\u5927\u7248\u672c\uff0c\u5728\u8fd9\u4e2a\u5927\u7248\u672c\u4e0a\u505a\u5c0f\u7684\u5347\u7ea7\uff08PSU\u4e0eBP\uff09\uff0c\u572812c\u53d1\u5e03\u4ee5\u540e\uff0coracle\u6570\u636e\u5e93\u4ea7\u54c1\u7684\u65b0\u7248\u672c\u53d1\u5e03\u6539\u4e3a\u6bcf\u5e74\u4e00\u6b21\u3002\u968f\u7740\u7248\u672c\u7684\u53d8\u5316\uff0coracle\u7684\u5347\u7ea7\u4e5f\u53d1\u751f\u4e86\u53d8\u5316\u3002<br \/>\n12.2\u4ee5\u540e\uff0c\u4e3b\u8981\u662f\u901a\u8fc7 <span style='color:red'>RU<\/span>\uff08<strong>Release Updates<\/strong>\uff09\u4e0e <span style='color:red'>RUR<\/span>\uff08<strong>Release Update Revisions<\/strong>\uff09\u5347\u7ea7\uff0c\u90a3\u4e48\u4ec0\u4e48\u662f RU\uff08Release Updates\uff09\u4e0e RUR\uff08Release Update Revisions\uff09\uff0c\u8be5\u600e\u4e48\u9009\u62e9\u5462\uff1f<\/p>\n<ul>\n<li>\n<p>RU\uff08Release Updates\uff09\u662f\u6bcf\u4e00\u4e2a\u5b63\u5ea6\u7684\u7248\u672c\u5347\u7ea7\u3002\u5305\u62ec\uff1a<br \/>\n\u6700\u65b0\u7684BUG\u4fee\u590d<br \/>\n\u6700\u65b0\u7684\u5b89\u5168\u6f0f\u6d1e\u8865\u4e01<br \/>\n\u6700\u65b0\u6dfb\u52a0\u7684\u529f\u80fd<br \/>\n\u4ee519c\u4e3a\u4f8b\uff0c\u5bf9\u5e94\u7684\u5347\u7ea7\u7248\u672c\u5347\u7ea7\u8def\u7ebf\u662f\uff0819.1.0.0.0-&gt;19.2.0.0.0-&gt;19.3.0.0.0 ..... \uff09\u5230\u73b0\u5728\u662f19.15.0.0.0<\/p>\n<\/li>\n<li>\n<p>RUR\u662f\u5bf9RU\u7684\u4fee\u8ba2\u7248\u672c\uff0c\u5305\u62ec\uff1a<br \/>\n\u6700\u65b0\u7684BUG\u4fee\u590d<br \/>\n\u6700\u65b0\u7684\u5b89\u5168\u6f0f\u6d1e\u8865\u4e01<br \/>\n\u8fd9\u91cc\u5e76\u6ca1\u6709\u6dfb\u52a0\u6700\u65b0\u7684\u529f\u80fd\u3002\u5e76\u4e14\u53ea\u6709\u5bf9\u5e94RU\u7248\u672c\u7684\u4fee\u8ba2\u7248\u3002\u6bd4\u5982\uff0c\u57282020\u5e747\u6708\uff0c\u9664\u4e86\u4f1a\u53d1\u5e03RU\uff0819.8.0.0.0\uff09\u4e5f\u4f1a\u53d1\u5e03\u4e0a\u4e2a\u5b63\u5ea6\u7684.1\u8865\u4e01(19.7.1.0)\u548c\u4e0a\u4e0a\u4e2a\u5b63\u5ea6\u7684.2\u8865\u4e01(19.6.2.0)<\/p>\n<\/li>\n<li>\n<p>RU\u4e0eRUR\u662f\u53ef\u4ee5\u76f8\u4e92\u8f6c\u6362\u7684\uff0coracle\u4e5f\u63d0\u4f9b\u4e86\u5224\u65ad\u6761\u4ef6<\/p>\n<\/li>\n<\/ul>\n<pre><code>\u5ba2\u6237\u662f\u5426\u53ef\u4ee5\u5728 Updates \u548c Revisions \u4e4b\u95f4\u6765\u56de\u5207\u6362\uff1f\n\nA: \u662f\u7684\u3002   \u53ea\u8981\u5ba2\u6237\u9009\u62e9\u7684\u7248\u672c\u662f\u53e6\u4e00\u4e2a\u7684\u7d2f\u79ef\uff0c\u90a3\u4e48\u5c31\u53ef\u4ee5\u5728 Updates \u548c Revisions \u4e4b\u95f4\u5207\u6362\u3002\u4e00\u4e2a\u7b80\u5355\u7684\u516c\u5f0f\u5c31\u662f\u5728\u76f8\u540c\u7684\u5e74\u5ea6\u53d1\u5e03\u7684\u60c5\u51b5\u4e0b\uff0c\n\u628a\u76ee\u6807\u4ee5\u53ca\u6e90\u5e93\u7684\u7248\u672c\u53f7\u7684\u540e\u4e24\u4e2a\u90e8\u5206\u76f8\u52a0\u3002\u5982\u679c\u76ee\u6807\u7248\u672c\u53f7\u7684\u540e\u4e24\u4e2a\u90e8\u5206\u76f8\u52a0\u5927\u4e8e\u6e90\u5e93\u7248\u672c\u53f7\u7684\u540e\u4e24\u4e2a\u90e8\u5206\u76f8\u52a0\uff0c\u90a3\u4e48\u5c31\u53ef\u4ee5\u5e94\u7528\u76ee\u6807\u7248\u672c\uff1b\u5426\u5219\u5b89\u88c5\u4f1a\u5931\u8d25\u3002\n\n\u4f8b 1:\n    \u6e90\u7248\u672c - 18.2.2     &lt;&lt;&lt;&lt;&lt; \u7b2c\u4e8c\u90e8\u5206\u548c\u7b2c\u4e09\u90e8\u5206\u7684\u548c\u662f &quot;4&quot;\n    \u76ee\u6807\u7248\u672c - 18.5.0     &lt;&lt;&lt;&lt;&lt; \u7b2c\u4e8c\u90e8\u5206\u548c\u7b2c\u4e09\u90e8\u5206\u7684\u548c\u662f &quot;5&quot;\n    \u7ed3\u8bba: \u76ee\u6807\u7248\u672c &quot;5&quot; \u6bd4\u6e90\u7248\u672c &quot;4&quot; \u5927\uff0c\u6240\u4ee5\u53ef\u4ee5\u5e94\u7528\u76ee\u6807\u7248\u672c\n\n\u4f8b 2:\n    \u6e90\u7248\u672c - 18.2.2     &lt;&lt;&lt;&lt;&lt; \u7b2c\u4e8c\u90e8\u5206\u548c\u7b2c\u4e09\u90e8\u5206\u7684\u548c\u662f &quot;4&quot;\n    \u76ee\u6807\u7248\u672c - 18.3.0     &lt;&lt;&lt;&lt;&lt; \u7b2c\u4e8c\u90e8\u5206\u548c\u7b2c\u4e09\u90e8\u5206\u7684\u548c\u662f&quot;3&quot;\n    \u7ed3\u8bba: \u76ee\u6807\u7248\u672c &quot;3&quot; \u6bd4\u6e90\u7248\u672c &quot;4&quot; \u5c0f\u6240\u4ee5\u4e0d\u80fd\u5b89\u88c5\u76ee\u6807\u7248\u672c\uff0c\u4f1a\u51fa\u9519<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"22_%E4%B8%8B%E8%BD%BD%E8%A1%A5%E4%B8%81%E5%8C%85\"><\/span>2.2. \u4e0b\u8f7d\u8865\u4e01\u5305<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/image-1652686387106.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/image-1652686387106.png\" alt=\"file\" \/><\/a><br \/>\n\u4e0b\u8f7d\u5230\u7684\u6587\u4ef6\u540d\u4e3a\uff1ap33806152_190000_Linux-x86-64.zip(\u4ec5\u6570\u636e\u5e93)\uff0c\u5c06\u4e0b\u8f7d\u7684\u6587\u4ef6\u5b58\u653e\u5230 <code>\/home\/oracle\/software\/<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_%E8%A1%A5%E4%B8%81-p33806152\"><\/span>3. \u8865\u4e01-p33806152<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>\u603b\u4f53\u6b65\u9aa4\u4e5f\u5f88\u7b80\u5355\uff0c\u5907\u4efd\u5bb6\u76ee\u5f55\uff0c\u66ff\u6362 opatch\uff0coracleinventory \u9a8c\u8bc1\u3001\u7a7a\u95f4\u68c0\u6d4b\uff0c\u8865\u4e01\u51b2\u7a81\u68c0\u6d4b\uff0c\u8865\u4e01\u5206\u6790\uff0c\u5e94\u7528\u8865\u4e01\u7b49\u4e03\u5927\u6b65\u9aa4\u3002<\/strong><\/p>\n<ul>\n<li>\u5b9e\u9a8c\u73af\u5883\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c<\/li>\n<\/ul>\n<pre><code>~]# cat \/etc\/redhat-release\nCentOS Linux release 7.8.2003 (Core)<\/code><\/pre>\n<ul>\n<li>\u5b9e\u9a8c\u73af\u5883\u6570\u636e\u5e93\u7248\u672c<\/li>\n<\/ul>\n<pre><code>ContainerID :  0\nBanner      :  Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nBanner Full :  Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\n               Version 19.3.0.0.0\nBanner Legacy: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"31_%E5%81%9C%E6%AD%A2%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>3.1. \u505c\u6b62\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u8fd9\u91cc\u6709\u51e0\u70b9\u6ce8\u610f\u4e8b\u9879\uff1a<\/p>\n<p>\u5982\u679c\u662f\u7269\u7406DG\uff0c\u90a3\u4e48\u4e3b\u5907\u5e93\u90fd\u9700\u8981\u5b89\u88c5Patch\uff0c\u53ef\u4ee5\u5148\u5728\u5907\u5e93\u5b89\u88c5\uff0c\u518d\u5b89\u88c5\u4e3b\u5e93\uff0c\u64cd\u4f5c\u6b65\u9aa4\u53ef\u4ee5\u53c2\u8003\uff1aDocument 278641.1\u3002<br \/>\n\u5bf9\u4e8eRAC \u73af\u5883\uff0c\u53ef\u4ee5\u4f7f\u7528OPatch rolling \u65b9\u5f0f\u6765\u5b89\u88c5\uff0c\u8fd9\u6837\u6ca1\u6709\u505c\u673a\u65f6\u95f4\uff0c\u5177\u4f53\u64cd\u4f5c\u53ef\u4ee5\u53c2\u8003\uff1aDocument 244241.1\u3002<br \/>\n\u5bf9\u4e8e\u5355\u5b9e\u4f8b\uff0c\u5fc5\u987b\u5173\u95ed\u5f85\u5347\u7ea7ORACLE HOME\u5173\u8054\u7684\u6240\u6709\u5b9e\u4f8b\u548c\u76d1\u542c\uff0c\u5e76\u4e14\u5305\u62ec\u9000\u51fa\u6240\u6709\u7684sqlplus\u7a97\u53e3\u3002<br \/>\n\u5173\u95ed\u5b9e\u4f8b\u548c\u76d1\u542c\uff0c\u5e76\u9000\u51fasqlplus<\/p>\n<pre><code># \u4f7f\u7528 oracle \u7528\u6237\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\n~]$ lsnrctl stop\n~]$ sqlplus \/ as sysdba\nSQL&gt; shu immediate;\nSQL&gt; exit;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"32_%E5%A4%87%E4%BB%BD%E5%AE%B6%E7%9B%AE%E5%BD%95ORACLE_HOME\"><\/span>3.2. \u5907\u4efd\u5bb6\u76ee\u5f55(ORACLE_HOME)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u56e0\u4e3a\u8865\u4e01\u5b89\u88c5\u9488\u5bf9\u7684\u662f Oracle \u5bb6\u76ee\u5f55\u4e0b\u6587\u4ef6\u7684\u66ff\u6362\uff0c\u6545\u9700\u8981\u5c06\u5bb6\u76ee\u5f55\u6587\u4ef6\u505a\u4e00\u4e2a\u5907\u4efd\u3002\u4e3a\u4e86\u4fdd\u8bc1\u5907\u4efd\u7684\u6587\u4ef6\u53ef\u7528\uff0c\u5efa\u8bae\u5c06\u6570\u636e\u5e93\u505c\u6b62\u540e\u505a\u5907\u4efd\uff0cRAC \u96c6\u7fa4\u65f6\u5efa\u8bae\u505c\u6b62\u96c6\u7fa4\u7ec4\u4ef6\u5907\u4efd\uff0c\u5f53\u51fa\u73b0\u4e0d\u80fd\u89e3\u51b3\u7684\u95ee\u9898\u65f6\u53ef\u4ee5\u5c06\u5907\u4efd\u7684 ORACLE_HOME \u76ee\u5f55\u8fd8\u539f\uff0c\u53ef\u6b63\u5e38\u542f\u52a8\u96c6\u7fa4\u3002<\/p>\n<pre><code class=\"language-SHELL\">mkdir -p \/data\/oraBackup\/\ntar zcvf \/data\/oraBackup\/oracle_before_upgrade.tar.gz \/u01\/app\/oracle\/<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"33_%E6%9B%BF%E6%8D%A2_OPatch\"><\/span>3.3. \u66ff\u6362 OPatch<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5347\u7ea7\u523019.14\u7248\u672c\uff0cOPatch \u5de5\u5177\u7684\u7248\u672c\u5fc5\u987b\u5927\u4e8e 12.2.0.1.28\u3002<br \/>\n\u4f7f\u7528oracle\u7528\u6237\u6267\u884c\u4e0b\u5217\u811a\u672c\u3002<\/p>\n<p>(1)\u67e5\u770b\u5f53\u524d OPatch \u7248\u672c<\/p>\n<pre><code class=\"language-shell\">cd $ORACLE_HOME\/OPatch\/\n.\/opatch version<\/code><\/pre>\n<p>\u8f93\u51fa\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<pre><code>OPatch Version: 12.2.0.1.17\n\nOPatch succeeded.<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/image-1652690642494.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/image-1652690642494.png\" alt=\"file\" \/><\/a><\/p>\n<p>(2)\u4e0b\u8f7d\u6700\u65b0\u7684 OPatch \u7248\u672c<br \/>\n\u4ecepatch 6880880 \u4e0b\u8f7d\u6700\u65b0\u7684OPatch\u3002\u4e0b\u8f7d\u5730\u5740\u4e3a\uff1a<a target=\"_blank\" href=\"https:\/\/updates.oracle.com\/download\/6880880.html\">https:\/\/updates.oracle.com\/download\/6880880.html<\/a><br \/>\n\u6211\u4eec\u4e0b\u8f7d\u5230 <code>\tOPatch 12.2.0.1.30 for DB 19.0.0.0.0 (Apr 2022)<\/code>\uff0c\u6587\u4ef6\u540d\u4e3a\uff1a p6880880_190000_Linux-x86-64.zip<br \/>\n<span style='color:red'>\u4e00\u5b9a\u8981\u6ce8\u610f\u6570\u636e\u5e93\u7684\u7248\u672c\uff0c\u522b\u9009\u62e9\u9519\u4e86\uff01\uff01\uff01<\/span><\/p>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/image-1652690886057.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/image-1652690886057.png\" alt=\"file\" \/><\/a><\/p>\n<p>(3)\u66ff\u6362\u5f53\u524d OPatch<\/p>\n<pre><code class=\"language-shell\">unzip p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME<\/code><\/pre>\n<p>\u8f93\u51fa\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<pre><code>Archive:  p6880880_190000_Linux-x86-64.zip\nreplace \/u01\/app\/oracle\/product\/19c\/db_1\/OPatch\/README.txt? [y]es, [n]o, [A]ll, [N]one, [r]ename: A  #A\u8868\u793a\u8986\u76d6\u6587\u4ef6\n...<\/code><\/pre>\n<p>(4)\u518d\u6b21\u786e\u8ba4 OPatch \u7248\u672c<br \/>\n<a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/image-1652691503024.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/04\/image-1652691503024.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"34_%E9%AA%8C%E8%AF%81_Oracle_Inventory\"><\/span>3.4. \u9a8c\u8bc1 Oracle Inventory<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5728\u5f00\u59cb\u6253\u8865\u4e01\u4e4b\u524d\uff0c\u68c0\u67e5 GI home \u548c\u6bcf\u4e2a\u8981\u6253\u8865\u4e01\u7684\u6570\u636e\u5e93home\u7684\u5e93\u5b58\u4fe1\u606f\u7684\u4e00\u81f4\u6027\u3002 \u4ee5\u5404\u81ea\u7684 Oracle \u4e3b\u76ee\u5f55\u6240\u6709\u8005\u8eab\u4efd\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\u4ee5\u68c0\u67e5\u4e00\u81f4\u6027\u3002<\/p>\n<pre><code class=\"language-shell\">$ORACLE_HOME\/OPatch\/opatch lsinventory -detail -oh $ORACLE_HOME<\/code><\/pre>\n<p>\u8f93\u51fa\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre><code>Oracle Interim Patch Installer version 12.2.0.1.30\nCopyright (c) 2022, Oracle Corporation.  All rights reserved.\n\nOracle Home       : \/u01\/app\/oracle\/product\/19c\/db_1\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19c\/db_1\/oraInst.loc\nOPatch version    : 12.2.0.1.30\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19c\/db_1\/cfgtoollogs\/opatch\/opatch2022-05-16_16-59-35PM_1.log\n\nLsinventory Output file location : \/u01\/app\/oracle\/product\/19c\/db_1\/cfgtoollogs\/opatch\/lsinv\/lsinventory2022-05-16_16-59-35PM.txt\n--------------------------------------------------------------------------------\nLocal Machine Information::\nHostname: dbteam\nARU platform id: 226\nARU platform description:: Linux x86-64\n\nInstalled Top-level Products (1):\n\nOracle Database 19c                                                  19.0.0.0.0\nThere are 1 products installed in this Oracle Home.\n\nInstalled Products (128):\n\nAssistant Common Files                                               19.0.0.0.0\nBLASLAPACK Component                                                 19.0.0.0.0\nBuildtools Common Files                                              19.0.0.0.0\n...<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"35_%E6%A3%80%E6%9F%A5Patch_%E6%98%AF%E5%90%A6%E5%86%B2%E7%AA%81\"><\/span>3.5. \u68c0\u67e5Patch \u662f\u5426\u51b2\u7a81<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u786e\u5b9a Oracle \u4e3b\u76ee\u5f55\u4e2d\u662f\u5426\u6709\u4e0e\u6570\u636e\u5e93\u7248\u672c\u66f4\u65b0 19.15.0.0.220419 \u51b2\u7a81\u7684\u4e34\u65f6\u8865\u4e01\u5e76\u83b7\u5f97\u5fc5\u8981\u7684\u51b2\u7a81\u89e3\u51b3\u8865\u4e01\u7684\u6700\u5feb\u548c\u6700\u7b80\u5355\u7684\u65b9\u6cd5\u662f\u4f7f\u7528\u8865\u4e01\u4e0a\u7684\u8865\u4e01\u5efa\u8bae\u548c\u8865\u4e01\u8ba1\u5212\u529f\u80fd\u548c My Oracle Support \u4e2d\u7684\u66f4\u65b0\u9009\u9879\u5361\u3002\u8fd9\u4e9b\u529f\u80fd\u4e0e My Oracle Support \u914d\u7f6e\u7ba1\u7406\u5668\u7ed3\u5408\u4f7f\u7528\u3002\u6709\u5173\u8fd9\u4e9b\u529f\u80fd\u7684\u8bb0\u5f55\u57f9\u8bad\u8bfe\u7a0b\u53ef\u5728\u6587\u6863 603505.1 \u4e2d\u627e\u5230\u3002<\/p>\n<pre><code class=\"language-shell\">cd \/home\/oracle\/software\/\nunzip p33806152_190000_Linux-x86-64.zip\ncd p33806152\/\n$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -ph .\/<\/code><\/pre>\n<p>\u8f93\u51fa\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<pre><code>Oracle Interim Patch Installer version 12.2.0.1.30\nCopyright (c) 2022, Oracle Corporation.  All rights reserved.\n\nPREREQ session\n\nOracle Home       : \/u01\/app\/oracle\/product\/19c\/db_1\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19c\/db_1\/oraInst.loc\nOPatch version    : 12.2.0.1.30\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19c\/db_1\/cfgtoollogs\/opatch\/opatch2022-05-16_17-04-32PM_1.log\n\nInvoking prereq &quot;checkconflictagainstohwithdetail&quot;\n\nPrereq &quot;checkConflictAgainstOHWithDetail&quot; passed.\n\nOPatch succeeded.<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"36_%E5%BA%94%E7%94%A8patch\"><\/span>3.6. \u5e94\u7528patch<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u8ddf\u7740\u8fd9\u4e9b\u6b65\u9aa4\uff1a<\/p>\n<ol>\n<li>\n<p>\u5982\u679c\u60a8\u4f7f\u7528\u7684\u662f Data Guard \u7269\u7406\u5907\u7528\u6570\u636e\u5e93\uff0c\u5219\u5fc5\u987b\u5728\u4e3b\u6570\u636e\u5e93\u548c\u7269\u7406\u5907\u7528\u6570\u636e\u5e93\u4e0a\u5b89\u88c5\u6b64\u8865\u4e01\uff0c\u5982 My Oracle Support Document 278641.1 \u6240\u8ff0\u3002<\/p>\n<\/li>\n<li>\n<p>\u5982\u679c\u8fd9\u662f RAC \u73af\u5883\uff0c\u8bf7\u4f7f\u7528 OPatch \u6eda\u52a8\uff08\u65e0\u505c\u673a\u65f6\u95f4\uff09\u5b89\u88c5\u65b9\u6cd5\u5b89\u88c5\u6b64\u8865\u4e01\uff0c\u56e0\u4e3a\u6b64\u8865\u4e01\u53ef\u6eda\u52a8 RAC \u5b89\u88c5\u3002 \u8bf7\u53c2\u9605 My Oracle Support \u6587\u6863 244241.1 \u6eda\u52a8\u8865\u4e01 - RAC \u7684 OPatch \u652f\u6301\u3002<\/p>\n<\/li>\n<li>\n<p>\u5982\u679c\u8fd9\u4e0d\u662f RAC \u73af\u5883\uff0c\u8bf7\u5173\u95ed\u4e0e\u60a8\u6b63\u5728\u66f4\u65b0\u7684 Oracle \u4e3b\u76ee\u5f55\u5173\u8054\u7684\u6240\u6709\u5b9e\u4f8b\u548c\u4fa6\u542c\u5668\u3002 \u6709\u5173\u8be6\u7ec6\u4fe1\u606f\uff0c\u8bf7\u53c2\u9605 Oracle \u6570\u636e\u5e93\u7ba1\u7406\u5458\u6307\u5357\u3002<\/p>\n<\/li>\n<li>\n<p>\u5c06\u5f53\u524d\u76ee\u5f55\u8bbe\u7f6e\u4e3a\u8865\u4e01\u6240\u5728\u7684\u76ee\u5f55\uff0c\u7136\u540e\u901a\u8fc7\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u8fd0\u884c OPatch \u5b9e\u7528\u7a0b\u5e8f\uff1a<\/p>\n<pre><code class=\"language-shell\">unzip p33806152_&lt;version&gt;_&lt;platform&gt;.zip\ncd 33806152\n$ORACLE_HOME\/OPatch\/opatch apply<\/code><\/pre>\n<\/li>\n<\/ol>\n<p>\u8f93\u51fa\u7684\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<pre><code>Oracle Interim Patch Installer version 12.2.0.1.30\nCopyright (c) 2022, Oracle Corporation.  All rights reserved.\n\nOracle Home       : \/u01\/app\/oracle\/product\/19c\/db_1\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19c\/db_1\/oraInst.loc\nOPatch version    : 12.2.0.1.30\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19c\/db_1\/cfgtoollogs\/opatch\/opatch2022-05-16_17-13-40PM_1.log\n\nVerifying environment and performing prerequisite checks...\nOPatch continues with these patches:   33806152  \n\nDo you want to proceed? [y|n]\ny\nUser Responded with: Y\nAll checks passed.\n\nPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.\n(Oracle Home = &#039;\/u01\/app\/oracle\/product\/19c\/db_1&#039;)\n\nIs the local system ready for patching? [y|n]\ny\nUser Responded with: Y\nBacking up files...\nApplying interim patch &#039;33806152&#039; to OH &#039;\/u01\/app\/oracle\/product\/19c\/db_1&#039;\nApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.\n\n\u4e0a\u8ff0\u7ec4\u4ef6\u5728 Oracle Home \u4e2d\u4e0d\u5b58\u5728 \u6216\u627e\u5230\u66f4\u9ad8\u7248\u672c\u3002\n\nPatching component oracle.bali.ewt, 11.1.1.6.0...\n\nPatching component oracle.help.ohj, 11.1.1.7.0...\n\nPatching component oracle.perlint, 5.28.1.0.0...\n\nPatching component oracle.rdbms.locator, 19.0.0.0.0...\n\nPatching component oracle.perlint.expat, 2.0.1.0.4...\n\nPatching component oracle.rdbms.rsf, 19.0.0.0.0...\n\nPatching component oracle.rdbms.util, 19.0.0.0.0...\n\nPatching component oracle.rdbms, 19.0.0.0.0...\n\nPatching component oracle.assistants.acf, 19.0.0.0.0...\n\nPatching component oracle.assistants.deconfig, 19.0.0.0.0...\n\nPatching component oracle.assistants.server, 19.0.0.0.0...\n\nPatching component oracle.buildtools.rsf, 19.0.0.0.0...\n\nPatching component oracle.ctx, 19.0.0.0.0...\n\nPatching component oracle.dbdev, 19.0.0.0.0...\n\nPatching component oracle.dbjava.ic, 19.0.0.0.0...\n\nPatching component oracle.dbjava.jdbc, 19.0.0.0.0...\n\nPatching component oracle.dbjava.ucp, 19.0.0.0.0...\n\nPatching component oracle.duma, 19.0.0.0.0...\n\nPatching component oracle.javavm.client, 19.0.0.0.0...\n\nPatching component oracle.ldap.owm, 19.0.0.0.0...\n\nPatching component oracle.ldap.rsf, 19.0.0.0.0...\n\nPatching component oracle.ldap.security.osdt, 19.0.0.0.0...\n\nPatching component oracle.marvel, 19.0.0.0.0...\n\nPatching component oracle.network.rsf, 19.0.0.0.0...\n\nPatching component oracle.odbc.ic, 19.0.0.0.0...\n\nPatching component oracle.oracore.rsf, 19.0.0.0.0...\n\nPatching component oracle.precomp.common.core, 19.0.0.0.0...\n\nPatching component oracle.rdbms.crs, 19.0.0.0.0...\n\nPatching component oracle.rdbms.dbscripts, 19.0.0.0.0...\n\nPatching component oracle.rdbms.deconfig, 19.0.0.0.0...\n\nPatching component oracle.rdbms.oci, 19.0.0.0.0...\n\nPatching component oracle.rhp.db, 19.0.0.0.0...\n\nPatching component oracle.sdo, 19.0.0.0.0...\n\nPatching component oracle.sdo.locator.jrf, 19.0.0.0.0...\n\nPatching component oracle.sqlplus, 19.0.0.0.0...\n\nPatching component oracle.sqlplus.ic, 19.0.0.0.0...\n\nPatching component oracle.wwg.plsql, 19.0.0.0.0...\n\nPatching component oracle.rdbms.rman, 19.0.0.0.0...\n\nPatching component oracle.dbtoolslistener, 19.0.0.0.0...\n\nPatching component oracle.rdbms.scheduler, 19.0.0.0.0...\n\nPatching component oracle.oraolap, 19.0.0.0.0...\n\nPatching component oracle.oraolap.api, 19.0.0.0.0...\n\nPatching component oracle.precomp.rsf, 19.0.0.0.0...\n\nPatching component oracle.rdbms.hs_common, 19.0.0.0.0...\n\nPatching component oracle.xdk.parser.java, 19.0.0.0.0...\n\nPatching component oracle.xdk.xquery, 19.0.0.0.0...\n\nPatching component oracle.rdbms.install.common, 19.0.0.0.0...\n\nPatching component oracle.mgw.common, 19.0.0.0.0...\n\nPatching component oracle.rdbms.drdaas, 19.0.0.0.0...\n\nPatching component oracle.install.deinstalltool, 19.0.0.0.0...\n\nPatching component oracle.network.client, 19.0.0.0.0...\n\nPatching component oracle.odbc, 19.0.0.0.0...\n\nPatching component oracle.ons.ic, 19.0.0.0.0...\n\nPatching component oracle.xdk.rsf, 19.0.0.0.0...\n\nPatching component oracle.rdbms.hsodbc, 19.0.0.0.0...\n\nPatching component oracle.oraolap.dbscripts, 19.0.0.0.0...\n\nPatching component oracle.rdbms.lbac, 19.0.0.0.0...\n\nPatching component oracle.nlsrtl.rsf, 19.0.0.0.0...\n\nPatching component oracle.ctx.atg, 19.0.0.0.0...\n\nPatching component oracle.network.listener, 19.0.0.0.0...\n\nPatching component oracle.ldap.ssl, 19.0.0.0.0...\n\nPatching component oracle.ovm, 19.0.0.0.0...\n\nPatching component oracle.rdbms.install.plugins, 19.0.0.0.0...\n\nPatching component oracle.ctx.rsf, 19.0.0.0.0...\n\nPatching component oracle.rdbms.dv, 19.0.0.0.0...\n\nPatching component oracle.ons, 19.0.0.0.0...\n\nPatching component oracle.javavm.server, 19.0.0.0.0...\n\nPatching component oracle.ldap.client, 19.0.0.0.0...\n\nPatching component oracle.ldap.rsf.ic, 19.0.0.0.0...\n\nPatching component oracle.xdk, 19.0.0.0.0...\n\nPatching component oracle.sdo.locator, 19.0.0.0.0...\n\nPatching component oracle.rdbms.rsf.ic, 19.0.0.0.0...\n\nPatching component oracle.precomp.common, 19.0.0.0.0...\n\nPatching component oracle.precomp.lang, 19.0.0.0.0...\n\nPatching component oracle.jdk, 1.8.0.201.0...\nPatch 33806152 successfully applied.\nSub-set patch [29517242] has become inactive due to the application of a super-set patch [33806152].\nPlease refer to Doc ID 2161861.1 for any possible further required actions.\nLog file location: \/u01\/app\/oracle\/product\/19c\/db_1\/cfgtoollogs\/opatch\/opatch2022-05-16_17-13-40PM_1.log\n\nOPatch succeeded.<\/code><\/pre>\n<ol start=\"5\">\n<li>\u5982\u679c\u6709\u9519\u8bef\uff0c\u8bf7\u53c2\u9605README.html<\/li>\n<\/ol>\n<h4><span class=\"ez-toc-section\" id=\"37_%E5%8A%A0%E8%BD%BD%E5%8F%98%E5%8C%96%E7%9A%84SQL%E5%88%B0%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>3.7. \u52a0\u8f7d\u53d8\u5316\u7684SQL\u5230\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>OPatchAuto \u81ea\u52a8\u8c03\u7528 datapatch \u5b8c\u6210\u5b89\u88c5\u6570\u636e\u5e93\u7684\u4e8c\u8fdb\u5236\u8865\u4e01\u5e76\u81ea\u52a8\u5f00\u59cb post patch \u7684\u64cd\u4f5c\u3002<br \/>\n\u5b89\u88c5\u524d\u4ed4\u7ec6\u9605\u8bfb README.html,\u4ee5\u4e0b\u6b65\u9aa4\u6267\u884c\u7684\u65f6\u95f4\u4f9d\u636e\u6570\u636e\u5e93\u7684\u5927\u5c0f\u4e0d\u540c\u800c\u6709\u6240\u5dee\u5f02\u3002<br \/>\n\u5b89\u88c5\u8865\u4e01\u4e4b\u540e\uff0c\u8fd8\u9700\u8981\u5c06\u6709\u53d8\u5316\u7684SQL\u52a0\u8f7d\u5230\u6570\u636e\u5e93\u4e2d\uff0c\u8fd9\u91cc\u53ef\u4ee5\u76f4\u63a5\u8fd0\u884cDatapatch\u5de5\u5177\u5c06\u8fd9\u4e9b\u4fee\u6539\u7684SQL\u91cd\u65b0\u52a0\u8f7d\u5230\u6570\u636e\u5e93\u4e2d\uff0c\u5982\u679c\u662fRAC\u73af\u5883\uff0c\u53ea\u9700\u8981\u5728\u4e00\u4e2a\u8282\u70b9\u6267\u884c\u5c31\u53ef\u4ee5\u4e86\u3002<br \/>\n\u6839\u636ereadme\u7684\u8bf4\u660e\uff0c\u64cd\u4f5c\u6b65\u9aa4\u5982\u4e0b\uff1a<\/p>\n<pre><code>~]$ sqlplus \/nolog\nSQL&gt; connect \/ as sysdba\nSQL&gt; startup\nSQL&gt; alter pluggable database all open;\nSQL&gt; quit\n~]$ cd $ORACLE_HOME\/OPatch\n~]$ .\/datapatch -verbose<\/code><\/pre>\n<p>\u8f93\u51fa\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<pre><code>SQL Patching tool version 19.15.0.0.0 Production on Mon May 16 17:27:38 2022\nCopyright (c) 2012, 2022, Oracle.  All rights reserved.\n\nLog file for this invocation: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/sqlpatch_19342_2022_05_16_17_27_39\/sqlpatch_invocation.log\n\nConnecting to database...OK\nGathering database info...done\n\nNote:  Datapatch will only apply or rollback SQL fixes for PDBs\n       that are in an open state, no patches will be applied to closed PDBs.\n       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation\n       (Doc ID 1585822.1)\n\nBootstrapping registry and package to current versions...done\nDetermining current state...done\n\nCurrent state of interim SQL patches:\n  No interim patches found\n\nCurrent state of release update SQL patches:\n  Binary registry:\n    19.15.0.0.0 Release_Update 220331125408: Installed\n  PDB CDB$ROOT:\n    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 04-APR-22 04.21.43.927999 PM\n  PDB ETDB1:\n    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 04-APR-22 04.28.11.473105 PM\n  PDB PDB$SEED:\n    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 04-APR-22 04.28.11.473105 PM\n  PDB STUDY:\n    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 04-APR-22 04.28.11.473105 PM\n\nAdding patches to installation queue and performing prereq checks...done\nInstallation queue:\n  For the following PDBs: CDB$ROOT PDB$SEED STUDY ETDB1\n    No interim patches need to be rolled back\n    Patch 33806152 (Database Release Update : 19.15.0.0.220419 (33806152)):\n      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.15.0.0.0 Release_Update 220331125408\n    No interim patches need to be applied\n\nWARNING: Following components are NOT in a valid state.\n         This could cause patching failure. If it does, consider\n         running utlrp.sql to bring components to VALID state.\n         Then, re-run datapatch.\n\n         ETDB1 : SDO [INVALID]\n         PDB$SEED : SDO [INVALID]\n\nInstalling patches...\nPatch installation complete.  Total patches installed: 4\n\nValidating logfiles...done\nPatch 33806152 apply (pdb CDB$ROOT): SUCCESS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/33806152\/24713297\/33806152_apply_ZYZH_CDBROOT_2022May16_17_28_21.log (no errors)\nPatch 33806152 apply (pdb PDB$SEED): SUCCESS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/33806152\/24713297\/33806152_apply_ZYZH_PDBSEED_2022May16_17_34_44.log (no errors)\nPatch 33806152 apply (pdb STUDY): SUCCESS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/33806152\/24713297\/33806152_apply_ZYZH_STUDY_2022May16_17_34_44.log (no errors)\nPatch 33806152 apply (pdb ETDB1): SUCCESS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/33806152\/24713297\/33806152_apply_ZYZH_ETDB1_2022May16_17_34_44.log (no errors)\n\nAutomatic recompilation incomplete; run utlrp.sql to revalidate.\n  PDBs: CDB$ROOT ETDB1 PDB$SEED STUDY\n\u81ea\u52a8\u91cd\u65b0\u7f16\u8bd1 incomplete \uff1b \u8fd0\u884c utlrp.sql \u91cd\u65b0\u9a8c\u8bc1\u3002\n\nSQL Patching tool complete on Mon May 16 17:40:03 2022<\/code><\/pre>\n<p><span style='color:red'>datapatch \u547d\u4ee4\u53ea\u5bf9\u6253\u5f00\u7684\u6570\u636e\u5e93\u751f\u6548\uff0c\u6240\u6709Oracle\u5efa\u8bae\u5728\u6267\u884c\u8be5\u547d\u4ee4\u4e4b\u524d\u5c06CDB\u548c\u6240\u6709\u7684PDB\u90fd\u6253\u5f00\uff0c\u4e00\u6b21\u66f4\u65b0\u6389\u3002 \u4f46\u5982\u679c\u6709\u90e8\u5206PDB\u6ca1\u6709\u6253\u5f00\uff0c\u4e5f\u53ef\u4ee5\u5728\u6253\u5f00\u4e4b\u540e\uff0c\u91cd\u65b0\u8fd0\u884c datapatch \u547d\u4ee4\u5e76\u5236\u5b9apdb\u5b9e\u4f8b\u540d\uff0c\u6bd4\u5982\uff1a <code>.\/datapatch -pdbs catpdb<\/code><\/span><\/p>\n<p>\u68c0\u67e5 <code>$ORACLE_HOME\/sqlpatch\/33806152\/<\/code> \u4e2d\u7684\u4ee5\u4e0b\u65e5\u5fd7\u6587\u4ef6\u662f\u5426\u6709\u9519\u8bef<\/p>\n<pre><code>33806152_apply_&lt;database SID&gt;_&lt;CDB name&gt;_&lt;timestamp&gt;.log\n# \u5176\u4e2d\uff0cdatabase SID\u662f\u6570\u636e\u5e93 SID\uff0cCDBname \u662f\u591a\u79df\u6237\u5bb9\u5668\u6570\u636e\u5e93\u7684\u540d\u79f0\uff0c\u65f6\u95f4\u6233\u662f YYYYMMMDD_HH_MM_SS \u5f62\u5f0f\u3002<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"38_%E5%A4%84%E7%90%86%E6%97%A0%E6%95%88%E5%AF%B9%E8%B1%A1\"><\/span>3.8. \u5904\u7406\u65e0\u6548\u5bf9\u8c61<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u4efb\u4f55\u5728\u6267\u884cdatapatch\u540e\u6709\u65e0\u6548\u5bf9\u8c61\u7684\u6570\u636e\u5e93\u90fd\u5e94\u8be5\u8fd0\u884cutlrp.sql\u6765\u91cd\u65b0\u9a8c\u8bc1\u8fd9\u4e9b\u5bf9\u8c61\u3002 \u4f8b\u5982\uff1a<\/p>\n<pre><code>~]$ cd $ORACLE_HOME\/rdbms\/admin\n~]$ sqlplus \/nolog\nSQL&gt; CONNECT \/ AS SYSDBA\nSQL&gt; @utlrp.sql<\/code><\/pre>\n<p>\u8f93\u51fa\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<pre><code>ERRORS DURING RECOMPILATION\n---------------------------\n              0\n\nFunction created.\n\nPL\/SQL procedure successfully completed.\n\nFunction dropped.\n\nPL\/SQL procedure successfully completed.<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"39_Upgrade_Oracle_Recovery_Manager_Catalog\"><\/span>3.9. Upgrade Oracle Recovery Manager Catalog<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5982\u679c\u60a8\u4f7f\u7528\u7684\u662f Oracle Recovery Manager\uff0c\u5219\u9700\u8981\u5347\u7ea7\u76ee\u5f55\u3002 \u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u8fdb\u884c\u5347\u7ea7\u3002 UPGRADE CATALOG \u547d\u4ee4\u5fc5\u987b\u8f93\u5165\u4e24\u6b21\u4ee5\u786e\u8ba4\u5347\u7ea7\u3002<\/p>\n<pre><code class=\"language-sql\">~]$ rman catalog username\/password@alias\nRMAN&gt; UPGRADE CATALOG;\nRMAN&gt; UPGRADE CATALOG;\nRMAN&gt; EXIT;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"310_%E6%9C%80%E5%90%8E%E6%A3%80%E6%9F%A5%E5%8D%87%E7%BA%A7%E5%90%8E%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93%E7%89%88%E6%9C%AC\"><\/span>3.10. \u6700\u540e\u68c0\u67e5\u5347\u7ea7\u540e\u7684\u6570\u636e\u5e93\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SET LINES 120 PAGES 999 HEADING OFF\nCOL con_id            FORMAT 999   HEADING &quot;ContainerID&quot;    NEWLINE\nCOL banner            FORMAT a120  HEADING &quot;Banner&quot;         NEWLINE\nCOL banner_full       FORMAT a120  HEADING &quot;Banner Full&quot;    NEWLINE\nCOL banner_legacy     FORMAT a20   HEADING &quot;Banner Legacy&quot;  NEWLINE\n\nSELECT &#039;ContainerID :  &#039;  || con_id,\n       &#039;Banner      :  &#039;  || banner,\n       &#039;Banner Full :  &#039;  || banner_full,\n       &#039;Banner Legacy: &#039;  || banner_legacy\n  FROM v$version;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/05\/image-1652694569198.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/05\/image-1652694569198.png\" alt=\"file\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u90d1\u91cd\u63d0\u9192\uff1a\u5347\u7ea7\u524d\u5fc5\u987b\u5907\u4efd\u6570\u636e\u5e93\uff0c\u5907\u4efdOracle\u5bb6&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,25],"tags":[212,211,16],"class_list":{"0":"post-1423","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-oracle","8":"tag-19-15","9":"tag-opatch","10":"tag-oracle"},"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/1423","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1423"}],"version-history":[{"count":13,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/1423\/revisions"}],"predecessor-version":[{"id":1710,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/1423\/revisions\/1710"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1423"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}