{"id":733,"date":"2019-05-22T08:43:54","date_gmt":"2019-05-22T00:43:54","guid":{"rendered":"http:\/\/www.hefeiyu.com\/?p=733"},"modified":"2019-06-28T08:30:47","modified_gmt":"2019-06-28T00:30:47","slug":"tiptop-gp5-0%e7%89%88%e6%9c%ac%e5%89%8d-%e6%95%b0%e6%8d%ae%e5%ba%93%e6%ad%bb%e9%94%81%e8%a7%a3%e9%94%81","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=733","title":{"rendered":"TIPTOP GP5.0\u7248\u672c\u524d \u6570\u636e\u5e93\u6b7b\u9501\u89e3\u9501"},"content":{"rendered":"

\u6570\u636e\u5e93\u6b7b\u9501:
\n\u5728TOP-GUI\u4e2d\u8f93\u5165sqlplus ‘\/as sysdba’ \u6216\u8005 sqlplus ‘system\/manager@topprod as sysdba’
\n[\u5982\u679c\u767b\u9646\u4e0d\u4e86\u53ef\u8bd5\u8bd5\uff1asqlplus sys\/change_on_install_test as sysdba\uff08sys\/\u540e\u9762\u662f\u5bc6\u7801\uff09]
\n\u5728SQL>\u63d0\u793a\u547d\u4ee4\u4e0b\u8f93\u5165SQL> @q_locktable<\/p>\n

<\/p>\n

\u5982\u4f55\u89e3\u9501\uff1f<\/p>\n

1\u3001\u7ec8\u6b62\u64cd\u4f5c\u7cfb\u7edf\u8fdb\u884c\u4ece\u800c\u8fbe\u5230\u89e3\u9501\u76ee\u7684\uff0c\u5982\u4e0a\u201dProc ID\u201d\u7684\u503c\u4e3a18040\u662f\u64cd\u4f5c\u7cfb\u7edf\u7684\u8fdb\u7a0b\uff0c\u6b64\u8fdb\u7a0b\u8fd0\u884c\u9501\u4f4f\u4e86\u8868\u3002\u7ec8\u6b62\u6b64\u8fdb\u7a0b\u5c31\u76f8\u5e94\u91ca\u653e\u88ab\u9501\u7684\u8868\u3002\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n

<topprod:\/u1\/topprod\/tiptop>kill 18040<\/p>\n

2\u3001\u901a\u8fc7Oracle\u672c\u8eab\u63d0\u4f9b\u7684\u547d\u4ee4\u6b64\u9501\u4f4f\u8868\u7684\u4f1a\u8bdd\u4ee5\u8fbe\u5230\u89e3\u9501\u76ee\u7684\uff0c\u8bb0\u4e0bSID\u548cSERIAL#\uff0c\u7528\u4e0b\u547d\u4ee4kill\u9501:<\/p>\n

SQL> alter system kill session ‘sid,serial#’;<\/p>\n

\u4f8b\u5982: $ sqlplus \/nolog<\/p>\n

SQL> conn \/ as sysdba<\/p>\n

SQL>alter system kill session \u20189,725\u2019;<\/p>\n

\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u8d6b\u975e\u57df<\/a> » TIPTOP GP5.0\u7248\u672c\u524d \u6570\u636e\u5e93\u6b7b\u9501\u89e3\u9501<\/a><\/p>","protected":false},"excerpt":{"rendered":"

\u6570\u636e\u5e93\u6b7b\u9501: \u5728TOP-GUI\u4e2d\u8f93\u5165sqlplus ‘\/as sysdba’ \u6216\u8005 sqlplus ‘system\/manager@topprod as sysdba’ [\u5982\u679c\u767b\u9646\u4e0d\u4e86\u53ef\u8bd5\u8bd5\uff1asqlpl […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[237,238,239],"class_list":["post-733","post","type-post","status-publish","format-standard","hentry","category-unix","tag-sqlplus","tag-sysdba","tag-system"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=733"}],"version-history":[{"count":3,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/733\/revisions"}],"predecessor-version":[{"id":1436,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/733\/revisions\/1436"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}