{"id":2466,"date":"2022-12-15T10:38:40","date_gmt":"2022-12-15T02:38:40","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=2466"},"modified":"2022-12-15T10:54:12","modified_gmt":"2022-12-15T02:54:12","slug":"ora-39405-oracle-data-pump-does-not-support-importing-from-a-source-database-with-tstz-version-36","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=2466","title":{"rendered":"ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 36"},"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-69f62cfdf16a5\" 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-69f62cfdf16a5\" 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=2466\/#1_%E9%97%AE%E9%A2%98%E7%AE%80%E8%BF%B0\" >1. \u95ee\u9898\u7b80\u8ff0<\/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=2466\/#2_%E6%8A%A5%E9%94%99%E4%BF%A1%E6%81%AF\" >2. \u62a5\u9519\u4fe1\u606f<\/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=2466\/#21_%E6%8A%A5%E9%94%99%E5%86%85%E5%AE%B9\" >2.1. \u62a5\u9519\u5185\u5bb9<\/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=2466\/#22_%E6%8A%A5%E9%94%99%E6%88%AA%E5%9B%BE\" >2.2. \u62a5\u9519\u622a\u56fe<\/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=2466\/#3_%E9%97%AE%E9%A2%98%E5%88%86%E6%9E%90\" >3. \u95ee\u9898\u5206\u6790<\/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=2466\/#31_%E9%94%99%E8%AF%AF%E8%A7%A3%E9%87%8A\" >3.1. \u9519\u8bef\u89e3\u91ca<\/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=2466\/#32_%E5%88%86%E6%9E%90%E9%97%AE%E9%A2%98\" >3.2. \u5206\u6790\u95ee\u9898<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#4_%E9%97%AE%E9%A2%98%E8%A7%A3%E5%86%B3\" >4. \u95ee\u9898\u89e3\u51b3<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#41_%E4%B8%8B%E8%BD%BD%E6%9C%80%E6%96%B0%E7%9A%84_OPatch_%E5%92%8C_DSTV36_%E6%9B%B4%E6%96%B0%E8%A1%A5%E4%B8%81\" >4.1. \u4e0b\u8f7d\u6700\u65b0\u7684 OPatch \u548c DSTV36 \u66f4\u65b0\u8865\u4e01<\/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=2466\/#42_%E5%8D%87%E7%BA%A7Opatch%E7%89%88%E6%9C%AC\" >4.2. \u5347\u7ea7Opatch\u7248\u672c<\/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=2466\/#43_Patch%E5%BA%94%E7%94%A8%E5%89%8D%E7%A1%AE%E8%AE%A4_TZ_VERSION_%E7%9A%84%E7%89%88%E6%9C%AC\" >4.3. Patch\u5e94\u7528\u524d\u786e\u8ba4 TZ_VERSION \u7684\u7248\u672c<\/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=2466\/#44_%E5%B0%86_DSTV36_%E6%9B%B4%E6%96%B0%E8%A1%A5%E4%B8%81%E5%BA%94%E7%94%A8%E5%88%B0_ORACLE_HOME\" >4.4. \u5c06 DSTV36 \u66f4\u65b0\u8865\u4e01\u5e94\u7528\u5230 ORACLE HOME<\/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=2466\/#45_%E6%9F%A5%E7%9C%8B%E4%B8%8B%E8%BD%BD%E7%9A%84TZ%E7%89%88%E6%9C%AC\" >4.5. \u67e5\u770b\u4e0b\u8f7d\u7684TZ\u7248\u672c<\/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=2466\/#46_Upgrade_mode%E4%B8%8B%E5%90%AF%E5%8A%A8%E6%95%B0%E6%8D%AE%E5%BA%93\" >4.6. Upgrade mode\u4e0b\u542f\u52a8\u6570\u636e\u5e93<\/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=2466\/#47_%E5%8D%87%E7%BA%A7%E5%89%8D%E5%87%86%E5%A4%87\" >4.7. \u5347\u7ea7\u524d\u51c6\u5907<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#48_%E6%9F%A5%E6%89%BE%E5%8F%97%E5%BD%B1%E5%93%8D%E7%9A%84%E8%A1%A8\" >4.8. \u67e5\u627e\u53d7\u5f71\u54cd\u7684\u8868<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#49_%E7%BB%93%E6%9D%9F%E5%8D%87%E7%BA%A7%E5%89%8D%E5%87%86%E5%A4%87\" >4.9. \u7ed3\u675f\u5347\u7ea7\u524d\u51c6\u5907<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#410_%E5%BC%80%E5%A7%8B%E5%8D%87%E7%BA%A7TZ\" >4.10. \u5f00\u59cb\u5347\u7ea7TZ<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#411_%E5%85%B3%E9%97%AD%E5%8D%87%E7%BA%A7%E6%A8%A1%E5%BC%8F%EF%BC%8C%E6%AD%A3%E5%B8%B8%E5%90%AF%E5%8A%A8%E6%95%B0%E6%8D%AE%E5%BA%93\" >4.11. \u5173\u95ed\u5347\u7ea7\u6a21\u5f0f\uff0c\u6b63\u5e38\u542f\u52a8\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#412_%E7%BB%93%E6%9D%9F%E5%8D%87%E7%BA%A7\" >4.12. \u7ed3\u675f\u5347\u7ea7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#413_%E6%9F%A5%E7%9C%8B%E5%8D%87%E7%BA%A7%E7%BB%93%E6%9E%9C\" >4.13. \u67e5\u770b\u5347\u7ea7\u7ed3\u679c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#5_%E9%97%AE%E9%A2%98%E6%80%BB%E7%BB%93\" >5. \u95ee\u9898\u603b\u7ed3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#6_%E5%85%B6%E4%BB%96%E6%8B%93%E5%B1%95%E7%9F%A5%E8%AF%86\" >6. \u5176\u4ed6\u62d3\u5c55\u77e5\u8bc6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#%E9%99%84%E5%BD%95\" >\u9644\u5f55<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#%E9%99%84%E5%BD%95A_%E7%9B%B8%E5%85%B3%E8%81%94%E7%9A%84%E6%96%87%E7%AB%A0\" >\u9644\u5f55A. \u76f8\u5173\u8054\u7684\u6587\u7ae0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#%E9%99%84%E5%BD%95B_%E5%8F%82%E8%80%83\" >\u9644\u5f55B. \u53c2\u8003<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"http:\/\/dba.qishuo.xin\/?p=2466\/#%E9%99%84%E5%BD%95C_%E6%89%A7%E8%A1%8C_opatch_%E6%97%B6%E6%8A%A5%E9%94%99%E7%9A%84%E5%A4%84%E7%90%86\" >\u9644\u5f55C. \u6267\u884c opatch \u65f6\u62a5\u9519\u7684\u5904\u7406<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_%E9%97%AE%E9%A2%98%E7%AE%80%E8%BF%B0\"><\/span>1. \u95ee\u9898\u7b80\u8ff0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u6267\u884c impdp \u65f6\u62a5 <code>ORA-39405<\/code> \u9519\u8bef\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_%E6%8A%A5%E9%94%99%E4%BF%A1%E6%81%AF\"><\/span>2. \u62a5\u9519\u4fe1\u606f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"21_%E6%8A%A5%E9%94%99%E5%86%85%E5%AE%B9\"><\/span>2.1. \u62a5\u9519\u5185\u5bb9<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code>ORA-39002: invalid operation\nORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 36 into a target database with TSTZ version 32.<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"22_%E6%8A%A5%E9%94%99%E6%88%AA%E5%9B%BE\"><\/span>2.2. \u62a5\u9519\u622a\u56fe<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671009747576.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671009747576.png\" alt=\"file\" \/><\/a><\/p>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671009892449.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671009892449.png\" alt=\"file\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_%E9%97%AE%E9%A2%98%E5%88%86%E6%9E%90\"><\/span>3. \u95ee\u9898\u5206\u6790<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"31_%E9%94%99%E8%AF%AF%E8%A7%A3%E9%87%8A\"><\/span>3.1. \u9519\u8bef\u89e3\u91ca<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell\">[oracle@dbtest ~]$ oerr ora 39405\n39405, 00000, &quot;Oracle Data Pump does not support importing from a source database with TSTZ version %s into a target database with TSTZ version %s.&quot;\n\/\/ *Cause:    The source database was at a different time zone version than the\n\/\/            target database and there were tables that contained TIMESTAMP\n\/\/            WITH TIME ZONE (TSTZ) data.\n\/\/ *Action:   Convert the target database to the same time zone version or\n\/\/            later as the source database or use Oracle Data Pump with\n\/\/            conventional data movement to export then import this data.<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"32_%E5%88%86%E6%9E%90%E9%97%AE%E9%A2%98\"><\/span>3.2. \u5206\u6790\u95ee\u9898<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong>\u8fd9\u4e2a\u9519\u8bef\u662f\u56e0\u4e3a\u6570\u636e\u5e93\u65f6\u533a\u7248\u672c\u4e0d\u4e00\u81f4\u9020\u6210\u7684\uff0c\u5e76\u4e14\u662f\u6e90\u6570\u636e\u65f6\u533a\u7248\u672c\u9ad8\uff0c\u76ee\u6807\u6570\u636e\u5e93\u65f6\u533a\u7248\u672c\u4f4e\u3002<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_%E9%97%AE%E9%A2%98%E8%A7%A3%E5%86%B3\"><\/span>4. \u95ee\u9898\u89e3\u51b3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong><span style='color:red'>\u5b89\u88c5\u65f6\u533a\u8865\u4e0129997937\uff0c\u5177\u4f53\u6b65\u9aa4\u5982\u4e0b\uff1a<\/span><\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"41_%E4%B8%8B%E8%BD%BD%E6%9C%80%E6%96%B0%E7%9A%84_OPatch_%E5%92%8C_DSTV36_%E6%9B%B4%E6%96%B0%E8%A1%A5%E4%B8%81\"><\/span>4.1. \u4e0b\u8f7d\u6700\u65b0\u7684 OPatch \u548c DSTV36 \u66f4\u65b0\u8865\u4e01<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\n<p>Opatch Version Patch:<br \/>\n<a target=\"_blank\" href=\"https:\/\/updates.oracle.com\/download\/6880880.html\">https:\/\/updates.oracle.com\/download\/6880880.html<\/a><br \/>\n\u4e0b\u8f7d\u7684\u6587\u4ef6\u540d\uff1ap6880880_190000_Linux-x86-64.zip<\/p>\n<\/li>\n<li>\n<p>DST V36 Patch:<br \/>\n<a target=\"_blank\" href=\"https:\/\/updates.oracle.com\/download\/32327201.html\">https:\/\/updates.oracle.com\/download\/32327201.html<\/a><br \/>\n\u4e0b\u8f7d\u7684\u6587\u4ef6\u540d\uff1ap32327201_190000_Linux-x86-64.zip<\/p>\n<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"42_%E5%8D%87%E7%BA%A7Opatch%E7%89%88%E6%9C%AC\"><\/span>4.2. \u5347\u7ea7Opatch\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5c06\u4e0b\u8f7d\u597d\u7684\u6587\u4ef6\u62f7\u8d1d\u5230Oracle\u7528\u6237\u7684\u6839\u76ee\u5f55\u4e0b\uff0c\u5e76\u4fee\u6539\u6587\u4ef6\u6743\u9650\u8ba9oracle\u53ef\u6267\u884c\uff0c\u7136\u540e\u5207\u6362\u5230Oracle\u7528\u6237\uff0c\u6267\u884c\u4e0b\u5217\u64cd\u4f5c\u3002<\/p>\n<pre><code class=\"language-shell\"># \u68c0\u67e5\u5f53\u524d OPatch \u7684\u7248\u672c\n~]$ $ORACLE_HOME\/OPatch\/opatch version\nOPatch Version: 12.2.0.1.17\nOPatch succeeded.\n# \u5907\u4efd\u5f53\u524d OPatch \u76ee\u5f55\n~]$ mv $ORACLE_HOME\/OPatch $ORACLE_HOME\/OPatch_bak\n# \u89e3\u538b\u6700\u65b0\u7684 OPatch \u5230 ORACLE_HOME \u76ee\u5f55\n~]$ unzip p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME\/\n..... # \u8fd9\u91cc\u7701\u7565\u89e3\u538b\u7684\u5185\u5bb9\n# \u68c0\u67e5\u66f4\u65b0\u540e OPatch \u7684\u7248\u672c\n~]$ $ORACLE_HOME\/OPatch\/opatch version\nOPatch Version: 12.2.0.1.35\n\nOPatch succeeded.<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"43_Patch%E5%BA%94%E7%94%A8%E5%89%8D%E7%A1%AE%E8%AE%A4_TZ_VERSION_%E7%9A%84%E7%89%88%E6%9C%AC\"><\/span>4.3. Patch\u5e94\u7528\u524d\u786e\u8ba4 TZ_VERSION \u7684\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u767b\u5f55\u5230Oracle\u6570\u636e\u5e93\uff0c\u6267\u884c\u4e0b\u5217\u64cd\u4f5c\u3002<\/p>\n<pre><code class=\"language-sql\">SQL&gt; select tz_version from registry$database;\n\nTZ_VERSION\n----------\n        32\n\nSQL&gt; SELECT DBMS_DST.get_latest_timezone_version FROM dual;\n\nGET_LATEST_TIMEZONE_VERSION\n---------------------------\n                         32<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"44_%E5%B0%86_DSTV36_%E6%9B%B4%E6%96%B0%E8%A1%A5%E4%B8%81%E5%BA%94%E7%94%A8%E5%88%B0_ORACLE_HOME\"><\/span>4.4. \u5c06 DSTV36 \u66f4\u65b0\u8865\u4e01\u5e94\u7528\u5230 ORACLE HOME<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5c06\u4e0b\u8f7d\u597d\u7684\u6587\u4ef6\u62f7\u8d1d\u5230Oracle\u7528\u6237\u7684\u6839\u76ee\u5f55\u4e0b\uff0c\u5e76\u4fee\u6539\u6587\u4ef6\u6743\u9650\u8ba9oracle\u53ef\u6267\u884c\uff0c\u7136\u540e\u5207\u6362\u5230Oracle\u7528\u6237\uff0c\u6267\u884c\u4e0b\u5217\u64cd\u4f5c\u3002<\/p>\n<pre><code class=\"language-shell\"># \u89e3\u538b\u6587\u4ef6\n~]$ unzip p32327201_210000_Linux-x86-64.zip\n..... # \u8fd9\u91cc\u7701\u7565\u89e3\u538b\u7684\u5185\u5bb9\n# \u9884\u68c0\u67e5\u5347\u7ea7\n~]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -ph ~\/32327201\/<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671067609594.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671067609594.png\" alt=\"file\" \/><\/a><\/p>\n<p>\u5c06\u8865\u4e01\u5e94\u7528\u5230 ORACLE_HOME \u76ee\u5f55\u4e0b\uff1a<\/p>\n<pre><code class=\"language-shell\"># \u8fdb\u5165\u8865\u4e01\u76ee\u5f55\n~]$ cd .\/32327201\/\n~]$ $ORACLE_HOME\/OPatch\/opatch apply -oh $ORACLE_HOME\/\n~]$ $ORACLE_HOME\/OPatch\/opatch lsinv | grep -i &quot;DSTV36 UPDATE&quot;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671070231339.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671070231339.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"45_%E6%9F%A5%E7%9C%8B%E4%B8%8B%E8%BD%BD%E7%9A%84TZ%E7%89%88%E6%9C%AC\"><\/span>4.5. \u67e5\u770b\u4e0b\u8f7d\u7684TZ\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt; SELECT DBMS_DST.get_latest_timezone_version FROM dual;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671070465114.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671070465114.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"46_Upgrade_mode%E4%B8%8B%E5%90%AF%E5%8A%A8%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>4.6. Upgrade mode\u4e0b\u542f\u52a8\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt;\n-- \u5173\u95ed\u6570\u636e\u5e93\nshutdown immediate;\n-- \u542f\u52a8\u6570\u636e\u5e93\u5230\u5347\u7ea7\u6a21\u5f0f\nstartup upgrade;\n-- \u67e5\u8be2\u6570\u636e\u5e93\u4e0e\u5b9e\u4f8b\u72b6\u6001\nSELECT name, open_mode FROM v$database;\nSELECT instance_name, status FROM v$instance;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071171572.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071171572.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"47_%E5%8D%87%E7%BA%A7%E5%89%8D%E5%87%86%E5%A4%87\"><\/span>4.7. \u5347\u7ea7\u524d\u51c6\u5907<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt;\nDECLARE\n  l_tz_version PLS_INTEGER;\nBEGIN\n  l_tz_version := DBMS_DST.get_latest_timezone_version;\n\n  DBMS_OUTPUT.put_line(&#039;l_tz_version=&#039; || l_tz_version);\n  DBMS_DST.begin_prepare(l_tz_version);\nEND;\n\/<\/code><\/pre>\n<pre><code class=\"language-sql\">SQL&gt;\nCOLUMN property_name FORMAT A30\nCOLUMN property_value FORMAT A20\n\nSELECT property_name, property_value\n  FROM database_properties\n WHERE property_name LIKE &#039;DST_%&#039;\n ORDER BY property_name;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071239345.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071239345.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"48_%E6%9F%A5%E6%89%BE%E5%8F%97%E5%BD%B1%E5%93%8D%E7%9A%84%E8%A1%A8\"><\/span>4.8. \u67e5\u627e\u53d7\u5f71\u54cd\u7684\u8868<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt;\nEXEC DBMS_DST.find_affected_tables;\nSELECT COUNT(*) FROM sys.dst$affected_tables;\nSELECT * FROM sys.dst$error_table;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071302399.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071302399.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"49_%E7%BB%93%E6%9D%9F%E5%8D%87%E7%BA%A7%E5%89%8D%E5%87%86%E5%A4%87\"><\/span>4.9. \u7ed3\u675f\u5347\u7ea7\u524d\u51c6\u5907<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt;\nEXEC DBMS_DST.end_prepare;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071316917.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071316917.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"410_%E5%BC%80%E5%A7%8B%E5%8D%87%E7%BA%A7TZ\"><\/span>4.10. \u5f00\u59cb\u5347\u7ea7TZ<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt;\nSET SERVEROUTPUT ON\nDECLARE\n  l_tz_version PLS_INTEGER;\nBEGIN\n  SELECT DBMS_DST.get_latest_timezone_version\n  INTO   l_tz_version\n  FROM   dual;\n\n  DBMS_OUTPUT.put_line(&#039;l_tz_version=&#039; || l_tz_version);\n  DBMS_DST.begin_upgrade(l_tz_version);\nEND;\n\/<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071419784.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071419784.png\" alt=\"file\" \/><\/a><\/p>\n<p><span style='color:red'>\u5982\u679c\u662f\u5bb9\u5668\u6570\u636e\u5e93\uff0c\u90a3\u4e48\u5404\u4e2aPDB\u4e5f\u9700\u8981\u5347\u7ea7\uff0c\u6211\u6682\u65f6\u4e0d\u77e5\u9053\u5982\u4f55\u4e00\u6b21\u5347\u7ea7\u6240\u6709\u7684PDB<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"411_%E5%85%B3%E9%97%AD%E5%8D%87%E7%BA%A7%E6%A8%A1%E5%BC%8F%EF%BC%8C%E6%AD%A3%E5%B8%B8%E5%90%AF%E5%8A%A8%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>4.11. \u5173\u95ed\u5347\u7ea7\u6a21\u5f0f\uff0c\u6b63\u5e38\u542f\u52a8\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt;\nshut immediate;\nstartup;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"412_%E7%BB%93%E6%9D%9F%E5%8D%87%E7%BA%A7\"><\/span>4.12. \u7ed3\u675f\u5347\u7ea7<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt;\nSET SERVEROUTPUT ON\nDECLARE\n  l_failures   PLS_INTEGER;\nBEGIN\n  DBMS_DST.upgrade_database(l_failures);\n  DBMS_OUTPUT.put_line(&#039;DBMS_DST.upgrade_database : l_failures=&#039; || l_failures);\n  DBMS_DST.end_upgrade(l_failures);\n  DBMS_OUTPUT.put_line(&#039;DBMS_DST.end_upgrade : l_failures=&#039; || l_failures);\nEND;\n\/<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071687330.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671071687330.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"413_%E6%9F%A5%E7%9C%8B%E5%8D%87%E7%BA%A7%E7%BB%93%E6%9E%9C\"><\/span>4.13. \u67e5\u770b\u5347\u7ea7\u7ed3\u679c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt;\nCOLUMN property_name FORMAT A30\nCOLUMN property_value FORMAT A20\n\nSELECT property_name, property_value\n  FROM database_properties\n WHERE property_name LIKE &#039;DST_%&#039;\n ORDER BY property_name;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671072848247.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671072848247.png\" alt=\"file\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_%E9%97%AE%E9%A2%98%E6%80%BB%E7%BB%93\"><\/span>5. \u95ee\u9898\u603b\u7ed3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"6_%E5%85%B6%E4%BB%96%E6%8B%93%E5%B1%95%E7%9F%A5%E8%AF%86\"><\/span>6. \u5176\u4ed6\u62d3\u5c55\u77e5\u8bc6<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"%E9%99%84%E5%BD%95\"><\/span>\u9644\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"%E9%99%84%E5%BD%95A_%E7%9B%B8%E5%85%B3%E8%81%94%E7%9A%84%E6%96%87%E7%AB%A0\"><\/span>\u9644\u5f55A. \u76f8\u5173\u8054\u7684\u6587\u7ae0<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<h4><span class=\"ez-toc-section\" id=\"%E9%99%84%E5%BD%95B_%E5%8F%82%E8%80%83\"><\/span>\u9644\u5f55B. \u53c2\u8003<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\n<p><a target=\"_blank\" href=\"https:\/\/www.cnblogs.com\/hmwh\/p\/14877905.html\" title=\"ORA-39405: Oracle Data Pump \u65f6\u533a\u5347\u7ea7\">ORA-39405: Oracle Data Pump \u65f6\u533a\u5347\u7ea7<\/a><\/p>\n<\/li>\n<li>\n<p><a target=\"_blank\" href=\"https:\/\/blog.csdn.net\/weixin_36782521\/article\/details\/124320439\" title=\"ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 36\">ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 36<\/a><\/p>\n<\/li>\n<li>\n<p><a target=\"_blank\" href=\"https:\/\/www.cnblogs.com\/kerrycode\/p\/3666789.html\" title=\"\u6f47\u6e58\u9690\u8005 - ORACLE opatch\u547d\u4ee4\u5b66\u4e60\u5b9e\u8df5\">\u6f47\u6e58\u9690\u8005 - ORACLE opatch\u547d\u4ee4\u5b66\u4e60\u5b9e\u8df5<\/a><\/p>\n<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"%E9%99%84%E5%BD%95C_%E6%89%A7%E8%A1%8C_opatch_%E6%97%B6%E6%8A%A5%E9%94%99%E7%9A%84%E5%A4%84%E7%90%86\"><\/span>\u9644\u5f55C. \u6267\u884c opatch \u65f6\u62a5\u9519\u7684\u5904\u7406<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>1\uff09opatch lsinventory \u62a5oraInst.loc\u6587\u4ef6\u4e0d\u5b58\u5728<\/p>\n<p><strong>\u62f7\u8d1d oraInst.loc \u6587\u4ef6\u5230 ORACLE HOME \u76ee\u5f55<\/strong><\/p>\n<pre><code class=\"language-shell\">~]$ cp \/etc\/oraInst.loc $ORACLE_HOME\/<\/code><\/pre>\n<p>2\uff09PrereqSession failed: RawInventory gets null OracleHomeInfo<\/p>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671066943783.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671066943783.png\" alt=\"file\" \/><\/a><\/p>\n<p>\u89e3\u51b3\u529e\u6cd5\uff1a<br \/>\n<span style='color:red'>\u5207\u6362\u5230ORACLE_HOME\u76ee\u5f55\u5e76\u5c06\u5176\u9644\u52a0\u5230oraInventory\u4e2d<\/span><\/p>\n<pre><code class=\"language-shell\">~]$ cd $ORACLE_HOME\/oui\/bin\n~]$ .\/attachHome.sh<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671067410731.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671067410731.png\" alt=\"file\" \/><\/a><\/p>\n<p>\u5982\u679c\u6267\u884c\u4e0a\u8ff0\u547d\u4ee4\u53c8\u5982\u4e0b\u9519\u8bef\uff1a<\/p>\n<pre><code>You do not have sufficient permissions to access the inventory &#039;\/u01\/app\/oraInventory&#039;. Installation cannot continue. It is required that the primary group of the install user is same as the inventory owner group. Make sure that the install user is part of the inventory owner group and restart the installer.<\/code><\/pre>\n<p>3\uff09Permission denied on \/u01\/app\/oraInventory<\/p>\n<p>\u5373Oracle\u7528\u6237\u6ca1\u6709\u6743\u9650\u4fee\u6539<code>\/u01\/app\/oraInventory<\/code>\u4e2d\u7684\u6587\u4ef6\uff0c\u53ef\u5207\u6362\u5230<code>grid<\/code>\u7528\u6237\u4e0b\uff0c\u6267\u884c\u4fee\u6539oraInventory\u7684\u76ee\u5f55\u6743\u9650\uff0c\u8ba9\u540c\u7ec4(\u76f8\u540coinstall\u7ec4)\u7684\u7528\u6237\u53ef\u4fee\u6539\u548c\u6267\u884c\u8be5\u6587\u4ef6\u3002<\/p>\n<pre><code class=\"language-shell\">~]$ chmod -R g+wx \/u01\/app\/oraInventory<\/code><\/pre>\n<p>3\uff09\u4f7f\u7528\u547d\u4ee4 <code>\/opatch lsinventory<\/code>\u663e\u793a\u5728\u4e2d\u592e\u6e05\u5355\u4e2d\u6ce8\u518c\u7684\u6240\u6709OracleHome\u7684\u8865\u4e01\u60c5\u51b5\u3002<\/p>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671068519971.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2022\/12\/image-1671068519971.png\" alt=\"file\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. \u95ee\u9898\u7b80\u8ff0 \u6267\u884c impdp \u65f6\u62a5 ORA-3&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":[237,16,238],"class_list":{"0":"post-2466","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-oracle","8":"tag-ora-39405","9":"tag-oracle","10":"tag-tstz"},"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/2466","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=2466"}],"version-history":[{"count":15,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/2466\/revisions"}],"predecessor-version":[{"id":2614,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/2466\/revisions\/2614"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2466"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}