Enterprise Manager 13C Cloud control Authentication Fails: The User Name or Password is invalid

 
ISSUE

 
SYMPTOMS

 
SOLUTION

The one of the reason of the issue is the account is locked. You can confirm it by reviewing the $EM_INSTANCE_BASE/user_projects/domains/GCDomain/servers/EMGC_OMS1/sysman/log/emoms.trc log on your OMS server.

oracle@dbpilot.net~: egrep NIPIGAZ /oracle/oem13300/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/sysman/log/emoms.trc |tail -2
[2020-03-02T10:13:42.428+03:00] [EMGC_OMS1] [WARNING] [] [oracle.sysman.eml.sec.auth.provider.repos.EMReposAuthenticatorHelper] [tid: [ACTIVE].ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: 80a92110-f298-4a79-b19f-6cde42d0c583-0001dd18,0] [APP: emgc] Failed to authenticate user NIPIGAZ due to sql error code=28000 error msg: ORA-28000: The account is locked.[[
[2020-03-02T10:13:42.440+03:00] [EMGC_OMS1] [WARNING] [] [oracle.sysman.eml.sec.auth.provider.repos.EMReposLoginModuleImpl] [tid: [ACTIVE].ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: 80a92110-f298-4a79-b19f-6cde42d0c583-0001dd18,0] [APP: emgc] Authentication failed for user: NIPIGAZ Invalid username/password provided

where the NIPIGAZ is the name of the user who is unable to login.

The OMS database contains the following account status

SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='NIPIGAZ';

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
NIPIGAZ                        LOCKED(TIMED)

So to fix the issue just unlock the account

SQL> ALTER USER NIPIGAZ ACCOUNT UNLOCK;

User altered.

SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='NIPIGAZ';

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
NIPIGAZ                        OPEN

When the account is unlocked the user is able to login.

 
RELATED

EM 13c: Enterprise Manager 13C Cloud control Authentication Fails: The User Name or Password is invalid (Doc ID 2232244.1)