Symptoms:
The following error message appears on DB home page: ORA-28001: the password has expired The Connect Descriptor was (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=<host>)(PORT=<port>)))(CONNECT_DATA=(SID=<sid>)(SERVER=DEDICATED)))
Cause:
select username, account_status from dba_users where username='DBSNMP';
USERNAME
DBSNMP
ACCOUNT_STATUS
EXPIRED
Monitor User DBSNMP password has been Expired.
Solution:
Resetting the DBSNMP password with old password, you can change it with a new password.
select 'alter user "'||d.username||'" identified by values '''||u.password||''';' from dba_users d, sys.user$ u where d.username = upper('&&username') and u.user# = d.user_id;
'ALTERUSER"'||D.USERNAME||'"IDENTIFIEDBYVALUES'''||U.PASSWORD||''';'
--------------------------------------------------------------------------------
alter user "DBSNMP" identified by values '36A2E1DB82854587';
SQL> alter user "DBSNMP" identified by values '36A2E1DB82854587';
If you keep the old password then you will not need to do any changes in Cloud Control but if you don’t keep the old password then update the new password in cloud control
1. Click Targets->Databases.
2. Select radio button for Database Instance Name and then Click Configure
3. Change the Monitor Password, Click Next and Submit
Restart the agent if needed.
[oracle@server2 ~]$ /opt/oracle/product/agent12c/agent_inst/bin/emctl stop agent
[oracle@server2 ~]$ /opt/oracle/product/agent12c/agent_inst/bin/emctl start agent
[oracle@server2 ~]$ /opt/oracle/product/agent12c/agent_inst/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 12.1.0.2.0
OMS Version : 12.1.0.2.0
Protocol Version : 12.1.0.1.0
Agent Home : /opt/oracle/product/agent12c/agent_inst
Agent Binaries : /opt/oracle/product/agent12c/core/12.1.0.2.0
Agent Process ID : 9029
Parent Process ID : 8930
Agent URL : https://server2.test.com:3872/emd/main/
Repository URL : https://cloud2.test.com:4904/empbs/upload
Started at : 2016-12-07 10:15:48
Started by user : oracle
Last Reload : (none)
Last successful upload : 2016-12-07 10:47:08
Last attempted upload : 2016-12-07 10:47:08
Total Megabytes of XML files uploaded so far : 0.28
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 27.68%
Collection Status : Collections enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2016-12-07 10:53:08
Last successful heartbeat to OMS : 2016-12-07 10:53:08
Next scheduled heartbeat to OMS : 2016-12-07 10:54:08
---------------------------------------------------------------
Agent is Running and Ready