Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle database user dbsnmp EM 12c

2931117Jan 9 2017 — edited Jan 9 2017

Hi All, I have a database in oracle data guard 12c and they are monitored using 12c cloud control. I am getting error when accessing the monitored database

using 13c cloud control.

ORA-28001: the password has expired The Connect Descriptor was (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=ads1)(PORT=1521)))(CONNECT_DATA=(SID=P6PRD1)(SERVER=DEDICATED)))

When I checked the account DBSNMP is locked in database.

select username, account_status from dba_users where username='DBSNM

P';

USERNAME

--------------------------------------------------------------------------------

ACCOUNT_STATUS

--------------------------------

DBSNMP

EXPIRED

I wanted to know the default password comes with 12c databaseĀ  for the account DBSNMP so that I would resetĀ  the password and unlock it.

This post has been answered by Gbenga Ajakaye on Jan 9 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2017
Added on Jan 9 2017
6 comments
2,265 views