DBSNMP account lockout
On a new install of Enterprise Manager 10.1 we would get random failures caused by the dbsnmp account getting locked(timed) due to failed login attempts exceeding the default profile’s setting of ten.
This is caused by the dbsnmp user connecting with the wrong password more than 10 times in a row which forces an account lockout. With the account locked out EM can’t connect to the database. The database is still up and fine.
To work around the problem I have created a new profile and assigned that profile to the dbsnmp user and unlocked the account as shown below.
SQL> create profile dbsnmp limit failed_login_attempts unlimited;
Profile created.
SQL> alter user dbsnmp profile dbsnmp;
User altered.
SQL> alter user dbsnmp account unlock;
User altered.
-Rick
