FYI
[oracle@ocp2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 2 11:31:48 2015
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> create user MFOPER identified by dbdao;
User created.
SQL> grant dba to MFOPER;
Grant succeeded.
SQL> alter user MFOPER profile default;
User altered.
SQL> alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.
SQL>
SQL> conn mfoper/dbdao
Connected.
SQL>
SQL> conn / as sysdba
Connected.
SQL>
SQL> select * from dba_profiles where profile='DEFAULT' and RESOURCE_NAME like 'PASSWORD%';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD
UNLIMITED
DEFAULT PASSWORD_REUSE_TIME PASSWORD
UNLIMITED
DEFAULT PASSWORD_REUSE_MAX PASSWORD
UNLIMITED
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD
NULL
DEFAULT PASSWORD_LOCK_TIME PASSWORD
1
DEFAULT PASSWORD_GRACE_TIME PASSWORD
7
6 rows selected.
SQL>
SQL>
SQL> alter user MFOPER password expire;
User altered.
SQL> conn mfoper/dbdao
ERROR:
ORA-28001: the password has expired
Changing password for mfoper
New password:
至少可以手动让password expire, 目前无法排除如上可能 ， 当然还有其他可能存在