当设置了PASSWORD_LIFE_TIME后，密码到期之前会有提示

SQL> set linesize 400

SQL> select * from dba_profiles;

PROFILE RESOURCE_NAME RESOURCE LIMIT

------------------------------ -------------------------------- -------- ----------------------------------------

...

MONITORING_PROFILE PASSWORD_LIFE_TIME PASSWORD DEFAULT

DEFAULT PASSWORD_LIFE_TIME PASSWORD 180

...

32 rows selected.

[oracle@sourcedb ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 11 13:16:26 2017

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn test/test

ERROR:

ORA-28002: the password will expire within 7 days

Connected.

SQL>

SQL> select * from test;

ID

----------

1

1

2

1

1

使用plsql登录时也会提示

并提示修改密码：

点击取消可以不修改密码，使用原密码登录。