Search This Blog

Tuesday, 2 October 2018

Go URL in OBIEE 12c

Problem:
When we are trying to use Go URL functionality, It always comes to login page.

Why is it happening?
With 12c, 12.2.1.2+ A new feature called Light Weight SSO has been introduced. 

When this feature is enabled, using "NQUser"/"NQPassword" in the URL is not possible or supported.
 
Lightweight SSO is implemented by default in new installations of Oracle BI EE release 12.2.1.3.0

Solution:
Disabling the Lightweight SSO will help us to overcome this issue and Report/Dashboard with Go URL will just fine without going to login page.

Steps to Disable Lightweight SSO:

Step1:
Stop all the BI Services. Go to the link to know Stop and Start BI 12c Services

Step2: 
After stopping the BI Services, Go to the following path and execute WLST offline

[ORACLE_BI_HOME]/oracle_common/common/bin/wlst.sh

execute the 'disableBISingleSignOn' command to disable.

wls:/offline> disableBISingleSignOn('/path to your domain')

e.g: 
wls:/offline> disableBISingleSignOn('$ORACLE_BI_HOME/user_projects/domains/bi')


Step3:
Now Start all the BI Services using ./start.sh (Linux) or Start.cmd (Windows) and check with the Go URL. 

Cheers!
Bose

No comments:

Post a Comment

What is Oracle Database Link and How to create database link (DB Link)

 https://www.oracletutorial.com/oracle-administration/oracle-create-database-link/

Recent Posts