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

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,问题已经解决

-------->>如果问题还是没有解决，请继续往下看：

再次查询sysman和dbsnmp用户的状态，这次的状态为LOCKED(TIMED)
SQL> select username,account_status from dba_users where username='SYSMAN';
USERNAME ACCOUNT_STATUS
SYSMAN LOCKED(TIMED)

原因：
dbsnmp和sysman这两个用户和oem紧密相关，dbsnmp用户启动Oracle智能代理，用于收集oracle系统运行状态的相关数据，sysman是oem的超级管理员。如果配置了oem后，又使用alter user <用户名> identified by <新口令>；修改了这两用户的口令，就会出现dbsnmp 和sysman "LOCKED(TIMED)". 的情况。

解决方法：
还必须同步修改oem中记录的dbsnmp和sysman用户的口令。

$emca -config dbcontrol db

根据提示修改sysman和dbsnmp的口令即可

ITPub博客

EM无法登录，提示ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)

最新文章