{"id":317,"date":"2013-01-12T16:55:56","date_gmt":"2013-01-12T08:55:56","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=317"},"modified":"2013-01-12T17:58:19","modified_gmt":"2013-01-12T09:58:19","slug":"scripts%e6%9f%a5%e7%9c%8b%e6%95%b0%e6%8d%ae%e5%ba%93%e7%89%88%e6%9c%ac%e5%8f%8a%e8%a1%a5%e4%b8%81%e6%83%85%e5%86%b5","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=317","title":{"rendered":"scripts:\u67e5\u770b\u6570\u636e\u5e93\u7248\u672c\u53ca\u8865\u4e01\u60c5\u51b5"},"content":{"rendered":"<p>\u67e5\u770b\u6570\u636e\u5e93\u7248\u672c\u53ca\u8865\u4e01\u60c5\u51b5<br \/>\n<coolcode lang=\"shell\" linenum=\"off\"><br \/>\n--\u6570\u636e\u5e9310.2\u4ee5\u540e\u53ef\u7528<br \/>\nSET lines 100 numwidth 12 pages 100<br \/>\nCOL action_time FOR a30<br \/>\nCOL action FOR a12<br \/>\nCOL version LIKE action<br \/>\nCOL comments FOR a30<br \/>\nSELECT action_time, action, version, id, comments FROM dba_registry_history ORDER BY action_time; <\/p>\n<p>--\u6570\u636e\u5e93\u901a\u7528<br \/>\nSET lines 100 numwidth 12 pages 100<br \/>\nCOL action_time FOR a30<br \/>\nCOL action FOR a12<br \/>\nCOL version LIKE action<br \/>\nCOL comments FOR a30<br \/>\nSELECT action_time, action, version, id, comments FROM registry$history ORDER BY action_time;<\/p>\n<p>--\u6570\u636e\u5e9310.2.0.4\u4ee5\u540e\u624d\u6709psu<br \/>\nhbdb2:oracle:\/oracle>$ORACLE_HOME\/OPatch\/opatch lsinventory -bugs_fixed | egrep -i 'PSU|DATABASE PATCH SET UPDATE'<br \/>\n8576156    9352164   Wed May 26 13:56:10 GMT+08:00 2010DATABASE PSU 10.2.0.4.1 (INCLUDES CPUJUL2009)<br \/>\n8833280    9352164   Wed May 26 13:56:10 GMT+08:00 2010DATABASE PSU 10.2.0.4.2 (INCLUDES CPUOCT2009)<br \/>\n9119284    9352164   Wed May 26 13:56:10 GMT+08:00 2010DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJAN2010)<br \/>\n9352164    9352164   Wed May 26 13:56:10 GMT+08:00 2010DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)<\/p>\n<p>--10g<br \/>\nselect substr(action_time,1,30) action_time,<br \/>\nsubstr(id,1,10) id,<br \/>\nsubstr(action,1,10) action,<br \/>\nsubstr(version,1,8) version,<br \/>\nsubstr(BUNDLE_SERIES,1,6) bundle,<br \/>\nsubstr(comments,1,20) comments<br \/>\nfrom registry$history;<\/p>\n<p>--9i<br \/>\nselect substr(action_time,1,30) action_time,<br \/>\nsubstr(id,1,10) id,<br \/>\nsubstr(action,1,10) action,<br \/>\nsubstr(version,1,8) version,<br \/>\nsubstr(comments,1,20) comments from registry$history;<br \/>\n<\/coolcode><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u67e5\u770b\u6570\u636e\u5e93\u7248\u672c\u53ca\u8865\u4e01\u60c5\u51b5 &#8211;\u6570\u636e\u5e9310.2\u4ee5\u540e\u53ef\u7528 SET lines 100 numwidth 12 pa [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/317"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=317"}],"version-history":[{"count":3,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/317\/revisions"}],"predecessor-version":[{"id":361,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/317\/revisions\/361"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=317"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}