ora-28001:the Password has expired (DBD error:ocisessionbegin) EM cannot log in

First to complain, obviously just finished writing, released when said did not land, all of a sudden.

Today open EM Discovery tips

ora-28001:the Password has expired (DBD Error:ocisessionbegin)

So I looked up the information, the password expires so that EM can not log in. oracle11g The default password age is 180 days, only the configuration file can be modified to permanently resolve the issue.

1. Check the password age in the current database

[Email protected] orcl>select * from dba_profiles where profile= ' DEFAULT ' 2 and resource_name= ' Password_life_time ';

Profile resource_name RESOURCE LIMIT---------------------------------- ----------------------------------------------------------------------------DEFAULT Password_life _time PASSWORD 180

2, modified to unlimited

[Email protected] Orcl>alter profile default limit Password_life_time unlimited;

3. View EM's two account status Sysman and Dbsnmp

[Email protected] orcl>select username,account_status from Dba_users;

username                        account_status--------------------------------------------------------------TEST                             OPEN test2                           OPEN scott                           OPEN hr                               OPEN oracle_ocm                      EXPIRED & LOCKED xs$null                         EXPIRED & LOCKED bi                               EXPIRED & LOCKED pm                               EXPIRED & LOCKED mddata                          EXPIRED & LOCKED ix                               EXPIRED & LOCKED sh                              EXPIRED & LOCKED

USERNAME account_status--------------------------------------------------------------DIP               EXPIRED & LOCKED OE EXPIRED & LOCKED Apex_public_user EXPIRED & LOCKED spatial_csw_admin_usr EXPIRED & LOCKED spatial_wfs_admin_usr EXPIRED & LOC KEDdbsnmp EXPIRED Sysman EXPIRED

4, 2 accounts are expired, so change the password

[Email protected] orcl>alter user DBSNMP identified by Oracle;

User altered.

[Email protected] orcl>alter user Sysman identified by Oracle;

User altered.

5, and then re-open em, to normal use. I restarted the database and the EM before I changed the password.

Ora-28001:the Password has expired (DBD error:ocisessionbegin) EM cannot log on