My Oracle Support Banner

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 later
Information in this document applies to any platform.

Symptoms

emcli command fails with below error :

$emcli login -username=sysman -password=xxxxxxx
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.