OracleXE 11g user莫名过期

参考大大的

环境sqlplus

1.sysdba登陆

SQL>conn sys as sysdba
password

2.查看用户状态

SQL>select username,account_status,lock_date from dba_users;

3.解决问题

• 单纯被锁

  SQL>alter user user_name account unlock;
  SQL>commit;

   

• 用户过期

  ;以HR用户为例
  SQL>UPDATE USER$ SET ASTATUS=0 WHERE NAME='HR';
  ；修改状态
  SQL>select username,account_status from dba_users where username in('SYS','HR');
  ;查看状态
  SQL>select name,ASTATUS,password from user$ where name IN('SYS','HR');
  ;查看密码
  SQL>alter user HR identified by values '4C6D73C3E8B0F0DA';
  ；以密文修改

  ok~~