oracle11g提示密码过期的问题

 

11g提示密码过期的问题

以scott用户为例子：

1.查看用户使用的profile

SYS>select username,profile from dba_users;

USERNAME                       PROFILE

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

AAA                            DEFAULT

FELIX                          DEFAULT

SCOTT                          DEFAULT

U1                             DEFAULT

U2                             DEFAULT

TSMSYS                         DEFAULT

BI                             DEFAULT

PM                             DEFAULT

MDDATA                         DEFAULT

IX                             DEFAULT

SH                             DEFAULT

DIP                            DEFAULT

OE                             DEFAULT

HR                             DEFAULT

DBSNMP                         MONITORING_PROFILE

SYSMAN                         DEFAULT

MDSYS                          DEFAULT

ORDSYS                         DEFAULT

EXFSYS                         DEFAULT

DMSYS                          DEFAULT

WMSYS                          DEFAULT

CTXSYS                         DEFAULT

ANONYMOUS                      DEFAULT

XDB                            DEFAULT

ORDPLUGINS                     DEFAULT

SI_INFORMTN_SCHEMA             DEFAULT

OLAPSYS                        DEFAULT

MGMT_VIEW                      DEFAULT

SYS                            DEFAULT

SYSTEM                         DEFAULT

OUTLN                          DEFAULT

2.查看对应profile的密码有效期

SYS>SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' and s.RESOURCE_NAME='PASSWORD_LIFE_TIME';

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT

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

DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD UNLIMITED

3.以上是unlimited，如果不是执行一下语句，将密码有效期设置为无限制

sql>ALTER PROFILE DEFAULT LIMIT  PASSWORD_LIFE_TIME UNLIMITED;

4.更改的用户必须重新设置密码

sql>alter user  scott  identified by <密码>