Oracle 中的User被Lock住了可以這麼解
#sqlplus / as sysdba
SQL> conn sys as sysdba
Enter password:
Connected.
SQL>
SQL> select USERNAME,ACCOUNT_STATUS,LOCK_DATE from dba_users where USERNAME=’$USERNAME’;
#query 你要的user出來確認該username的狀態
SQL> alter user $USERNAME account unlock; # unlock!!!
參考來源
http://monishsb.wordpress.com/2008/10/10/lock-unlock-users/
