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

最新推荐文章于 2024-11-06 11:17:40 发布

weixin_34161029

最新推荐文章于 2024-11-06 11:17:40 发布

阅读量107

点赞数

文章标签：数据库

一：问题描述：

二；处理步骤

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