ORA-28002: the password will expire解决办法
Oracle11g R2数据库提示ORA-28002: the password will expire within 5 days,是说密码过期,将Oracle密码设置成永不过期就可以了,不过并不推荐这样做,最好是将日期密码有效期设置长一些。
SQLDeveloper或者在项目中连接数据库提示
ORA-28002: the password will expire within 5 days
登录到sqlplus
sqlplus / as sysdba
查看密码有效期时长
SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
将密码设置成永不过期
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
修改用户密码
SQL> alter user joffice identified by joffice;