{"id":10676,"date":"2021-08-13T21:55:07","date_gmt":"2021-08-13T13:55:07","guid":{"rendered":"https:\/\/ailog.tw\/lifelog\/?p=10676"},"modified":"2021-08-13T21:55:07","modified_gmt":"2021-08-13T13:55:07","slug":"ora-28000","status":"publish","type":"post","link":"https:\/\/ailog.tw\/lifelog\/2021\/08\/13\/ora-28000\/","title":{"rendered":"Oracle\u6392\u9664ORA-28000: the account is locked\u554f\u984c"},"content":{"rendered":"<p><span style=\"font-size: 14pt; font-family: verdana, geneva;\">\u5c0f\u7de8\u9047\u5230\u4e00\u500bOracle Database\u5e33\u865f\u88ablocked\u554f\u984c\uff0c\u90a3\u8a72\u5982\u4f55\u89e3\u9664\u5c01\u9396\u5462?\u8b93\u6211\u5011\u770b\u4e0b\u53bb\u3002<!--more--><\/span><\/p>\n<p><span style=\"font-size: 14pt; font-family: verdana, geneva;\">\u60c5\u5883\u8aaa\u660e\uff1a<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\">01\u3001Red Hat Enterprise Linux Server release 6.8<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\">02\u3001Oracle 11.2.0.4<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\">03\u3001\u4f7f\u7528\u5e33\u6236\u767b\u5165Oracle\u6642\u51fa\u73fe\u300cORA-28000: the account is locked\u300d\u544a\u8b66<\/span><\/p>\n<p><span style=\"font-size: 14pt; font-family: verdana, geneva;\">\u6392\u9664\u6b65\u9a5f\uff1a<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\">01\u3001\u767b\u5165SQL<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\">\u6307\u4ee4\uff1a<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva; color: #ff0000;\">sqlplus &#8220;\/ as sysdba&#8221;<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10678 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/08\/ORA-28000-02.png\" alt=\"\" width=\"812\" height=\"273\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/08\/ORA-28000-02.png 812w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/08\/ORA-28000-02-300x101.png 300w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/08\/ORA-28000-02-768x258.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/span><\/p>\n<p><span style=\"font-size: 14pt; font-family: verdana, geneva;\">02\u3001\u89e3\u9664\u5e33\u865f\u5c01\u9396<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\">\u6307\u4ee4\uff1a<\/span><br \/>\n<span style=\"color: #ff0000; font-size: 14pt; font-family: verdana, geneva;\">alter user ogg account unlock;<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\">\u5099\u8a3b\u8aaa\u660e\uff1aogg\u70ba\u672c\u7bc4\u4f8b\u88ab\u5c01\u9396\u5e33\u865f\uff0c\u64cd\u4f5c\u6642\u8acb\u81ea\u884c\u8b8a\u66f4\u70ba\u9700\u8981\u89e3\u9664\u5c01\u9396\u7684\u5e33\u865f\u3002<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10679 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/08\/ORA-28000-03.png\" alt=\"\" width=\"436\" height=\"138\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/08\/ORA-28000-03.png 436w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/08\/ORA-28000-03-300x95.png 300w\" sizes=\"auto, (max-width: 436px) 100vw, 436px\" \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5c0f\u7de8\u9047\u5230\u4e00\u500bOracle Database\u5e33\u865f\u88ablocked\u554f\u984c\uff0c\u90a3\u8a72\u5982\u4f55\u89e3\u9664\u5c01\u9396\u5462?\u8b93\u6211\u5011\u770b\u4e0b\u53bb\u3002<\/p>\n","protected":false},"author":1,"featured_media":10677,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,387],"tags":[4645,1105,4650,4646,4649,4647,375,4648],"class_list":["post-10676","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-itinfo","category-database","tag-ora-28000","tag-oracle","tag-oracleora-28000-the-account-is-locked","tag-the-account-is-locked","tag-unlocked","tag-4647","tag-375","tag-4648"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/10676","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/comments?post=10676"}],"version-history":[{"count":1,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/10676\/revisions"}],"predecessor-version":[{"id":10680,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/10676\/revisions\/10680"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/media\/10677"}],"wp:attachment":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/media?parent=10676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/categories?post=10676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/tags?post=10676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}