ORA-28002
1. 查看用户的profile设置:
SELECT username,profile FROM dba_users;
2、查看系统profiles中PASSWORD_LIFE_TIME设置:
SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'; PROFILE RESOURCE_NAME RESOURCE LIMIT ------------------------------ -------------------------------- ------------------------------------------------ DEFAULT PASSWORD_LIFE_TIME PASSWORD 180dys
3、修改DBA_PROFILES中PASSWORD_LIFE_TIM的设置,改为ULIMITED
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
4、已提示过期的密码需要重置