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';
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;
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 |