Enterprise Manager 13C Cloud control Authentication Fails: The User Name or Password is invalid
Enterprise Manager
ISSUE
Accessing Enterprise Manager Cloud Control 13c from the authentication page with a correct username and password fails with the following error – “The User Name or Password is invalid.”
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)
Version : 10:27 02-Mar-20
Platform : Red Hat 7.6
OEM : 13.3.0.0.0
Platform : Red Hat 7.6
OEM : 13.3.0.0.0
Tags In
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (69)
- Account (2)
- AWR (4)
- Database Errors (6)
- Database Performance (10)
- Datapump (4)
- Enterprise Manager (25)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (3)
- High IO Load (4)
- Historical Session Information (3)
- Initialization Parameters (5)
- job_queue_processes (1)
- Processes (3)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (1)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Privileges (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (6)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (2)
- Tablespaces (1)
- Temporary Tablespace (2)
Tags
/etc/sudoers
Account
ACTIVE SESSION HISTORY
Agent
Agent 12c Deinstall
Agent 13c Deployment
ASH
Automated Maintenance Tasks
AWR
BLOCKING SESSION
Database Auditing
Database Directory
Database Performance
Datapump
DBMS_SYSTEM
Enterprise Manager
Enterprise Manager Metrics
Failed Logins (Historical) Metric
Failed Logins Metric
Gather Statistics Job
GET_ENV
High IO Load
historical session information
Idle Sessions
Initialization Parameters
LOCKED(TIMED)
OEM
OEM 12.1.0.4
OEM 13.1.0.0.0
OMS
Processes
Repository
ROW LOCK
Scheduler
Schema Statistics
Scripts
Sessions
spfile
SQL_ID
STANDARD EDITION
Standard Query
TRANSACTION
UTL_FILE
WAITING SESSION
Yum