EM 12c: 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)))

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

ACCOUNT_STATUS

DBSNMP

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

Comments