重庆思庄Oracle、Redhat认证学习论坛

标题: 连接数据库报ORA-28002: the password will expire within 7 days [打印本页]

作者: jiawang 时间: 2023-12-14 15:04
标题: 连接数据库报ORA-28002: the password will expire within 7 days
报错现象：
[oracle@sztech ~]$ sqlplus system/oracle@orcl

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 13 15:16:19 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-28002: the password will expire within 7 days
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

查看系统profiles中password_life_time
profiles中password_life_time：密码生命周期，用户密码什么时候到期，单位是天，安装 Oracle 时默认的password_life_time是180天，即6个月，其含义就是，我们的用户密码每6个月就需要更新
（注意：这里的更新不是指密码需要改变，而是指一个更新动作，可以维持密码不变，但必须执行这个更新动作）。

SQL> select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

PROFILE             RESOURCE_NAME                   RESOURCE LIMIT             COM INH IMP
-------------------- -------------------------------- -------- -------------------- --- --- ---
DEFAULT             PASSWORD_LIFE_TIME             PASSWORD 180                NO  NO  NO

修改dba_profiles中password_life_time的设置，改为unlimited。
即不限制，这样我们的用户密码就永不过期了。

SQL> alter profile default limit password_life_time unlimited;

Profile altered.

SQL> select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

PROFILE             RESOURCE_NAME                   RESOURCE LIMIT             COM INH IMP
-------------------- -------------------------------- -------- -------------------- --- --- ---
DEFAULT             PASSWORD_LIFE_TIME             PASSWORD UNLIMITED          NO  NO  NO

修改报账户到期的的用户密码

SQL> alter user system identified by oracle;
User altered.

验证：
[oracle@sztech ~]$  sqlplus system/oracle@orcl

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 13 16:07:34 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Last Successful login time: Wed Dec 13 2023 16:03:34 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)