{"id":649,"date":"2016-03-23T15:58:33","date_gmt":"2016-03-23T07:58:33","guid":{"rendered":"http:\/\/www.llku.com\/?p=649"},"modified":"2016-04-20T21:37:13","modified_gmt":"2016-04-20T13:37:13","slug":"ebs-web%e9%a1%b5%e9%9d%a2500-error%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=649","title":{"rendered":"EBS web\u9875\u9762Internal Server Error\u9519\u8bef"},"content":{"rendered":"

\n\t    \u4eca\u5929\u8d22\u52a1\u4eba\u5458\u5728\u7cfb\u7edf\u5185\u505a\u6279\u91cf\u4ed8\u6b3e\u7684\u65f6\u5019\uff0c\u70b9\u51fb\u6700\u7ec8\u5b8c\u6210\u5e94\u7528\u4ed8\u6b3e\u7684\u65f6\u5019\uff0c\u7cfb\u7edf\u4e00\u76f4\u5904\u4e8e\u8fd0\u884c\u72b6\u6001\uff0c\u4f46\u5374\u4e00\u76f4\u65e0\u6cd5\u5b8c\u6210\u4ed8\u6b3e\uff0c\u8fc7\u51e0\u5206\u949f\u540e\uff0c\u76f4\u63a5\u8df3\u8f6c\u81f3\u5982\u4e0b\u56fe\u6240\u793a\u7684\u754c\u9762\uff1a\n<\/p>\n

\n\t\"error\"<\/a>\n<\/p>\n

\n\t\u8fd9\u662f\u7b2c\u4e09\u6b21\u51fa\u73b0\u8fd9\u6837\u7c7b\u4f3c\u7684\u95ee\u9898\uff0c\u4ece\u9047\u5230\u7684\u60c5\u51b5\u4e3b\u8981\u53ef\u80fd\u6709\u5982\u4e0b\u4e24\u70b9\u539f\u56e0\uff1a\n<\/p>\n

\n\t1. \u8868\u7a7a\u95f4\u4e0d\u8db3\uff0c\u7279\u522b\u662f\u4e34\u65f6\u8868\u7a7a\u95f4\u4e0d\u8db3\uff08\u7b2c\u4e00\u6b21\u51fa\u73b0\u662f\u56e0\u4e3a\u6b64\u95ee\u9898\u9020\u6210\uff09\n<\/p>\n

\n\t   \u89e3\u51b3\u65b9\u6cd5\uff1a\u589e\u52a0\u8868\u7a7a\u95f4\uff0c\u901a\u8fc7\u811a\u672c\u67e5\u8be2\u51fa\u9700\u8981\u589e\u52a0\u7684\u8868\u7a7a\u95f4\uff0c\u589e\u52a0\u5373\u53ef\uff08\u4e00\u822c\u987b\u6709DBA\u6267\u884c\u589e\u52a0\u8868\u7a7a\u95f4\u64cd\u4f5c\uff09\uff0c\u547d\u4ee4\u5982\u4e0b\u6240\u793a\uff1a\n<\/p>\n

\n\tselect upper(f.tablespace_name) "\u8868\u7a7a\u95f4\u540d",
\n\t       d.tot_grootte_mb "\u8868\u7a7a\u95f4\u5927\u5c0f(M)",
\n\t       d.tot_grootte_mb – f.total_bytes "\u5df2\u4f7f\u7528\u7a7a\u95f4(M)",
\n\t       to_char(round((d.tot_grootte_mb – f.total_bytes) \/ d.tot_grootte_mb * 100,
\n\t                     2),
\n\t               '990.99') || '%' "\u4f7f\u7528\u6bd4",
\n\t       f.total_bytes "\u7a7a\u95f2\u7a7a\u95f4(M)",
\n\t       f.max_bytes "\u6700\u5927\u5757(M)"
\n\t  from (select tablespace_name,
\n\t               round(sum(bytes) \/ (1024 * 1024), 2) total_bytes,
\n\t               round(max(bytes) \/ (1024 * 1024), 2) max_bytes
\n\t          from sys.dba_free_space
\n\t         group by tablespace_name) f,
\n\t       (select dd.tablespace_name,
\n\t               round(sum(dd.bytes) \/ (1024 * 1024), 2) tot_grootte_mb
\n\t          from sys.dba_data_files dd
\n\t         group by dd.tablespace_name) d
\n\t where d.tablespace_name = f.tablespace_name
\n\t order by 1;\n<\/p>\n

\n\t2. \u9501\u8868\uff0c\u4e0e\u4ed8\u6b3e\u76f8\u5173\u7684\u8868\u88ab\u9501\u4f4f\uff08\u5176\u4e2d\u4e24\u6b21\u662f\u6b64\u95ee\u9898\u9020\u6210\uff09\n<\/p>\n

\n\t   \u89e3\u51b3\u65b9\u6cd5\uff1a\u901a\u8fc7\u5982\u4e0b\u547d\u4ee4\u67e5\u51fa\u88ab\u9501\u4f4f\u7684\u8868\uff0c\u6700\u540e\u4e00\u4e2a\u5b57\u6bb5\u5373\u662f\u89e3\u9501\u547d\u4ee4\uff0c\u5728COMMAND\u547d\u4ee4\u884c\u6267\u884c\u5373\u53ef\uff0c\u7279\u522b\u662flocked_mode\u4e3a‘6’\u7684\u5728\u5f88\u5927\u7a0b\u5ea6\u4e0a\u662f\u4e0d\u5e94\u8be5\u5b58\u5728\u7684\uff0c\u5177\u4f53\u539f\u56e0\u8bf7\u81ea\u884c\u7f51\u7edc\u4e0a\u641c\u7d22\u3002\n<\/p>\n

\n\tselect dob.object_name table_name,
\n\t       lo.locked_mode,
\n\t       lo.session_id,
\n\t       vss.serial#,
\n\t       vps.spid,
\n\t       vss.action action,
\n\t       vss.osuser osuser,
\n\t       vss.process ap_pid,
\n\t       vps.spid db_pid,
\n\t       'alter system kill session ' || '''' || lo.session_id || ',' ||
\n\t       vss.serial# || ''';' kill_command
\n\t  from v$locked_object lo, dba_objects dob, v$session vss, v$process vps
\n\t where lo.object_id = dob.object_id
\n\t   and lo.session_id = vss.sid
\n\t   and vss.paddr = vps.addr
\n\t order by 2, 3, dob.object_name;\n<\/p>\n

\n\t\"lock\"<\/a>\n<\/p>\n

\n\t\u6700\u7ec8\u6267\u884c\u547d\u4ee4\u5982\u4e0b\u6240\u793a\u793a\u4f8b\uff1a\n<\/p>\n

\n\talter system kill session '38,19020';
\n\talter system kill session '278,3533';
\n\talter system kill session '293,3774';
\n\talter system kill session '1016,64895';
\n\talter system kill session '1054,9699';
\n\talter system kill session '1780,20723';
\n\t \n<\/p>\n

\n\t <\/p>\n","protected":false},"excerpt":{"rendered":"

    \u4eca\u5929\u8d22\u52a1\u4eba\u5458\u5728\u7cfb\u7edf\u5185\u505a\u6279\u91cf\u4ed8\u6b3e\u7684\u65f6\u5019\uff0c\u70b9\u51fb\u6700\u7ec8\u5b8c\u6210\u5e94\u7528\u4ed8\u6b3e\u7684\u65f6\u5019\uff0c\u7cfb\u7edf\u4e00\u76f4\u5904\u4e8e\u8fd0\u884c … \u7ee7\u7eed\u9605\u8bfbEBS web\u9875\u9762Internal Server Error\u9519\u8bef<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[26,19,1],"tags":[33,94,107],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/649"}],"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=649"}],"version-history":[{"count":8,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/649\/revisions"}],"predecessor-version":[{"id":678,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/649\/revisions\/678"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}