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

* 博客文章部分截图及内容来自于学习的书本及相应培训课程以及网络其他博客，仅做学习讨论之用，不做商业用途。
* 如有侵权，马上联系我，我立马删除对应链接。
* @author Alan
* @Email no008@foxmail.com

一：问题描述：
二；处理步骤

正文

一：问题描述：

二；处理步骤

[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>