﻿{"id":1454,"date":"2019-03-13T17:30:30","date_gmt":"2019-03-13T09:30:30","guid":{"rendered":"http:\/\/www.llku.com\/?p=1454"},"modified":"2019-03-13T17:30:30","modified_gmt":"2019-03-13T09:30:30","slug":"oracle%e8%a1%a5%e4%b8%81%e5%8f%8aopatch%e5%b7%a5%e5%85%b7%e4%bb%8b%e7%bb%8d","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1454","title":{"rendered":"Oracle\u8865\u4e01\u53caopatch\u5de5\u5177\u4ecb\u7ecd"},"content":{"rendered":"<p>\n\t\u4e00\uff0e CPU\uff08Critical Patch Update\uff09\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u4e00\u4e2aCPU\u5185\u5305\u542b\u4e86\u5bf9\u591a\u4e2a\u5b89\u5168\u6f0f\u6d1e\u7684\u4fee\u590d\uff0c\u5e76\u4e14\u4e5f\u5305\u62ec\u76f8\u5e94\u5fc5\u9700\u7684\u975e\u5b89\u5168\u6f0f\u6d1e\u7684\u8865\u4e01\u3002CPU\u662f\u7d2f\u79ef\u578b\u7684\uff0c\u53ea\u8981\u5b89\u88c5\u6700\u65b0\u53d1\u5e03\u7684CPU\u5373\u53ef\uff0c\u5176\u4e2d\u5305\u62ec\u4e4b\u524d\u53d1\u5e03\u7684\u6240\u6709CPU\u7684\u5185\u5bb9\u3002\u4e8b\u5b9e\u4e0a\uff0c\u5728CPU\u4e4b\u524d\u7684\u5b89\u5168\u6f0f\u6d1e\u4fee\u6539\u9664\u53bb\u4e2a\u522b\u4f8b\u5916\u4e5f\u88ab\u5305\u62ec\u5728CPU\u4e2d\u3002Oracle\u516c\u53f8\u53ea\u5bf9\u5904\u4e8e\u6807\u51c6\u6280\u672f\u652f\u6301\u548c\u5ef6\u957f\u652f\u6301\u671f\u95f4\u7684\u4ea7\u54c1\u63d0\u4f9bCPU\u66f4\u65b0\uff0c\u5bf9\u5904\u4e8e\u7ef4\u6301\u652f\u6301\u8303\u56f4\u7684\u4ea7\u54c1\u4e0d\u63d0\u4f9b\u65b0\u7684CPU.\uff08\u5bf9\u4e8e9.2\u4ee5\u524d\u7684\u7248\u672c\uff0c\u53ea\u5bf9\u5904\u4e8eECS\u548cEMS\u671f\u95f4\u7684\u7248\u672c\u63d0\u4f9bCPU\u66f4\u65b0\u3002\uff09\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u4e00\u822c\u5bf9\u5f53\u524d\u8865\u4e01\u53d1\u884c\u7248\u53ca\u524d\u4e00\u4e2a\u7248\u672c\u63d0\u4f9bCPU\uff0c\u4f46\u4e5f\u6709\u53ea\u9650\u4e8e\u5f53\u524d\u8865\u4e01\u53d1\u884c\u7248\u7684\u4f8b\u5916\u60c5\u5f62\u3002\u4e5f\u5c31\u662f\u8bf4\uff0c\u4e00\u822c\u9700\u8981\u5148\u5b89\u88c5\u6700\u65b0PSR\u540e\u624d\u53ef\u80fd\u5b89\u88c5CPU.\u7531\u4e8e\u662f\u7d2f\u79ef\u578b\u7684\u5b9a\u671f\u53d1\u5e03\uff0c\u6240\u4ee5\u5bf9\u4e8e\u67d0\u4e00\u5e73\u53f0\u7684\u67d0\u4e00\u7248\u672c\uff0c\u5982\u679c\u4e24\u6b21CPU\u53d1\u5e03\u671f\u95f4\u6ca1\u6709\u53d1\u73b0\u65b0\u7684\u5b89\u5168\u6f0f\u6d1e\uff0c\u5219\u65b0\u53d1\u5e03\u7684CPU\u4e0e\u524d\u4e00\u7248\u672c\u5b8c\u5168\u76f8\u540c\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u53ef\u4ee5\u5728\u4ee5\u4e0b\u7f51\u5740\u4e2d\u53ef\u4ee5\u627e\u5230CPU\u53d1\u5e03\u7684\u4fe1\u606f\uff0c\u53ea\u8981\u5728Oracle \u514d\u8d39\u6ce8\u518c\u4e00\u4e2a\u7528\u6237\uff0c\u5c31\u53ef\u4ee5\u6536\u5230\u8fd9\u4e9b\u8865\u4e01\u7684\u4fe1\u606f\u3002\u4f46\u662f\uff0c\u53ea\u6709\u6280\u672f\u652f\u6301\u7b7e\u7ea6\u7528\u6237\u624d\u53ef\u4ee5\u4ecemetalink\u4e0b\u8f7d\u8865\u4e01\u6587\u4ef6\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; http:\/\/www.oracle.com\/technology\/deploy\/security\/alerts.htm\n<\/p>\n<p>\n\t&nbsp; &nbsp; Oracle\u516c\u53f8\u5236\u5b9a\u7684CPU\u7684\u53d1\u5e03\u65e5\u671f\u5927\u7ea6\u5728\u4e00\u6708\u3001\u56db\u6708\u3001\u4e03\u6708\u548c\u5341\u6708\u7684\u6700\u63a5\u8fd115\u7684\u661f\u671f\u4e8c\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; Critical Patch Updates\n<\/p>\n<p>\n\t&nbsp; &nbsp; Critical Patch Updates are the primary means of releasing security fixes for Oracle products to customers with valid support contracts. They are released on the Tuesday closest to the 15th day of January, April, July and October. Starting 2011, the scheduled dates for the release of Critical Patch Updates will be on the Tuesday closest to the 17th day of January, April, July and October. The next four dates are:\n<\/p>\n<p>\n\t&nbsp; &nbsp; 12 October 2010\n<\/p>\n<p>\n\t&nbsp; &nbsp; 18 January 2011\n<\/p>\n<p>\n\t&nbsp; &nbsp; 19 April 2011\n<\/p>\n<p>\n\t&nbsp; &nbsp; 19 July 2011\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u5bf9\u4e8e\u6bcf\u4e00\u4e2aCPU\uff0c\u9644\u6709\u76f8\u5e94\u7684\u8bf4\u660e\u6587\u6863\uff08Critical Patch Update Note\uff09\uff0c\u5176\u4e2d\u4ecb\u7ecd\u5b89\u88c5\u8fc7\u7a0b\u548c\u6ce8\u610f\u4e8b\u9879\uff0c\u5728\u5b89\u88c5\u4e4b\u524d\u5e94\u8ba4\u771f\u9605\u8bfb\u6b64\u6587\u6863\u3002\u540c\u6837\u4e5f\u5b58\u5728\u6587\u6863&ldquo;Oracle Critical Patch Update MM YYYY Known Issues for Oracle Database&rdquo;\uff0c\u5176\u4e2d\u5217\u51fa\u4e86\u8bf4\u660e\u6587\u6863\u4e2d\u6ca1\u6709\u7ed9\u51fa\u7684\u65b0\u4fe1\u606f\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u4e8c\uff0ePSR\uff08Patch Set Release\uff09 \u548c PSU\uff08Patch Set Update\uff09\n<\/p>\n<p>\n\t&nbsp; &nbsp; 8i,9i,10g,11g\u8fd9\u662f\u5176\u4e3b\u8981\u7248\u672c\u53f7\uff0c\u6bcf\u4e00\u7248\u672c\u4f1a\u9646\u7eed\u6709\u4e24\u81f3\u4e09\u4e2a\u53d1\u884c\u7248\uff0c\u598210.1\uff0c10.2,\u548c 11.1\uff0c11.2\u5206\u522b\u662f10g\u548c11g\u7684\u4e24\u4e2a\u53d1\u884c\u7248\u3002\u5bf9\u4e8e\u6bcf\u4e00\u4e2a\u53d1\u884c\u7248\u8f6f\u4ef6\u4e2d\u53d1\u73b0\u7684BUG\uff0c\u7ed9\u51fa\u76f8\u5e94\u7684\u4fee\u590d\u8865\u4e01\u3002\u6bcf\u9694\u4e00\u5b9a\u65f6\u671f\uff0c\u4f1a\u5c06\u6240\u6709\u8865\u4e01\u96c6\u6210\u5230\u8f6f\u4ef6\u4e2d\uff0c\u7ecf\u8fc7\u96c6\u6210\u6d4b\u8bd5\u540e\uff0c\u8fdb\u884c\u53d1\u5e03\uff0c\u4e5f\u79f0\u4e3aPSR\uff08Patch Set Release\uff09\u3002\u4ee510.2\u4e3a\u4f8b\uff0c10.2.0.1.0\u662f\u57fa\u7840\u53d1\u884c\u7248\uff0c\u81f3\u4eca\u5df2\u6709\u4e09\u4e2aPSR\u53d1\u5e03\uff0c\u6bcf\u4e2aPSR\u4fee\u65395\u4f4d\u7248\u672c\u53f7\u7684\u7b2c4\u4f4d\uff0c\u6700\u65b010.2\u7684PSR\u4e3a10.2.0.4.0\u3002(11.1.0.6.0\u662f11.1\u7684\u57fa\u7840\u53d1\u884c\u7248\uff0c11.1.0.7.0\u662f\u7b2c\u4e00\u6b21PSR) \u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u5728\u67d0\u4e2aPSR\u4e4b\u540e\u7f16\u5199\u7684\u8865\u4e01\uff0c\u5728\u8fd8\u6ca1\u6709\u52a0\u5165\u5230\u4e0b\u4e00\u4e2aPSR\u4e4b\u524d\uff0c\u4ee5\u4e2a\u522b\u8865\u4e01\uff08Interim Patch\uff09\u7684\u5f62\u5f0f\u63d0\u4f9b\u7ed9\u5ba2\u6237\u3002\u67d0\u4e2a\u4e2a\u522b\u8865\u4e01\u662f\u9488\u5bf9Oracle\u516c\u53f8\u53d1\u73b0\u7684\u6216\u5ba2\u6237\u62a5\u544a\u7684\u67d0\u4e00\u4e2aBUG\u7f16\u5199\u7684\u8865\u4e01\uff0c\u591a\u4e2a\u4e2a\u522b\u8865\u4e01\u4e4b\u95f4\u4e00\u540c\u5b89\u88c5\u65f6\u53ef\u80fd\u4f1a\u6709\u51b2\u7a81\uff0c\u5373\u540c\u4e00\u4e2a\u76ee\u6807\u6a21\u5757\u5206\u522b\u8fdb\u884c\u4e86\u4e0d\u540c\u7684\u4fee\u6539\u3002\u53e6\u5916\uff0c\u5373\u4fbf\u5728\u5b89\u88c5\u65f6\u6ca1\u6709\u53d1\u73b0\u51b2\u7a81\uff0c\u7531\u4e8e\u6ca1\u6709\u8fdb\u884c\u4e25\u683c\u7684\u96c6\u6210\u6d4b\u8bd5\uff0c\u8fd0\u884c\u8fc7\u7a0b\u4e2d\u7531\u4e8e\u76f8\u4e92\u4f5c\u7528\u662f\u5426\u4f1a\u53d1\u751f\u610f\u5916\u4e5f\u4e0d\u80fd\u5b8c\u5168\u6392\u9664\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u9664\u53bb\u4fee\u6539\u529f\u80fd\u548c\u6027\u80fdBUG\u7684\u8865\u4e01\uff0c\u8fd8\u6709\u5e94\u5bf9\u5b89\u5168\u6f0f\u6d1e\u7684\u5b89\u5168\u8865\u4e01\u3002Oracle\u516c\u53f8\u5b9a\u671f\uff08\u4e00\u5e74\u56db\u671f\uff09\u53d1\u5e03\u5b89\u5168\u8865\u4e01\u96c6\uff0c\u79f0\u4e4b\u4e3aCPU\uff08Critical Patch Updates\uff09\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u7531\u4e8e\u6570\u636e\u5e93\u5728\u4fe1\u606f\u7cfb\u7edf\u7684\u6838\u5fc3\u5730\u4f4d\uff0c\u5bf9\u5176\u6027\u80fd\u548c\u5b89\u5168\u6027\u7684\u8981\u6c42\u975e\u5e38\u9ad8\u3002\u7406\u5e94\u53ca\u65f6\u5b89\u88c5\u6240\u6709\u91cd\u8981\u8865\u4e01\u3002\u53e6\u5916\u4e00\u4e2a\u65b9\u9762\uff0c\u57fa\u4e8e\u540c\u6837\u7684\u7406\u7531\uff0c\u8981\u6c42\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u975e\u5e38\u7a33\u5b9a\uff0c\u5b89\u88c5\u8865\u4e01\u800c\u5bfc\u81f4\u7684\u7cfb\u7edf\u6545\u969c\u548c\u6027\u80fd\u4e0b\u964d\u540c\u6837\u4e0d\u53ef\u63a5\u53d7\u3002DBA\u7ecf\u5e38\u9762\u4e34\u4e00\u4e2a\u975e\u5e38\u56f0\u96be\u7684\u9009\u62e9\uff1a\u5bf9\u4e8e\u591a\u4e2a\u4fee\u590d\u91cd\u8981BUG\u7684\u4e2a\u522b\u8865\u4e01\u662f\u5426\u5b89\u88c5\u3002\u4e0d\u5b89\u88c5\uff0c\u5931\u53bb\u9884\u9632\u6545\u969c\u53d1\u751f\u7684\u673a\u4f1a\uff0c\u4ee5\u540e\u6545\u969c\u53d1\u751f\u65f6\uff0c\u81ea\u5df1\u662f\u65e0\u4f5c\u4e3a\uff1b\u5b89\u88c5\uff0c\u5982\u679c\u8fd9\u4e9b\u8865\u4e01\u4e2d\u5b58\u5728\u7740\u5012\u9000BUG\uff0c\u6216\u8005\u76f8\u4e92\u5f71\u54cd\uff0c\u4ee5\u540e\u53d1\u751f\u7531\u4e8e\u5b89\u88c5\u8865\u4e01\u800c\u9020\u6210\u7684\u6545\u969c\u65f6\uff0c\u81ea\u5df1\u5219\u662f\u65e0\u4e8b\u751f\u975e\uff01\u800c\u7b49\u5f85\u4e0b\u4e00\u4e2aPSR\uff0c\u4e00\u822c\u53c8\u9700\u8981\u4e00\u5e74\u65f6\u95f4\u3002\u56e0\u6b64\uff0c\u51fa\u73b0\u4e86PSU\uff08Patch Set Update\uff09\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; PSU\u89e3\u51b3\u4ee5\u4e0b\u51e0\u4e2a\u95ee\u9898\uff1a\n<\/p>\n<p>\n\t&nbsp; &nbsp; 1. \u51cf\u8f7bPSR\u5468\u671f\u957f\u800c\u5e26\u6765\u7684\u4e0d\u80fd\u53ca\u65f6\u66f4\u65b0\u7684\u5f71\u54cd\uff1b\n<\/p>\n<p>\n\t&nbsp; &nbsp; 2. \u89e3\u51b3\u591a\u4e2a\u4e2a\u522b\u8865\u4e01\u51b2\u7a81\u548c\u76f8\u4e92\u5f71\u54cd\u7684\u95ee\u9898\uff1b\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3. \u51cf\u8f7bDBA\u5b89\u88c5\u8865\u4e01\u7684\u8d1f\u62c5\uff1a\u8865\u4e01\u5b89\u88c5\u6b21\u6570\uff0c\u4e0d\u5b9a\u671f\u68c0\u67e5\u8865\u4e01\u53d1\u5e03\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; PSU\u5177\u6709\u5982\u4e0b\u7279\u70b9\uff1a\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u7b2c\u4e00\u3001PSU\u662fPSR\u7684\u8865\u5145\uff0c\u5728\u4e24\u6b21PSR\u53d1\u5e03\u4e4b\u95f4\u53d1\u5e03\u591a\u4e2aPSU\uff0c\u52a0\u5feb\u66f4\u65b0\u901f\u5ea6\u3002\u6bcf\u4e2aPSU\u4fee\u65395\u4f4d\u7248\u672c\u53f7\u7684\u7b2c5\u4f4d\u3002\u4f8b\u5982\uff0c\u5b89\u88c5\u6b64\u6b21\u53d1\u5e03\u7684 PSU\u540e\uff0c11.1\u7248\u672c&ldquo;\u5347\u7ea7&rdquo;\u4e3a11.1.0.7.1\uff1b10.2\u7248\u672c\u4e3a10.2.0.4.2\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u7b2c\u4e8c\u3001\u6bcf\u4e2aPSU\u4e2d\u5305\u542b25\u81f3100\u4e2a\u91cd\u8981\u8865\u4e01\uff0c\u4f5c\u4e3a\u4e00\u4e2a\u6574\u4f53\u8fdb\u884c\u4e25\u683c\u6d4b\u8bd5\uff0c\u89e3\u51b3\u51b2\u7a81\u95ee\u9898\uff0c\u4fdd\u8bc1\u7cfb\u7edf\u7684\u7a33\u5b9a\u6027\u3002PSU\u4e0d\u4ec5\u5305\u62ec\u5bf9\u529f\u80fd\u3001\u6027\u80fd\u4fee\u590d\u7684\u4e00\u822c\u8865\u4e01\uff0c\u4e5f\u5305\u62ec\u5b89\u5168\u8865\u4e01\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u7b2c\u4e09\u3001PSU\u5b9a\u671f\u53d1\u5e03\uff0c\u8ba1\u5212\u4e00\u5e74\u5206\u5e03\u56db\u6b21\uff0c\u53d1\u5e03\u65e5\u671f\u4e0eCPU\u53d1\u5e03\u65e5\u671f\u76f8\u540c\u3002\u7531\u4e8ePSU\u5305\u62ec\u540c\u671f\u53d1\u5e03\u7684CPU\uff0c\u53ea\u8981\u5b89\u88c5PSU\u5373\u53ef\u3002\uff08\u5bf9\u90e8\u5206\u5e73\u53f0\uff0c\u4ecd\u63d0\u4f9b\u5355\u72ec\u7684CPU\uff0c\u4f9b\u5ba2\u6237\u9009\u62e9\uff09\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u7b2c\u56db\u3001\u5982\u540cPSR\u548cCPU\u4e00\u6837\uff0cPSU\u662f\u7d2f\u79ef\u578b\u7684\uff0c\u5373\u53ea\u8981\u5b89\u88c5\u6700\u65b0\u7684PSU\u5c31\u81ea\u52a8\u5305\u62ec\u4ee5\u524d\u6240\u6709PSU\u7684\u5185\u5bb9\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u7b2c\u4e94\u3001\u4f7f\u7528DBA\u5df2\u7ecf\u719f\u6089\u7684Opatch\u5de5\u5177\u5b89\u88c5\/\u5220\u9664PSU\uff0c\u547d\u4ee4\u4ecd\u662fapply\u548crollback\u3002\u4e00\u4e2aPSU\u53ef\u89c6\u4f5c\u4e00\u4e2a\u4e2a\u522b\u8865\u4e01\uff0c\u5b89\u88c5\u548c\u5220\u9664\u64cd\u4f5c\u90fd\u5f88\u7b80\u4fbf\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u7b2c\u516d\u3001\u73b0\u6709\u7684\u4e2a\u522b\u8865\u4e01\u4e0ePSU\u7684\u5173\u7cfb\u5206\u4e3a\u4e09\u7c7b\uff1a\u5b8c\u5168\u72ec\u7acb\uff1b\u662fPSU\u7684\u4e00\u90e8\u5206\uff1b\u4e0ePSU\u51b2\u7a81\u3002\u7b2c\u4e00\u7c7b\u7684\u4e2a\u522b\u8865\u4e01\u4e0ePSU\u76f8\u4e92\u6ca1\u6709\u5f71\u54cd\uff0c\u53ef\u4ee5\u72ec\u7acb\u7684\u5b89\u88c5\u6216\u5220\u9664\u3002\u5bf9\u4e8e\u7b2c\u4e8c\u7c7b\uff0c\u5728\u5b89\u88c5PSU\u4e4b\u540e\uff0c\u81ea\u7136\u6ca1\u6709\u5fc5\u8981\u5b89\u88c5\u3002\u82e5\u5728PSU\u4e4b\u524d\u5df2\u5b89\u88c5\uff0c\u5219\u5728\u5b89\u88c5PSU\u65f6\u4f1a\u88ab\u81ea\u52a8\u5220\u9664\u3002\u5bf9\u4e8e\u7b2c\u4e09\u7c7b\u4e2a\u522b\u8865\u4e01\uff0c\u5982\u5728PSU\u4e4b\u524d\u5df2\u5b89\u88c5\uff0c\u5fc5\u987b\u5728\u5b89\u88c5PSU\u65f6\u5220\u9664\u3002\u5ba2\u6237\u53ef\u4ee5\u5411Oracle\u516c\u53f8\u6280\u672f\u652f\u6301\u90e8\u95e8\u63d0\u51fa\u7533\u8bf7\uff0c\u7531Oracle\u8d1f\u8d23\u63d0\u4f9b\u4e0ePSU\u4e0d\u51b2\u7a81\u7684\uff0c\u5728PSU\u4e4b\u4e0a\u5b89\u88c5\u7684\u76f8\u5e94\u7684\u65b0\u7684\u7248\u672c\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; PSU\u7684\u9650\u5236\uff1a\u5fc5\u987b\u662f\u5728\u6b63\u5e38\u6280\u672f\u652f\u6301\u8303\u56f4\u4e4b\u5185\u7684\u7248\u672c\uff0811.2\u300111.1\u548c10.2\uff09\uff0c\u5e76\u4e14PSU\u53ea\u80fd\u5728\u6700\u65b0PSR\u4e4b\u4e0a\u5b89\u88c5\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u4e09\uff0eOPatch \u547d\u4ee4\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u5148\u770b\u4e00\u4e2a\u5b98\u7f51\u7684Oracle OPatch \u7684\u8bf4\u660e\uff1a\n<\/p>\n<p>\n\t&nbsp; &nbsp; Oracle Software Patching Using Opatch\n<\/p>\n<p>\n\t&nbsp; &nbsp; http:\/\/download.oracle.com\/docs\/cd\/B19306_01\/em.102\/b16227\/oui8_opatch.htm\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u4ece9.2\u7248\u5f00\u59cb\uff0cOracle\u516c\u53f8\u5b9e\u73b0\u4e86\u4e2a\u522b\u8865\u4e01\u5b89\u88c5\u5de5\u5177opatch. opatch\u4f7f\u7528\u4e00\u4e2a\u79f0\u4e3ainventory\u7684\u7cfb\u7edf\u6570\u636e\u7ed3\u6784\uff08\u4e25\u683c\u8bf4\u662f\u4e0eoui\u5171\u4eabinventory\uff09\uff0c\u96c6\u4e2d\u7ba1\u7406\u6240\u6709\u5df2\u5b89\u88c5\u7684\u4e2a\u522b\u8865\u4e01\uff1b\u4e2a\u522b\u8865\u4e01\u7684\u5b89\u88c5\u548c\u5378\u8f7d\u90fd\u4f7f\u7528opatch\u547d\u4ee4\u5b8c\u6210\uff0c\u51b2\u7a81\u68c0\u6d4b\u4e5f\u7531opatch\u5728\u5b89\u88c5\u65f6\u81ea\u52a8\u5b8c\u6210\uff1b\u63d0\u4f9b\u5217\u8868\u547d\u4ee4\u53ef\u4ee5\u5f88\u65b9\u4fbf\u5f97\u5230\u5df2\u5b89\u88c5\u4e2a\u522b\u8865\u4e01\u7684\u4fe1\u606f\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; 10g\uff0810.1\u548c10.2\uff09\u7248\u672c\u4e2d\uff0copatch\u4f5c\u4e3a\u4e00\u4e2a\u6807\u51c6\u5de5\u5177\uff0c\u5728\u5b89\u88c5\u65f6\u81ea\u52a8\u5b89\u88c5\u3002\uff08\u5b89\u88c5\u5728$ORACLE_HOME\/OPatch\u4e0b\u3002\uff09\u800c\u5bf9\u4e8e9.2\u7248\uff0c\u9700\u8981\u4ecemetalink\u4e0b\u8f7dopatch.\u65e0\u8bba\u662f\u54ea\u4e00\u4e2a\u7248\u672c\uff0c\u7cfb\u7edf\u4e2d\u662f\u5426\u5df2\u7ecf\u5b89\u88c5opatch\uff0c\u5728\u4f7f\u7528\u4e4b\u524d\uff0c\u5e94\u4ecemetalink\u4e0b\u8f7d\u6700\u65b0\u7248\u672c\u7684opatch.\u5f88\u9057\u61be\uff0c\u7531\u4e8e\u7cfb\u7edf\u5b9e\u73b0\u7684\u95ee\u9898\uff0c10.2\u4f7f\u7528\u7684opatch\u4e0e\u4e4b\u524d\u7248\u672c\uff0810.1\u548c9.2\uff09\u4f7f\u7528\u7684opatch\u4e0d\u517c\u5bb9\uff0c\u4e0d\u80fd\u6df7\u7528\uff0c\u8fd9\u4e00\u70b9\u5fc5\u987b\u6ce8\u610f\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; opatch\u662f\u4f7f\u7528perl\u7f16\u5199\u7684\u811a\u672c\u7a0b\u5e8f\uff08\u5176\u4e2d\u4e5f\u4f7f\u7528JAVA API\uff09\u3002\u4f7f\u7528\u7684perl\u7248\u672c\u662f5.6\u7248\uff0c\u867d\u7136\u57285.6\u4e4b\u524d\u7684\u7248\u672c\u4e2d\u4e5f\u53ef\u8fd0\u884c\uff0c\u4f46\u5e94\u5c3d\u53ef\u80fd\u5b89\u88c55.6\u6216\u4ee5\u4e0a\u7684\u7248\u672c\u7684perl. \u5bf9\u4e8eDBA\u6765\u8bf4\u4e00\u4e2a\u597d\u6d88\u606f\u662f\uff0c\u5982\u679c\u5b89\u88c59.2\u7248\u8f6f\u4ef6\u65f6\u4fdd\u7559\u4e86HTTP\u670d\u52a1\u5668\uff0c\u5219\u5728$ORACLE_HOME\/Apache\u4e0b\u4f1a\u81ea\u52a8\u5b89\u88c5perl.\uff0810g\u4f1a\u81ea\u52a8\u5b89\u88c5\u914d\u7f6eperl\u548copatch.\uff09\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.1 opatch\u547d\u4ee4\u5b58\u653e\u4f4d\u7f6e\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u8be5\u547d\u4ee4\u7684\u5b58\u653e\u4f4d\u7f6e\u5728$ORACLE_HOME\u4e0b\u7684OPatch\u76ee\u5f55\u4e0b\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ pwd\n<\/p>\n<p>\n\t&nbsp; &nbsp; \/u01\/oracle\/oracle\/product\/10.2.0\/db_1\/OPatch\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ ls\n<\/p>\n<p>\n\t&nbsp; &nbsp; docs&nbsp;emdpatch.pl&nbsp;jlib&nbsp;opatch&nbsp;opatch.ini&nbsp;opatch.pl\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ ls -lrt\n<\/p>\n<p>\n\t&nbsp; &nbsp; total 44\n<\/p>\n<p>\n\t&nbsp; &nbsp; -rw-r&#8211;r&#8211; 1 oracle oinstall 18107 Apr 18&nbsp;2005 emdpatch.pl\n<\/p>\n<p>\n\t&nbsp; &nbsp; -rw-r&#8211;r&#8211; 1 oracle oinstall&nbsp;2193 Jun&nbsp;1&nbsp;2005 opatch.pl\n<\/p>\n<p>\n\t&nbsp; &nbsp; -rwxr-xr-x 1 oracle oinstall&nbsp;5672 Jun&nbsp;1&nbsp;2005 opatch\n<\/p>\n<p>\n\t&nbsp; &nbsp; drwxr-x&#8212; 2 oracle oinstall&nbsp;4096 Apr 21 13:24 jlib\n<\/p>\n<p>\n\t&nbsp; &nbsp; drwxr-x&#8212; 2 oracle oinstall&nbsp;4096 Apr 21 13:24 docs\n<\/p>\n<p>\n\t&nbsp; &nbsp; -rw-r&#8211;r&#8211; 1 oracle oinstall&nbsp;&nbsp;49 Apr 21 13:24 opatch.ini\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.2 \u4f7f\u7528&ldquo;-help&rdquo;\u53c2\u6570\u53ef\u4ee5\u83b7\u5f97opatch\u547d\u4ee4\u7684\u5e2e\u52a9\u4fe1\u606f\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ .\/opatch &#8211;help\n<\/p>\n<p>\n\t&nbsp; &nbsp; Invoking OPatch 10.2.0.1.0\n<\/p>\n<p>\n\t&nbsp; &nbsp; Oracle interim Patch Installer version 10.2.0.1.0\n<\/p>\n<p>\n\t&nbsp; &nbsp; Copyright (c) 2005, Oracle Corporation.&nbsp;All rights reserved..\n<\/p>\n<p>\n\t&nbsp; &nbsp; Oracle Home&nbsp;&nbsp;&nbsp;: \/u01\/oracle\/oracle\/product\/10.2.0\/db_1\n<\/p>\n<p>\n\t&nbsp; &nbsp; Central Inventory : \/u01\/oracle\/oraInventory\n<\/p>\n<p>\n\t&nbsp; &nbsp; from&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: \/u01\/oracle\/oracle\/product\/10.2.0\/db_1\/oraInst.loc\n<\/p>\n<p>\n\t&nbsp; &nbsp; OPatch version&nbsp;&nbsp;: 10.2.0.1.0\n<\/p>\n<p>\n\t&nbsp; &nbsp; OUI version&nbsp;&nbsp;&nbsp;: 10.2.0.1.0\n<\/p>\n<p>\n\t&nbsp; &nbsp; OUI location&nbsp;&nbsp;&nbsp;: \/u01\/oracle\/oracle\/product\/10.2.0\/db_1\/\/oui\n<\/p>\n<p>\n\t&nbsp; &nbsp; Log file location : \/u01\/oracle\/oracle\/product\/10.2.0\/db_1\/cfgtoollogs\/opatch\/opatch-2010_Aug_09_03-05-40-CST_Mon.log\n<\/p>\n<p>\n\t&nbsp; &nbsp; Usage: opatch [ -help ] [ -r[eport] ] [ command ]\n<\/p>\n<p>\n\t&nbsp; &nbsp; command := apply\n<\/p>\n<p>\n\t&nbsp; &nbsp; lsinventory\n<\/p>\n<p>\n\t&nbsp; &nbsp; query\n<\/p>\n<p>\n\t&nbsp; &nbsp; rollback\n<\/p>\n<p>\n\t&nbsp; &nbsp; version\n<\/p>\n<p>\n\t&nbsp; &nbsp; &lt;global_arguments&gt;:= -help&nbsp;&nbsp;&nbsp;Displays the help message for the command.\n<\/p>\n<p>\n\t&nbsp; &nbsp; -report&nbsp;&nbsp;Print the actions without executing (deprecated).\n<\/p>\n<p>\n\t&nbsp; &nbsp; example:\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch apply -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch lsinventory -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch rollback -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; OPatch succeeded.\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u8fd9\u4e2a\u662f10.2.0.1\u7248\u672c\u7684opatch. \u572810.2.0.4 \u7248\u672c\u7684opatch\u547d\u4ee4\u4e0e\u4e4b\u524d\u7684\u53c8\u4e0d\u540c\uff0c\u5b83\u6709\u6dfb\u52a0\u4e86\u51e0\u4e2a\u547d\u4ee4\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ .\/opatch &#8211;help\n<\/p>\n<p>\n\t&nbsp; &nbsp; Invoking OPatch 11.1.0.6.6\n<\/p>\n<p>\n\t&nbsp; &nbsp; Oracle Interim Patch Installer version 11.1.0.6.6\n<\/p>\n<p>\n\t&nbsp; &nbsp; Copyright (c) 2009, Oracle Corporation.&nbsp;All rights reserved.\n<\/p>\n<p>\n\t&nbsp; &nbsp; Usage: opatch [ -help ] [ -r[eport] ] [ command ]\n<\/p>\n<p>\n\t&nbsp; &nbsp; command := apply\n<\/p>\n<p>\n\t&nbsp; &nbsp; lsinventory\n<\/p>\n<p>\n\t&nbsp; &nbsp; napply\n<\/p>\n<p>\n\t&nbsp; &nbsp; nrollback\n<\/p>\n<p>\n\t&nbsp; &nbsp; rollback\n<\/p>\n<p>\n\t&nbsp; &nbsp; query\n<\/p>\n<p>\n\t&nbsp; &nbsp; version\n<\/p>\n<p>\n\t&nbsp; &nbsp; prereq\n<\/p>\n<p>\n\t&nbsp; &nbsp; util\n<\/p>\n<p>\n\t&nbsp; &nbsp; &lt;global_arguments&gt;:= -help&nbsp;&nbsp;&nbsp;Displays the help message for the command.\n<\/p>\n<p>\n\t&nbsp; &nbsp; -report&nbsp;&nbsp;Print the actions without executing.\n<\/p>\n<p>\n\t&nbsp; &nbsp; example:\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch apply -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch lsinventory -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch napply -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch nrollback -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch rollback -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch prereq -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#39;opatch util -help&#39;\n<\/p>\n<p>\n\t&nbsp; &nbsp; OPatch succeeded.\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u5b98\u7f51\u4e0a\u5bf9\u547d\u4ee4\u7684\u4e00\u4e9b\u89e3\u91ca\uff1a\n<\/p>\n<p>\n\t&nbsp; &nbsp; apply\n<\/p>\n<p>\n\t&nbsp; &nbsp; Installs an interim patch. Refer to &quot;apply Command&quot; for more information.\n<\/p>\n<p>\n\t&nbsp; &nbsp; napply\n<\/p>\n<p>\n\t&nbsp; &nbsp; Installs n number of patches (hence napply). Refer to &quot;napply Command&quot; for more information.\n<\/p>\n<p>\n\t&nbsp; &nbsp; auto\n<\/p>\n<p>\n\t&nbsp; &nbsp; Applies Oracle Clusterware patches. Refer to &quot;auto Command&quot; for more information.\n<\/p>\n<p>\n\t&nbsp; &nbsp; lsinventory\n<\/p>\n<p>\n\t&nbsp; &nbsp; Lists what is currently installed on the system. Refer to &quot;lsinventory Command&quot; for more information.\n<\/p>\n<p>\n\t&nbsp; &nbsp; query\n<\/p>\n<p>\n\t&nbsp; &nbsp; Queries a given patch for specific details. Refer to &quot;query Command&quot; for more information.\n<\/p>\n<p>\n\t&nbsp; &nbsp; rollback\n<\/p>\n<p>\n\t&nbsp; &nbsp; Removes an interim patch. Refer to &quot;rollback Command&quot; for more information.\n<\/p>\n<p>\n\t&nbsp; &nbsp; nrollback\n<\/p>\n<p>\n\t&nbsp; &nbsp; Removes n number of patches (hence nrollback). Refer to &quot;nrollback Command&quot; for more information.\n<\/p>\n<p>\n\t&nbsp; &nbsp; version\n<\/p>\n<p>\n\t&nbsp; &nbsp; Prints the current version of the patch tool. Refer to &quot;version Command&quot; for more information.\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u5728$ORACLE_HOME\/OPatch\/docs\u76ee\u5f55\u4e0b\uff0c\u7528\u6307\u5357\u6587\u4ef6\uff08Users_Guide.txt\uff09\uff0c\u5176\u4e2d\u6709\u8be6\u7ec6\u7684\u547d\u4ee4\u683c\u5f0f\u548c\u4f7f\u7528\u793a\u4f8b\uff0c\u53ef\u4ee5\u53c2\u8003\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; Opatch\u6267\u884c\u64cd\u4f5c\u65f6\uff0c\u9664\u5728\u5c4f\u5e55\u8f93\u51fa\u7ed3\u679c\u5916\uff0c\u8fd8\u751f\u6210\u65e5\u5fd7\u6587\u4ef6\u3002\u65e5\u5fd7\u6587\u4ef6\u7684\u8def\u5f84\u548c\u6587\u4ef6\u540d\u683c\u5f0f\u5982\u4e0b\uff1a\n<\/p>\n<p>\n\t&nbsp; &nbsp; $ORACLE_HOME\/.patch_storage\/&lt; patch_id &gt;\/&lt; action &gt;-&lt; patch_id &gt;_&lt; mm-dd-yyyy_hh-mi-ss&gt;.log\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u5176\u4e2d&ldquo;patch_id&rdquo;\u662fOracle\u6280\u672f\u652f\u6301\u90e8\u95e8\u4e3a\u4e2a\u522b\u8865\u4e01\u5206\u914d\u7684\u7f16\u53f7\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.3 opatch\u5b89\u88c5\u4e2a\u522b\u8865\u4e01\u793a\u4f8b\uff1a\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u4ee5Patch 5689937 \u4e3a\u4f8b\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.3.1 patch\u4e0b\u8f7d\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u4ecemetalink\u4e0b\u8f7d\u8865\u4e01\u7684\u538b\u7f29\u6587\u4ef6p5689937_10201_LINUX.zip.\u5c06\u6b64\u6587\u4ef6\u89e3\u538b\u7f29\u81f3\u67d0\u4e00\u76ee\u5f55\u4e2d\u3002\u89e3\u538b\u7f29\u540e\uff0c\u8fd9\u4e00\u8865\u4e01\u7684\u6240\u6709\u6587\u4ef6\u90fd\u5728\u5b50\u76ee\u5f555689937\u4e0b\uff0c\u76ee\u5f55\u540d\u5c31\u662f\u4e2a\u522b\u8865\u4e01\u7684\u8865\u4e01\u53f7\uff0copatch\u4f9d\u636e\u76ee\u5f55\u540d\u83b7\u5f97\u4fe1\u606f\uff0c\u6240\u4ee5\u4e00\u5b9a\u4e0d\u8981\u91cd\u547d\u540d\u5b50\u76ee\u5f55\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.3.2 \u5b89\u88c5patch\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u8fdb\u5165patch\u6587\u4ef65689937 \u76ee\u5f55\uff0c\u5728patch\u7684\u76ee\u5f55\u4e0b\u9762\u6709\u4e00\u4e2areadme\u7684\u5b89\u88c5\u6587\u6863\uff0c\u91cc\u9762\u6709\u5b89\u88c5\u6b65\u9aa4\u548c\u4e00\u4e9b\u95ee\u9898\u7684\u5904\u7406\u65b9\u6cd5\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.3.2.1 \u5173\u95ed\u6570\u636e\u5e93\u548c\u76d1\u542c\n<\/p>\n<p>\n\t&nbsp; &nbsp; Shut down all instances and listeners associated with the Oracle home that you are updating.\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.3.2.2. \u8fdb\u5165patch\u76ee\u5f55\uff0c\u8fd0\u884copatch apply\u547d\u4ee4\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ cd p5689937_10201_LINUX\/\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ ls\n<\/p>\n<p>\n\t&nbsp; &nbsp; 5689937&nbsp;patchmd.xml&nbsp;README.html\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ cd 5689937\/\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ ls\n<\/p>\n<p>\n\t&nbsp; &nbsp; custom&nbsp;etc&nbsp;files&nbsp;README.txt\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ pwd\n<\/p>\n<p>\n\t&nbsp; &nbsp; \/mnt\/p5689937_10201_LINUX\/5689937\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ export PATH=$PATH:\/usr\/ccs\/bin\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ $ORACLE_HOME\/OPatch\/opatch apply\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.3.2.3 \u542f\u52a8\u5b9e\u4f8b\uff0c\u8fd0\u884c\u76f8\u5173\u811a\u672c\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ cd $ORACLE_HOME\/cpu\/CPUJan2007\/&nbsp;&#8212; \u8981\u8fdb\u5165\u8fd9\u4e2a\u76ee\u5f55\u624d\u80fd\u627e\u5230\u811a\u672c\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ sqlplus \/nolog\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL*Plus: Release 10.2.0.1.0 &#8211; Production on Mon Aug 9 04:48:19 2010\n<\/p>\n<p>\n\t&nbsp; &nbsp; Copyright (c) 1982, 2005, Oracle.&nbsp;All rights reserved.\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL&gt; conn \/ as sysdba\n<\/p>\n<p>\n\t&nbsp; &nbsp; Connected to an idle instance.\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL&gt; startup\n<\/p>\n<p>\n\t&nbsp; &nbsp; ORACLE instance started.\n<\/p>\n<p>\n\t&nbsp; &nbsp; Total System Global Area&nbsp;281018368 bytes\n<\/p>\n<p>\n\t&nbsp; &nbsp; Fixed Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1218968 bytes\n<\/p>\n<p>\n\t&nbsp; &nbsp; Variable Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;83887720 bytes\n<\/p>\n<p>\n\t&nbsp; &nbsp; Database Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;192937984 bytes\n<\/p>\n<p>\n\t&nbsp; &nbsp; Redo Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2973696 bytes\n<\/p>\n<p>\n\t&nbsp; &nbsp; Database mounted.\n<\/p>\n<p>\n\t&nbsp; &nbsp; Database opened.\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL&gt; @catcpu.sql\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u5982\u679ccatcpu.sql \u811a\u672c\u62a5\u4efb\u4f55\u65e0\u6548\u5bf9\u8c61\uff0c\u6267\u884c\u5982\u4e0b\u811a\u672c\uff1a\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL&gt; @?\/rdbms\/admin\/utlrp.sql\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u53ef\u4ee5\u7528\u5982\u4e0bSQL \u68c0\u67e5\u65e0\u6548\u5bf9\u8c61\uff1a\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL&gt; SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS= &#39;INVALID&#39;;\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.3.3 \u7528inventory \u547d\u4ee4\u67e5\u770b\u5df2\u7ecf\u5b89\u88c5\u7684patch\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$&nbsp;$ORACLE_HOME\/OPatch\/opatch lsinventory\n<\/p>\n<p>\n\t&nbsp; &nbsp; Invoking OPatch 10.2.0.1.0\n<\/p>\n<p>\n\t&nbsp; &nbsp; Oracle interim Patch Installer version 10.2.0.1.0\n<\/p>\n<p>\n\t&nbsp; &nbsp; Copyright (c) 2005, Oracle Corporation.&nbsp;All rights reserved..\n<\/p>\n<p>\n\t&nbsp; &nbsp; Oracle Home&nbsp;&nbsp;&nbsp;: \/u01\/oracle\/oracle\/product\/10.2.0\/db_1\n<\/p>\n<p>\n\t&nbsp; &nbsp; Central Inventory : \/u01\/oracle\/oraInventory\n<\/p>\n<p>\n\t&nbsp; &nbsp; from&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: \/u01\/oracle\/oracle\/product\/10.2.0\/db_1\/oraInst.loc\n<\/p>\n<p>\n\t&nbsp; &nbsp; OPatch version&nbsp;&nbsp;: 10.2.0.1.0\n<\/p>\n<p>\n\t&nbsp; &nbsp; OUI version&nbsp;&nbsp;&nbsp;: 10.2.0.1.0\n<\/p>\n<p>\n\t&nbsp; &nbsp; OUI location&nbsp;&nbsp;&nbsp;: \/u01\/oracle\/oracle\/product\/10.2.0\/db_1\/\/oui\n<\/p>\n<p>\n\t&nbsp; &nbsp; Log file location : \/u01\/oracle\/oracle\/product\/10.2.0\/db_1\/cfgtoollogs\/opatch\/opatch-2010_Aug_09_04-55-55-CST_Mon.log\n<\/p>\n<p>\n\t&nbsp; &nbsp; Lsinventory Output file location : \/u01\/oracle\/oracle\/product\/10.2.0\/db_1\/cfgtoollogs\/opatch\/lsinv\/lsinventory-2010_Aug_09_04-55-55-CST_Mon.txt\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;\n<\/p>\n<p>\n\t&nbsp; &nbsp; Installed Top-level Products (1):\n<\/p>\n<p>\n\t&nbsp; &nbsp; Oracle Database 10g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10.2.0.1.0\n<\/p>\n<p>\n\t&nbsp; &nbsp; There are 1 products installed in this Oracle Home.\n<\/p>\n<p>\n\t&nbsp; &nbsp; Interim patches (1) :\n<\/p>\n<p>\n\t&nbsp; &nbsp; Patch&nbsp;5689937&nbsp;&nbsp;&nbsp;: applied on Mon Aug 09 04:43:27 CST 2010\n<\/p>\n<p>\n\t&nbsp; &nbsp; Created on 8 Jan 2007, 11:48:31 hrs US\/Eastern\n<\/p>\n<p>\n\t&nbsp; &nbsp; Bugs fixed:\n<\/p>\n<p>\n\t&nbsp; &nbsp; 4671216, 4925103, 4604970, 4616376, 5689937, 4288876, 5225798, 5694720\n<\/p>\n<p>\n\t&nbsp; &nbsp; 4754888, 4750469, 4369235, 4751931, 4966716, 5049080, 5242648, 4348230\n<\/p>\n<p>\n\t&nbsp; &nbsp; 5490846, 4630549, 5490936, 5049088\n<\/p>\n<p>\n\t&nbsp; &nbsp; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;\n<\/p>\n<p>\n\t&nbsp; &nbsp; OPatch succeeded.\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u6216\u8005\u7528$ORACLE_HOME\/OPatch\/opatch lsinventory &ndash;detail \u547d\u4ee4\u67e5\u770b\u8be6\u7ec6\u3002\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.4 \u5378\u8f7d opatch\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.4.1 \u5173\u95ed\u5b9e\u4f8b\u548c\u76d1\u542c\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL&gt; shutdown immediate\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.4.2 \u6267\u884copatch\u547d\u4ee4\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ cd $ORACLE_HOME\/OPatch\/\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ .\/opatch rollback -id 5689937\n<\/p>\n<p>\n\t&nbsp; &nbsp; 3.4.3&nbsp;\u542f\u52a8\u5b9e\u4f8b\uff0c\u6267\u884ccatcpu_rollback.sql\u811a\u672c\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ cd $ORACLE_HOME\/cpu\/CPUJan2007\/\n<\/p>\n<p>\n\t&nbsp; &nbsp; -bash-3.2$ sqlplus \/nolog\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL*Plus: Release 10.2.0.1.0 &#8211; Production on Mon Aug 9 05:04:19 2010\n<\/p>\n<p>\n\t&nbsp; &nbsp; Copyright (c) 1982, 2005, Oracle.&nbsp;All rights reserved.\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL&gt; conn \/ as sysdba\n<\/p>\n<p>\n\t&nbsp; &nbsp; Connected to an idle instance.\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL&gt; startup\n<\/p>\n<p>\n\t&nbsp; &nbsp; ORACLE instance started.\n<\/p>\n<p>\n\t&nbsp; &nbsp; Total System Global Area&nbsp;281018368 bytes\n<\/p>\n<p>\n\t&nbsp; &nbsp; Fixed Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1218968 bytes\n<\/p>\n<p>\n\t&nbsp; &nbsp; Variable Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;109053544 bytes\n<\/p>\n<p>\n\t&nbsp; &nbsp; Database Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;167772160 bytes\n<\/p>\n<p>\n\t&nbsp; &nbsp; Redo Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2973696 bytes\n<\/p>\n<p>\n\t&nbsp; &nbsp; Database mounted.\n<\/p>\n<p>\n\t&nbsp; &nbsp; Database opened.\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL&gt; @catcpu_rollback.sql&nbsp;&#8212; \u8fd9\u4e2a\u811a\u672c\u5728patch\u7684\u5b89\u88c5\u76ee\u5f55\u91cc\u4e5f\u6709\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u5982\u679c\u5728\u8fd0\u884c\u4e2d\u51fa\u73b0\u65e0\u6548\u5bf9\u8c61\uff0c\u8fd0\u884c\u5982\u4e0b\u811a\u672c\uff1a\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL&gt; @?\/rdbms\/admin\/utlrp.sql\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u68c0\u67e5\u65e0\u6548\u5bf9\u8c61\uff1a\n<\/p>\n<p>\n\t&nbsp; &nbsp; SQL&gt; SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = &#39;INVALID&#39;;\n<\/p>\n<p>\n\t&nbsp; &nbsp; \u5173\u4e8ePatch\u7684\u8bf4\u660e\u5c31\u5230\u6b64\u3002 \u5728\u540e\u8bf4\u660e\u4e00\u70b9\u3002 \u6709\u65f6\u6211\u4eec\u7684\u751f\u4ea7\u5e93\u9047\u5230\u4e00\u4e2a\u95ee\u9898\uff0c\u4f46\u662f\u53c8\u4e0d\u80fd\u5341\u5206\u786e\u5b9a\u662f\u5426\u662f\u67d0\u4e2abug\u7684\u65f6\u5019\uff0c\u53ef\u4ee5\u5148\u8003\u8651\u6253patch\u770b\u4e00\u4e0b\uff0c\u5982\u679c\u89e3\u51b3\u4e86\u66f4\u597d\uff0c\u5982\u679c\u4e0d\u80fd\u89e3\u51b3\uff0c\u628apatch\u5220\u6389\u5373\u53ef\u3002 \u8fd9\u6837\u53ef\u4ee5\u628a\u95ee\u9898\u63a7\u5236\u5728\u53ef\u63a7\u7684\u8303\u56f4\u5185\uff0c\u907f\u514d\u628a\u95ee\u9898\u6269\u5927\u5316\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\uff0e CPU\uff08Critical Patch Update\uff09 &nbsp; &nbsp; \u4e00\u4e2aCPU\u5185\u5305\u542b\u4e86\u5bf9\u591a &hellip; <a href=\"https:\/\/www.llku.com\/?p=1454\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">Oracle\u8865\u4e01\u53caopatch\u5de5\u5177\u4ecb\u7ecd<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[31],"tags":[232],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1454"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1454"}],"version-history":[{"count":1,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1454\/revisions"}],"predecessor-version":[{"id":1455,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1454\/revisions\/1455"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}