ENTERPRISE MANAGER 13C AUTHENTICATION FAILS: THE USER NAME OR PASSWORD IS INVALID
Logging On the Enterprise Manager Cloud Control 13c fails with the following error – The User Name or Password is invalid.
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.
$EM_INSTANCE_BASE/user_projects/domains/GCDomain/servers/EMGC_OMS1/sysman/log/emoms.trc
## The "The account is locked." error
oracle@dbpilot.net~:
[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.
EM 13c: Enterprise Manager 13C Cloud control Authentication Fails: The User Name or Password is invalid (Doc ID 2232244.1)
Tags In
- Accounts
- Auditing
- AWR
- Bash Scripts
- Datapump
- Default Category
- Demos
- Directory Objects
- Environment Variables
- Initialization Parameters
- Iptables
- Java Program
- Memory Usage
- Metadata API
- Networker
- NLS Settings
- Optimizer Statistics
- ORA-00942
- ORA-01031
- ORA-01720
- ORA-28001
- ORA-31671
- Oracle Database
- Oracle Enterprise Manager
- Performance Tunning
- Postfix
- Privilegies
- Processes
- Queries
- Red Hat Enterprise Linux
- Redo Logs
- Sessions
- SQLPlus
- Statspack
- Tablespaces
- UTL_FILE
- UTL_FILE_DIR
- Wait Events
- Yum