[杞琞鍏充簬Oracle 10g scott鐢ㄦ埛瑙ｉ攣鐨勬柟娉曚袱鍒

[杞琞鍏充簬Oracle 10g scott鐢ㄦ埛瑙ｉ攣鐨勬柟娉曚袱鍒?

鏉ユ簮锛?a href="http://wtq.iteye.com/blog/390839">http://wtq.iteye.com/blog/390839

聽

鍦ㄥ畨瑁呭畬Oracle10g涔嬪悗锛屾兂鎵撳紑sql*plus鏉ュ涔狅紝鐒跺悗鎸夌収涔︿笂鐨勬楠ょ敤scott鐢ㄦ埛鏉ヨ繛鎺ユ暟鎹簱锛屽彲杈撲簡濂藉嚑娆￠兘鎻愮ず涓€涓敊璇€?/p>

error锛?the account is locked

鐒跺悗涓婄綉鏌ヤ簡涓€涓嬩箣鍚庡彂鐜拌繖涓敤鎴疯閿佸畾浜嗭紝鑷充簬瀹冧负浠€涔堣閿佸畾锛屽彲鑳芥槸涓嬮潰鍑犱釜鍘熷洜銆?/p>

1.灏濊瘯澶氭鐧诲綍鏈垚鍔?(鍙兘瀵嗙爜涓嶆纭?

2.姝ょ敤鎴疯绠＄悊鍛樻墜宸ラ攣瀹?

3.鐢ㄦ埛瀵嗙爜鍒版湡.鏈寜鏃朵慨鏀瑰瘑鐮?绛夌瓑...

杩欎釜鐢ㄦ埛鑲畾鏄櫥闄嗕笉浜嗕簡锛岀劧鍚庢垜鐢╯ystem杩欎釜鐢ㄦ埛鐧诲綍锛屽彲鏄櫥浜嗗崐澶╅兘娌℃湁杩涘幓锛屽張鍘荤綉涓婃煡锛岀綉涓婇潰澶ч兘鏄叧浜?oracle 9i鐨勭敤鎴峰拰瀵嗙爜锛屽悗鏉ユ垜璁板緱鍦ㄥ畨瑁呯殑鏃跺€欏氨鎻愮ず杈撳叆浜嗭紝鐢ㄩ偅涓瘯浜嗕竴涓嬪氨杩炴帴涓婁簡锛屾墍浠ュ湪oracle 10g鐨剆ystem杩欎釜鐢ㄦ埛鐨勫瘑鐮佷笉鏄粯璁ょ殑锛岃€屾槸瀹夎鐨勬椂鍊欒嚜宸辫瀹氱殑銆?/p>

鎷縮ystem鐧诲綍杩涘幓涔嬪悗锛屾墽琛屼笅闈㈢殑鍛戒护锛?/p>

SQL> alter user scott account unlock;

鐢ㄦ埛宸叉洿鏀广€?/p>

杩欐牱灏卞畬鎴愯В閿佺殑鎿嶄綔銆傛帴涓嬫潵锛屼綘杩樺彲浠ラ噸鏂扮粰scott杩欎釜鐢ㄦ埛璁惧畾瀵嗙爜

淇敼scott鐨勭櫥褰曞瘑鐮?/p>

SQL> alter user scott identified by pan;

鐢ㄦ埛宸叉洿鏀广€?/p>

ok浜嗭紝浣犲啀鎷縮cott 鍜?pan鏉ョ櫥褰曞氨鍙互浜嗭紒

SQL> conn scott/pan

宸茶繛鎺ャ€?/p>

聽

鏂拌瀹孫racle10g鍚庯紝鐢╯ystem/password鍙互姝ｅ父鐧诲綍锛岃€屼娇鐢╯cott/tiger鐢ㄦ埛鍗翠笉鑳界櫥褰曪細

conn scott/tiger

error锛歰racle10g the account is locked

oracle10g the password has expired

鍘熷洜锛氶粯璁?span style="color: #000000;">Oracle10g鐨剆cott涓嶈兘鐧婚檰銆傝绂佺敤浜嗐€?/p>

瑙ｅ喅鏂规硶锛?/p>

棣栧厛纭宸茬粡瀹夎oracle 鏁版嵁搴撳拰瀹㈡埛绔?/p>

.鍦ㄥ鎴风DOS涓嬫墽琛屽涓嬭鍙ワ細

聽

娉ㄦ剰鎻愮ず绗﹀彿
c:\sqlplus /nolog
sqlp\ conn sys/system@oracle10 as sysdba // sys涓哄綋鍓嶇殑oracle 鐢ㄦ埛 system 涓鸿鐢ㄦ埛瀵嗙爜 oracle10 涓篠ID
# alter user soctt account lock; // 鎶?scott鐢ㄦ埛閿佸畾
# alter user scott account unlock; //鎶妔cott鐢ㄦ埛瑙ｉ攣
# alter user scott identified by scott //淇敼scott鐢ㄦ埛瀵嗙爜涓?scott,scott鐢ㄦ埛榛樿瀵嗙爜涓?tiger

1 Dos涓嬭緭鍏?span style="font-size: small;">C:\sqlplus /nolog

2 浠BA鐨勮韩浠界櫥褰?br>conn sys/password as sysdba;
3 瑙ｉ攣
alter user scott account unlock;
4 寮瑰嚭涓€涓慨鏀瑰瘑鐮佺殑瀵硅瘽妗嗭紝淇敼瀵嗙爜
conn scott/tiger

SQL> conn sys/sys as sysdba;
Connected.
SQL> alter user scott account unlock;
User altered.
SQL> commit;
Commit complete.
SQL> conn scott/tiger//璇疯緭鍏ユ柊瀵嗙爜锛屽苟纭鍚嶰K
Password changed
Connected.

聽

[杞琞鍏充簬Oracle 10g scott鐢ㄦ埛瑙ｉ攣鐨勬柟娉曚袱鍒

相关推荐