Unable to log in to Enterprise Manager Console 13c with correct username and password.
SYMPTOMS

Logging On the Enterprise Manager Cloud Control 13c fails with the following error – The User Name or Password is invalid.

OEM_13c_LoginPage_The_User_Name_or_Password_is_invalid

SOLUTION

One of the reasons for the issue is that the ACCOUNT is locked. You can confirm it by reviewing the emoms.trc file located on the OMS server.

## Log file location

$EM_INSTANCE_BASE/user_projects/domains/GCDomain/servers/EMGC_OMS1/sysman/log/emoms.trc

## The "The account is locked." error

oracle@dbpilot.net~: egrep NIPIGAZ 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 was unable to log in.

So, to fix the issue, unlock the LOCKED account.

-- OMS repository Database

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

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


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 can log in again.

RELATED

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

Written At
02 MAR 202010:00
Red Hat Release
7.x x64
Enterprise Manager
13.3.0.0.0