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