My Oracle Support Banner

EM 13.5c: Normal User Login To OAS Console Failed With Error 'Login failed, please retry' (Doc ID 2947234.1)

Last updated on MAY 23, 2023

Applies to:

Enterprise Manager Base Platform - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

The Oracle Analytics Server (OAS) is configured with OEM using following document.
How to Install OAS (Oracle Analytics Server) and Configure to Integrate with EM 13.4 / 13.5 (Doc ID 2824465.1)

The security model is configured to 'Enterprise Manager Repository-based Security' using following document.
EM 13c: How to Configure OAS Security Based on the Security Configuration Used by Enterprise Manager (Doc ID 2824629.1)

Login to OAS console works fine with super user. But login with any normal user failing with 'Login failed, please retry' error on the console.

$ <OAS_MW_HOME>/user_projects/domains/bi/servers/bi_server1/logs/bipublisher/bipublisher.log

[2023-04-20T10:16:54.503-05:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 133] [userId: <anonymous>] [ecid: 5019f722-c04c-4ca2-9f72-3b42ec689ca2-0000007a,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] java.sql.SQLException: Invalid Oracle URL specified[[
   at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:635)
   at java.sql.DriverManager.getConnection(DriverManager.java:664)
   at oracle.xdo.security.OraValidator.validate(OraValidator.java:117)
   at oracle.xdo.security.OraValidator.validateInternal(OraValidator.java:112)
   at oracle.xdo.servlet.security.ORCLDBSecurityHandler.getOracleDBPrincipal(ORCLDBSecurityHandler.java:163)
   at oracle.xdo.servlet.security.ORCLDBSecurityHandler.getPrincipal(ORCLDBSecurityHandler.java:63)

 

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
References


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