--查看数据库目前的口令期限

sys@TESTDB11>select * from dba_profiles where profile = 'DEFAULT' and resource_name = 'PASSWORD_LIFE_TIME';

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT

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

DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD 180

--查看用户的状态,发现DBSNMP和SYSMAN两个帐号都已经过期

sys@TESTDB11>select username, account_status from dba_users;

USERNAME                       ACCOUNT_STATUS

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

MGMT_VIEW                      OPEN

SYS                            OPEN

SCOTT                          OPEN

PLSQL                          OPEN

IX                             OPEN

SH                             OPEN

OE                             OPEN

HR                             OPEN

STORE                          OPEN

OPS$USERA                      OPEN

USERA                          OPEN

DBSNMP                         EXPIRED

SYSMAN                         EXPIRED

SYSTEM                         EXPIRED(GRACE)

OUTLN                          EXPIRED & LOCKED

FLOWS_FILES                    EXPIRED & LOCKED

MDSYS                          EXPIRED & LOCKED

ORDSYS                         EXPIRED & LOCKED

EXFSYS                         EXPIRED & LOCKED

WMSYS                          EXPIRED & LOCKED

APPQOSSYS                      EXPIRED & LOCKED

APEX_030200                    EXPIRED & LOCKED

OWBSYS_AUDIT                   EXPIRED & LOCKED

ORDDATA                        EXPIRED & LOCKED

CTXSYS                         EXPIRED & LOCKED

ANONYMOUS                      EXPIRED & LOCKED

XDB                            EXPIRED & LOCKED

ORDPLUGINS                     EXPIRED & LOCKED

OWBSYS                         EXPIRED & LOCKED

SI_INFORMTN_SCHEMA             EXPIRED & LOCKED

OLAPSYS                        EXPIRED & LOCKED

ORACLE_OCM                     EXPIRED & LOCKED

XS$NULL                        EXPIRED & LOCKED

BI                             EXPIRED & LOCKED

PM                             EXPIRED & LOCKED

MDDATA                         EXPIRED & LOCKED

DIP                            EXPIRED & LOCKED

APEX_PUBLIC_USER               EXPIRED & LOCKED

SPATIAL_CSW_ADMIN_USR          EXPIRED & LOCKED

SPATIAL_WFS_ADMIN_USR          EXPIRED & LOCKED

40 rows selected.

--修改用户的口令期限为无限制

sys@TESTDB11>alter profile default limit password_life_time unlimited;

Profile altered.

--修改DBSNMP和SYSMAN两个帐号的口令

sys@TESTDB11>alter user dbsnmp identified by dbsnmp;

User altered.

sys@TESTDB11>alter user sysman identified by sysman;

User altered.

--重新登录EM,问题已经解决