执行请求的操作时遇到数据库警告:ORA-28002: the password will expire within 7 days

执行请求的操作时遇到数据库警告:

ORA-28002: the password will expire within 7 days
28002. 00000 -  "the password will expire within %s days"
*Cause:    The user's account is about to expire and the password
           needs to be changed
*Action:   change the password or contact the DBA
供应商代码 28002

意味oracle即将过期。

解决方法：1.修改密码
2.更改数据库设置为密码永不过期（不建议）

1. 登录到sqlplus
   sqlplus / as sysdba
2. 查看密码有效期时长

SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

3. 将密码设置成永不过期

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
4. 修改用户密码

SQL> alter user joffice identified by joffice;