查看用户的 profile(一般是 default)
select username,profile from dba_users;
查看 default 概要文件设置的密码有效期(默认 180 天)
SQL> select * from dba_profiles where resource_name ='PASSWORD_LIFE_TIME' and profile='DEFAULT';
PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP
---------- -------------------- -------- ---------- --- --- ---
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180 NO NO NO
将密码有效期设置为无限制,可以调整天数
alter profile default limit password_life_time unlimited;
修改密码测试
SQL> alter user username identified by "passwd";