|
报错现象:
[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>
|
|