Oracle数据库提示 ORA-28001: the password has expired 的解决办法:
1、登录具有DBA权限的账户
2、查看账户信息:
select username,account_status from dba_users;
3、 如果账户locked/expired
- 解锁:
alter user username account unlock;
- 修改密码
alter user username identified by newpswd;
4、查询数据库密码有效期
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
5、修改密码有效期为无限制
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;