处理：“ORA-28002: the password will expire within 7 days”的问题

原创

一品堂_技术学习笔记 2021-07-16 14:30:52 ©著作权

文章标签 其他 文章分类 代码人生

©著作权归作者所有：来自51CTO博客作者一品堂_技术学习笔记的原创作品，请联系作者获取转载授权，否则将追究法律责任

一：问题描述：

二；处理步骤

[oracle@localhost 2018_07_14]$ rlwrap sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 14 18:53:53 2018

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options



SYS@orcl> select username ,profile from dba_users where username ='SCOTT';

USERNAME                       PROFILE
------------------------------ ------------------------------
SCOTT                          DEFAULT



SYS@orcl> 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
180




SYS@orcl> alter profile default limit password_life_time unlimited;

Profile altered.

SYS@orcl> alter user scott identified by scott;

User altered.

SYS@orcl> conn scott/scott
Connected.
SCOTT@orcl>