
oracle账号频繁锁定问题定位及分析过程
现象:
Enter password:
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
解决过程
查看锁定时间及锁定类别:
SQL> conn / as sysdba
Connected.
SQL> select username,to_char(lock_date,'yyyy/mm/dd hh24:mi:ss') as locktime,account_status from dba_users where username='***********...