{"id":902,"date":"2021-09-23T21:56:52","date_gmt":"2021-09-23T13:56:52","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=902"},"modified":"2023-10-20T20:54:25","modified_gmt":"2023-10-20T12:54:25","slug":"oracle-19c-%e5%8d%95%e5%ae%9e%e4%be%8b-ru-%e4%bb%8e19-3-0-%e5%8d%87%e7%ba%a7%e5%88%b019-10-0","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=902","title":{"rendered":"Oracle 19c \u5355\u5b9e\u4f8b RU \u4ece19.3.0 \u5347\u7ea7\u523019.10.0"},"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-69f665e3a5baf\" 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-69f665e3a5baf\" 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=902\/#1_%E5%BD%93%E5%89%8D%E7%8E%AF%E5%A2%83\" >1. \u5f53\u524d\u73af\u5883<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/dba.qishuo.xin\/?p=902\/#11_%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F\" >1.1. \u64cd\u4f5c\u7cfb\u7edf<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/dba.qishuo.xin\/?p=902\/#12_%E6%95%B0%E6%8D%AE%E5%BA%93%E7%89%88%E6%9C%AC\" >1.2. \u6570\u636e\u5e93\u7248\u672c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/dba.qishuo.xin\/?p=902\/#2_%E5%AE%89%E8%A3%85%E8%A1%A5%E4%B8%81p32218454\" >2. \u5b89\u88c5\u8865\u4e01p32218454<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/dba.qishuo.xin\/?p=902\/#21_%E4%BB%8EMOS%E4%B8%8A%E4%B8%8B%E8%BD%BD%E8%A1%A5%E4%B8%81\" >2.1. \u4eceMOS\u4e0a\u4e0b\u8f7d\u8865\u4e01<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/dba.qishuo.xin\/?p=902\/#22_%E6%A3%80%E6%9F%A5OPatch%E5%B7%A5%E5%85%B7%E7%89%88%E6%9C%AC\" >2.2. \u68c0\u67e5OPatch\u5de5\u5177\u7248\u672c<\/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=902\/#23_%E6%9B%B4%E6%96%B0OPatch\" >2.3. \u66f4\u65b0OPatch<\/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=902\/#24_%E9%AA%8C%E8%AF%81_Oracle_Inventory\" >2.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-9\" href=\"http:\/\/dba.qishuo.xin\/?p=902\/#25_%E6%A3%80%E6%9F%A5Patch_%E6%98%AF%E5%90%A6%E5%86%B2%E7%AA%81\" >2.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-10\" href=\"http:\/\/dba.qishuo.xin\/?p=902\/#26_%E5%81%9C%E6%AD%A2%E6%95%B0%E6%8D%AE%E5%BA%93\" >2.6. \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-11\" href=\"http:\/\/dba.qishuo.xin\/?p=902\/#27_%E5%BA%94%E7%94%A8patch\" >2.7. \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=902\/#28_%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\" >2.8. \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=902\/#29_Upgrade_Oracle_Recovery_Manager_Catalog\" >2.9. Upgrade Oracle Recovery Manager Catalog<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p>\u5173\u4e8eOracle 19c \u7684RU\u548cRUR\u7684\u8bf4\u660e\uff0c\u8bf7\u53c2\u8003\uff1a<a target=\"_blank\" href=\"https:\/\/www.cndba.cn\/dave\/article\/4063\" title=\"https:\/\/www.cndba.cn\/dave\/article\/4063\">https:\/\/www.cndba.cn\/dave\/article\/4063<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_%E5%BD%93%E5%89%8D%E7%8E%AF%E5%A2%83\"><\/span>1. \u5f53\u524d\u73af\u5883<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"11_%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F\"><\/span>1.1. \u64cd\u4f5c\u7cfb\u7edf<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell\">~]$ cat \/etc\/os-release\n\nNAME=&quot;Oracle Linux Server&quot;\nVERSION=&quot;7.9&quot;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"12_%E6%95%B0%E6%8D%AE%E5%BA%93%E7%89%88%E6%9C%AC\"><\/span>1.2. \u6570\u636e\u5e93\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt;\nSET LINES 300 PAGES 999\nCOL PRODUCT FOR A40\nCOL VERSION FOR A20\nCOL VERSION_FULL FOR A20\nCOL STATUS FOR A30\n\nSELECT * FROM product_component_version;\n\nPRODUCT                                   VERSION         VERSION_FULL         STATUS\n---------------------------------------- -------------- ----------------- ----------------\nOracle Database 19c Enterprise Edition    19.0.0.0.0      19.3.0.0.0          Production<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"2_%E5%AE%89%E8%A3%85%E8%A1%A5%E4%B8%81p32218454\"><\/span>2. \u5b89\u88c5\u8865\u4e01p32218454<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong><span style='color:red'> \u7531\u4e8e\u5347\u7ea7\u7684\u65f6\u95f4\u8fc7\u4e8e\u6f2b\u957f\uff08\u5927\u7ea63~4\u5c0f\u65f6\uff09\uff0c\u5f3a\u70c8\u5efa\u8bae\u5728VNC\u4e2d\u5b8c\u6210\u4ee5\u4e0b\u64cd\u4f5c <\/span><\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"21_%E4%BB%8EMOS%E4%B8%8A%E4%B8%8B%E8%BD%BD%E8%A1%A5%E4%B8%81\"><\/span>2.1. \u4eceMOS\u4e0a\u4e0b\u8f7d\u8865\u4e01<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u4e0b\u8f7d\u5730\u5740\uff1a<a target=\"_blank\" href=\"https:\/\/support.oracle.com\/epmos\/faces\/PatchSearchResults?_adf.ctrl-state=6ar51xzdp_4&amp;_afrLoop=975901772498635\" title=\"https:\/\/support.oracle.com\/epmos\/faces\/PatchSearchResults?_adf.ctrl-state=6ar51xzdp_4&amp;_afrLoop=975901772498635\">https:\/\/support.oracle.com\/epmos\/faces\/PatchSearchResults?_adf.ctrl-state=6ar51xzdp_4&amp;_afrLoop=975901772498635<\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"22_%E6%A3%80%E6%9F%A5OPatch%E5%B7%A5%E5%85%B7%E7%89%88%E6%9C%AC\"><\/span>2.2. \u68c0\u67e5OPatch\u5de5\u5177\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u8981\u5b89\u88c5\u8865\u4e01 <strong>p32218454<\/strong> \uff0cOPatch \u5de5\u5177\u7684\u7248\u672c\u9700\u8981 <span style='color:red'> 12.2.0.1.23 <\/span>\u3002 \u5728Oracle 19.3\u7684\u7248\u672c\u4e2d\uff0cOPatch\u7248\u672c\u662f 12.2.0.1.17\uff0c\u6240\u4ee5\u9700\u8981\u66f4\u65b0OPatch\u3002<\/p>\n<pre><code class=\"language-shell\">cd $ORACLE_HOME\/OPatch\/\n.\/opatch version\n\nOPatch Version: 12.2.0.1.17\n\nOPatch succeeded.<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"23_%E6%9B%B4%E6%96%B0OPatch\"><\/span>2.3. \u66f4\u65b0OPatch<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5177\u4f53\u53ef\u53c2\u8003\uff1aHow To Download And Install The Latest OPatch(6880880) Version (Doc ID 274526.1)<br \/>\n<a target=\"_blank\" href=\"https:\/\/updates.oracle.com\/download\/6880880.html\" title=\"https:\/\/updates.oracle.com\/download\/6880880.html\">https:\/\/updates.oracle.com\/download\/6880880.html<\/a><br \/>\n\u6211\u4eec\u4e0b\u8f7d\u5230OPatch 12.2.0.1.24\uff0c\u6587\u4ef6\u540d\u4e3a\uff1a p6880880_180000_Linux-x86-64.zip<\/p>\n<pre><code class=\"language-shell\">unzip p6880880_180000_Linux-x86-64.zip -d $ORACLE_HOME\n  replace \/u01\/app\/oracle\/product\/19.3.0\/db_1\/OPatch\/emdpatch.pl? [y]es, [n]o, [A]ll, [N]one, [r]ename: \u8f93\u5165\uff1aA  # \u8986\u76d6\u6587\u4ef6\n\n$ORACLE_HOME\/OPatch\/opatch version\n\nOPatch Version: 12.2.0.1.24\n\nOPatch succeeded.<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"24_%E9%AA%8C%E8%AF%81_Oracle_Inventory\"><\/span>2.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 <code>GI home<\/code> \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\n\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation.  All rights reserved.\n\nOracle Home       : \/u01\/app\/oracle\/product\/19.3.0\/db_1\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19.3.0\/db_1\/oraInst.loc\nOPatch version    : 12.2.0.1.24\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19.3.0\/db_1\/cfgtoollogs\/opatch\/opatch2021-09-23_21-55-49PM_1.log\n\nLsinventory Output file location : \/u01\/app\/oracle\/product\/19.3.0\/db_1\/cfgtoollogs\/opatch\/lsinv\/lsinventory2021-09-23_21-55-49PM.txt\n--------------------------------------------------------------------------------\nLocal Machine Information::\nHostname: internalntp.lzu.edu.cn\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):<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"25_%E6%A3%80%E6%9F%A5Patch_%E6%98%AF%E5%90%A6%E5%86%B2%E7%AA%81\"><\/span>2.5. \u68c0\u67e5Patch \u662f\u5426\u51b2\u7a81<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell\"> cd \/home\/oracle\/software\/\nunzip p32218454_190000_Linux-x86-64_19.10.zip\ncd 32218454\/\n$ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -ph .\/\n\nOracle Interim Patch Installer version 12.2.0.1.17\nCopyright (c) 2021, Oracle Corporation.  All rights reserved.\n\nPREREQ session\n\nOracle Home       : \/u01\/app\/oracle\/product\/19.3.0\/db_1\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19.3.0\/db_1\/oraInst.loc\nOPatch version    : 12.2.0.1.24\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19.3.0\/db_1\/cfgtoollogs\/opatch\/opatch2021-09-23_20-36-48PM_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=\"26_%E5%81%9C%E6%AD%A2%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>2.6. \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<ol>\n<li>\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<\/li>\n<li>\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<\/li>\n<li>\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<\/li>\n<\/ol>\n<p><span style='color:red'>\u5173\u95ed\u5b9e\u4f8b\u548c\u76d1\u542c\uff0c\u5e76\u9000\u51fasqlplus<\/span><\/p>\n<pre><code class=\"language-shell\">lsnrctl stop\nsqlplus \/ as sysdba\nSQL&gt; shutdown immediate;\nSQL&gt; exit;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"27_%E5%BA%94%E7%94%A8patch\"><\/span>2.7. \u5e94\u7528patch<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u6574\u4e2a\u8fc7\u7a0b\u5927\u7ea6\u9700\u8981 30 \u5206\u949f\u3002<\/p>\n<pre><code class=\"language-shell\">pwd\n  \/home\/oracle\/software\/32218454\n\n$ORACLE_HOME\/OPatch\/opatch apply\n\nOracle Interim Patch Installer version 12.2.0.1.24\nCopyright (c) 2021, Oracle Corporation.  All rights reserved.\n\nOracle Home       : \/u01\/app\/oracle\/product\/19.3.0\/db_1\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19.3.0\/db_1\/oraInst.loc\nOPatch version    : 12.2.0.1.24\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19.3.0\/db_1\/cfgtoollogs\/opatch\/opatch2021-09-23_22-04-52PM_1.log\n\nVerifying environment and performing prerequisite checks...\nOPatch continues with these patches:   32218454\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\/19.3.0\/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;32218454&#039; to OH &#039;\/u01\/app\/oracle\/product\/19.3.0\/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.net.cman, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.xdk.companion, 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\nPatching component oracle.rdbms, 19.0.0.0.0...\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.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.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.dbtoolslistener, 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.network.rsf, 19.0.0.0.0...\n\nPatching component oracle.oracore.rsf, 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.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.xdk, 19.0.0.0.0...\n\nPatching component oracle.marvel, 19.0.0.0.0...\n\nPatching component oracle.xdk.rsf, 19.0.0.0.0...\n\nPatching component oracle.ctx.atg, 19.0.0.0.0...\n\nPatching component oracle.rdbms.scheduler, 19.0.0.0.0...\n\nPatching component oracle.rdbms.lbac, 19.0.0.0.0...\n\nPatching component oracle.duma, 19.0.0.0.0...\n\nPatching component oracle.ldap.rsf.ic, 19.0.0.0.0...\n\nPatching component oracle.odbc, 19.0.0.0.0...\n\nPatching component oracle.ctx.rsf, 19.0.0.0.0...\n\nPatching component oracle.oraolap.api, 19.0.0.0.0...\n\nPatching component oracle.xdk.parser.java, 19.0.0.0.0...\n\nPatching component oracle.oraolap, 19.0.0.0.0...\n\nPatching component oracle.sdo.locator, 19.0.0.0.0...\n\nPatching component oracle.sqlplus.ic, 19.0.0.0.0...\n\nPatching component oracle.mgw.common, 19.0.0.0.0...\n\nPatching component oracle.ons, 19.0.0.0.0...\n\nPatching component oracle.dbdev, 19.0.0.0.0...\n\nPatching component oracle.network.listener, 19.0.0.0.0...\n\nPatching component oracle.nlsrtl.rsf, 19.0.0.0.0...\n\nPatching component oracle.ovm, 19.0.0.0.0...\n\nPatching component oracle.oraolap.dbscripts, 19.0.0.0.0...\n\nPatching component oracle.xdk.xquery, 19.0.0.0.0...\n\nPatching component oracle.precomp.rsf, 19.0.0.0.0...\n\nPatching component oracle.javavm.client, 19.0.0.0.0...\n\nPatching component oracle.precomp.common.core, 19.0.0.0.0...\n\nPatching component oracle.ldap.security.osdt, 19.0.0.0.0...\n\nPatching component oracle.rdbms.oci, 19.0.0.0.0...\n\nPatching component oracle.rdbms.rman, 19.0.0.0.0...\n\nPatching component oracle.rdbms.crs, 19.0.0.0.0...\n\nPatching component oracle.rdbms.install.common, 19.0.0.0.0...\n\nPatching component oracle.javavm.server, 19.0.0.0.0...\n\nPatching component oracle.rdbms.drdaas, 19.0.0.0.0...\n\nPatching component oracle.rdbms.install.plugins, 19.0.0.0.0...\n\nPatching component oracle.rdbms.dv, 19.0.0.0.0...\n\nPatching component oracle.ldap.client, 19.0.0.0.0...\n\nPatching component oracle.network.client, 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 32218454 successfully applied.\nSub-set patch [29517242] has become inactive due to the application of a super-set patch [32218454].\nPlease refer to Doc ID 2161861.1 for any possible further required actions.\nLog file location: \/u01\/app\/oracle\/product\/19.3.0\/db_1\/cfgtoollogs\/opatch\/opatch2021-09-23_22-04-52PM_1.log\n\nOPatch succeeded.<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"28_%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>2.8. \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<span style='color:red'>\u5b89\u88c5\u524d\u4ed4\u7ec6\u9605\u8bfb <code>README.html<\/code>, \u4ee5\u4e0b\u8fc7\u7a0b\u4ece 22:36:40 \u5230 00:38:32 \u603b\u5171\u6301\u7eed\u4e86 2 \u4e2a\u5c0f\u65f6\u3002 <\/span><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 class=\"language-sql\">sqlplus \/nolog\nSQL&gt; Connect \/ as sysdba\nSQL&gt; startup\nSQL&gt; alter pluggable database all open;\nSQL&gt; quit\ncd $ORACLE_HOME\/OPatch\n.\/datapatch -verbose\n\nSQL Patching tool version 19.10.0.0.0 Production on Thu Sep 23 22:36:40 2021\nCopyright (c) 2012, 2020, Oracle.  All rights reserved.\n\nLog file for this invocation: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/sqlpatch_12580_2021_09_23_22_36_41\/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.10.0.0.0 Release_Update 210108185017: Installed\n  PDB CATPDB:\n    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-SEP-21 06.31.48.813994 PM\n  PDB CDB$ROOT:\n    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-SEP-21 05.49.42.337503 PM\n  PDB EMCCDB:\n    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-SEP-21 06.31.48.813994 PM\n  PDB PDB$SEED:\n    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-SEP-21 06.31.48.813994 PM\n\nAdding patches to installation queue and performing prereq checks...done\nInstallation queue:\n  For the following PDBs: CDB$ROOT EMCCDB\n    No interim patches need to be rolled back\n    Patch 32218454 (Database Release Update : 19.10.0.0.210119 (32218454)):\n      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.10.0.0.0 Release_Update 210108185017\n    No interim patches need to be applied\n  For the following PDBs: PDB$SEED CATPDB\n    No interim patches need to be rolled back\n    Patch 32218454 (Database Release Update : 19.10.0.0.210119 (32218454)):\n      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.10.0.0.0 Release_Update 210108185017\n    No interim patches need to be applied\n\nInstalling patches...\n\nPatch installation complete.  Total patches installed: 4\n\nValidating logfiles...done\nPatch 32218454 apply (pdb CDB$ROOT): SUCCESS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/32218454\/24018797\/32218454_apply_CATALOGD_CDBROOT_2021Sep23_22_40_56.log (no errors)\nPatch 32218454 apply (pdb EMCCDB): SUCCESS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/32218454\/24018797\/32218454_apply_CATALOGD_EMCCDB_2021Sep23_23_23_45.log (no errors)\nPatch 32218454 apply (pdb PDB$SEED): SUCCESS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/32218454\/24018797\/32218454_apply_CATALOGD_PDBSEED_2021Sep24_00_06_13.log (no errors)\nPatch 32218454 apply (pdb CATPDB): SUCCESS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/32218454\/24018797\/32218454_apply_CATALOGD_CATPDB_2021Sep24_00_06_13.log (no errors)\nSQL Patching tool complete on Fri Sep 24 00:38:32 2021<\/code><\/pre>\n<p><strong>datapatch<\/strong> \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 <strong>datapatch<\/strong> \u547d\u4ee4\u5e76\u5236\u5b9apdb\u5b9e\u4f8b\u540d\uff0c\u6bd4\u5982\uff1a <code>.\/datapatch -pdbs catpdb<\/code><\/p>\n<p><strong>\u68c0\u67e5 <code>$ORACLE_HOME\/sqlpatch\/32218454\/<\/code> \u4e2d\u7684\u4ee5\u4e0b\u65e5\u5fd7\u6587\u4ef6\u662f\u5426\u6709\u9519\u8bef<\/strong><\/p>\n<pre><code>32218454_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<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_8d32085678ab79c57f49e75e01644f4a.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_8d32085678ab79c57f49e75e01644f4a.jpg\" alt=\"\" \/><\/a><\/p>\n<p><strong>\u5904\u7406\u65e0\u6548\u5bf9\u8c61<\/strong><br \/>\n\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 class=\"language-sql\">cd $ORACLE_HOME\/rdbms\/admin\nsqlplus \/nolog\nSQL&gt; CONNECT \/ AS SYSDBA\nSQL&gt; @utlrp.sql<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_bc5f80f70a5695e442d99535c79fc464.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_bc5f80f70a5695e442d99535c79fc464.jpg\" alt=\"\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"29_Upgrade_Oracle_Recovery_Manager_Catalog\"><\/span>2.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 &#039;&quot;rco\/Hz571!xy00yz@172.16.36.168\/catpdb&quot;&#039;\n\nRMAN&gt; UPGRADE CATALOG;\nRMAN&gt; UPGRADE CATALOG;\nRMAN&gt; EXIT;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_66ebc8589cd75a64c653550330cf8ff2.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_66ebc8589cd75a64c653550330cf8ff2.jpg\" alt=\"\" \/><\/a><\/p>\n<p>\u81f3\u6b64\uff0c\u6574\u4e2a\u6570\u636e\u5e93\u8865\u4e01\u5b89\u88c5\u5b8c\u6210\uff0c\u518d\u6b21\u67e5\u770b\u6570\u636e\u5e93\u7248\u672c\uff1a<br \/>\n<a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_f016c86f06317b02c946b9e6c92b420f.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_f016c86f06317b02c946b9e6c92b420f.jpg\" alt=\"\" \/><\/a><\/p>\n<p>\u53c2\u8003\uff1a<strong>\u5b89\u88c5\u5305\u4e2d\u7684 README.html<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5173\u4e8eOracle 19c \u7684RU\u548cRUR\u7684\u8bf4\u660e\uff0c\u8bf7&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":[16,124],"class_list":{"0":"post-902","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-oracle","8":"tag-oracle","9":"tag-124"},"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/902","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=902"}],"version-history":[{"count":30,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/902\/revisions"}],"predecessor-version":[{"id":3420,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/902\/revisions\/3420"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=902"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}