EM 13.5: Additional OMS Login Fails With Error "wrong number or types of arguments in call to 'DO_EM_LOGIN'"
(Doc ID 3036526.1)
Last updated on JULY 29, 2024
Applies to:
Enterprise Manager Base Platform - Version 13.4.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
- Multi-Node OMS setup.
- SLB not configured.
- Login to EM Console from primary Node OMS works without any issues.
- Additional OMS Console login errors with "The username or password is invalid"
emcli command fails with below error :
Error: Login failed. Retry with correct hostname, port or username / password else check the log files for further details.
Log file location is : <GC_INST>/em/EMGC_OMSn/sysman/emcli/setup/.emcli/.emcli.log
OMS log showing error : $../gc_inst/em/EMGC_OMSn/sysman/log/emoms.trc file reports following errors:
2022-03-09 11:26:52,238 [[ACTIVE] ExecuteThread: '99' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG conn.FGAConnection .178 - Connection created 832091057
2022-03-09 11:26:52,238 [[ACTIVE] ExecuteThread: '99' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG conn.FGAConnection _setConnContext.369 - connection obj=66421405 trueUserName=SYSMAN operation=1 emKey is NULL =false auditSessionGuid=null auditSessionGuidType=null
2022-03-09 11:26:52,242 [[ACTIVE] ExecuteThread: '99' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG auth.EMLoginService _performLogin.1499 - Error
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'DO_EM_LOGIN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
(...)
Caused by: Error : 6550, Position : 6, Sql = begin EM_USER_MODEL_UI.do_em_login(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ,:25 ,:26 ,:27 ,:28 ,:29 ,:30 ,:31 ,:32 ,:33 ,:34 ,:35 ,:36 ,:37 ,:38 ,:39 ,:40 ,:41 ,:42 ,:43 ); end;, OriginalSql = begin EM_USER_MODEL_UI.do_em_login(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
,?,?,?,?,?,?,?,?,?,?,?,?,?); end;, Error Msg = ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'DO_EM_LOGIN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |