OBIEE 11g by default uses its own authentication engine against users stored in WebLogic’s Embedded LDAP Server.
Oracle Access Manager (OAM) is Single Sign-On (SSO) solution from Oracle and there are two versions of OAM i.e. 10g and 11g. More here on differences between OAM 10g and 11g .
OBIEE can be configured for Single Sign-On (OAM) with user repository is LDAP Server (OID or AD). This post assumes that User Repository for OBIEE is OID. If you wish to use AD as user repository then replace OID with AD while using this post. To know more about Oracle Access Manager 11g, check my book at amazon
High Level Steps to integrate OBIEE with OAM (for Single Sign-On)
1. Install OBIEE 11g (11.1.1.5)
2. Install OHS 11g (install 11.1.1.2 and then apply patch 11.1.1.5)
3. Configure access to OBIEE via OHS (mod_wl_ohs)
4. Install OID 11g (install 11.1.1.2 and then apply patch 11.1.1.5)
5. Integrate OBIEE 11g with OID for user repository
6. Install OAM 11g (11.1.1.3 or 11.1.1.5)
7. Integrate OAM 11g with OID for user repository
8. Create Instance of WebGate in OAM 11g
9. Install WebGate with OHS 11g (installed in step 2)
10. Configure OAM Identity asserter as authentication provider in Weblogic Domain hosting OBIEE
11. Configure Response (header variable OAM_REMOTE_USER) in protected authenticated and authorisation policy
12. Enable SSO in OBIEE (including logon URL, Logoff URL) using FMW Enterprise Manager Control
13. Test OBIEE Single Sign-On configuration
Steps
1. Install OBIEE 11g - Follow OBIEE installation steps here, here and here.
This step will create middleware home (MW_HOME), OBIEE Oracle Home (ORACLE_HOME) and OBIEE Oracle Instance (ORACLE_INSTANCE)
2. Install OHS 11g - You can access OBIEE directly by using managed server port. In SSO environment, request to OBIEE managed servers should come via this HTTP Server. A Policy Enforcement Point (PEP) which is WebGate in this case is configured that will communicate to Oracle Access Manager (SSO server).
This step will create OHS Oracle Home (ORACLE_HOME) and OHS Oracle Instance (ORACLE_INSTANCE)
Note: ORACLE_HOME of OBIEE and OHS must be installed in different directory, similarly ORACLE_INSTANCE of OBIEE and OHS must be installed in different directory.
- Follow OHS Installation guide here (Do not select WebCache during configuration)
3. Configure access to OBIEE via OHS (mod_wl_ohs)
Configure mod_wl_ohs in OHS to forward request to OBIEE Managed Server (bi_server1) and restart OHS. Test if you can access OBIEE via OHS Server . More on mod_wl_ohs here and here
http://http_server:http_listen_port/analytics
4. Install OID 11g - Enterprise Users that are going to access OBIEE via SSO (OAM in this case) will be stored in OID. Follow OID installation steps here, here, here, and here (DIP, OVD and OIF are optional components and are not required for this integration).
This step will create middleware home for OID, OID Oracle Home (ORACLE_HOME) and OID Oracle Instance (ORACLE_INSTANCE).
Note: You can install OBIEE and OID in same Middleware Home but this is not recommended.
ORACLE_HOME for OID, OBIEE, and OHS must be in different directory.
ORACLE_INSTANCE for OID, OBIEE, and OHS must be in different directory.
5. Integrate OBIEE 11g with OID for user repository. - By default OBIEE 11g authenticates against WebLogic’s embedded LDAP server using Default Authentication Provider. You must add additional Authentication Provider of type OID in WebLogic Security Realm (steps here and here ) so that OBIEE/WebLogic can authenticate users against OID.
6. Install OAM 11g - If you are installing same version of OID and OAM i.e. 11.1.1.1.5 then these two (OID and OAM) can be installed in same Middleware Home (MW). This step will create OAM Oracle Home (ORACLE_HOME).
Note: You can install OID and OAM in different Middleware Home then this step will also create Middleware Home (MW_HOME) for OAM.
Note: ORACLE_HOME for OAM, OID, OBIEE, and OHS must be in different directory.
Note: OAM comes with additional components like OIM, OAAM, OIN and these components are optional.
7. Integrate OAM 11g with OID for user repository - By default OAM 11g uses WebLogic’s embedded LDAP server as its Identity/User Store. You must add additional identity store in OAM to point to same OID which is configured with OBIEE. Screen to configure Identity Store in OAM 11.1.1.3 and 1.1.1.5 are slightly different. For 11.1.1.3 click here and for OAM 11.1.1.5 click here
More on OAM integration with OID in my book here
8. Create Instance of WebGate in OAM 11g - WebGate is web server plug-in which intercepts user request and communicates to OAM Server. Both 10g WebGate and 11g WebGate can be used with OAM 11g . (If you are using Webgate 11g then all requests are protected by default and you should un-protect any public page.). To create WebGate11g instance you can use RREG
Note: Ensure that /analytics , /analytics/…/* , /xmlpserver , and /xmlpserver/…/* are protected resource in OAM
9. Install WebGate with OHS 11g (installed in step 2)
10. Configure OAM Identity asserter as provider in Weblogic Domain hosting OBIEE - Configure Identity Asserter for OAM as explained here
11. Configure Response (to return OAM_REMOTE_USER as header variable $user.userid ) in protected authenticated and authorisation policy in OAM.
12. Enable SSO in OBIEE (including logon URL, Logoff URL pointing to OAM server) using FMW Enterprise Manager Control as shown here
13. Test OBIEE Single Sign-On (SSO) integration using OAM - Access OBIEE url via HTTP Server, that should redirect user to OAM login page. After username/password it should take user straight to OBIEE URL.
Note: Steps mentioned in 9.2 of OBIEE Enterprise Deployment Guide are for OAM 10g and should not be used with 11g OAM.
Related Posts for Business Intelligence
- Oracle Business Intelligence Enterprise Edition Overview
- BIEE Installation on Linux (Business Intelligence Enterprise Edition)
- Oracle BI Publisher Cluster / HA
- Clustering Oracle Business Intelligence , BI Server, Presentation Services, Plug-In, Scheduler & Javahost
- OBIEE – Step by Step Installation
- User Management in OBIEE using BI Administration Tool
- Integrate Oracle BI Server with LDAP Server (OID – Oracle Internet Directory)
- Oracle BI Publisher Admin Console (xmlpserver) Login Issue : Administrator/Administrator
- How to install OBIEE on windows 7 (OBIEE Training)
- OBIEE 11g (11.1.1.3.0) Download & Installation
- OBIEE 11g Installation : High Level Steps
- Unable to login to OBIEE /Analytics after OID integration : %user% was authenticated but could not be located within the identity store
- Configure OBIEE 11g Client to connect to 11g RPD in online mode
- Integrate OBIEE 11g with OAM 11g for Single Sign-On in 13 steps






Good hands-on exercises (installation, patching, cloning), very experienced trainer worth every penny 
15 users commented in " Integrate OBIEE 11g with OAM 11g for Single Sign-On in 13 steps "
Follow-up comment rss or Leave a TrackbackHi Atul!
Can i use Microsoft Active directory instead of OID for user repository?
Regards, Jani
@Jani
Yes Active Directory can be used as User store for OBIEE11g integartion with OAM 11g.
You need to select and configure “ActiveDirectoryAuthenticator” in WLS and Configure AD as User store in OAM.
Thanks
Neha
Hi Atul,
I have done the integration of OAM 11g and OBIEE 11g following the steps u mentioned and the online document provided in oracle website .
But when I restart OBIEE Admin Server I am getting below error .Did you came up with issue .Please help .
<The realm “myrealm” failed to be loaded: weblogic.security.service.SecurityServiceException: com.bea.common.engine.ServiceInitializationException: java.lang.RuntimeException.
weblogic.security.service.SecurityServiceException: com.bea.common.engine.ServiceInitializationException: java.lang.RuntimeException
at weblogic.security.service.CSSWLSDelegateImpl.initializeServiceEngine(CSSWLSDelegateImpl.java:341)
at weblogic.security.service.CSSWLSDelegateImpl.initialize(CSSWLSDelegateImpl.java:220)
at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.InitializeServiceEngine(CommonSecurityServiceManagerDelegateImpl.java:1785)
at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initializeRealm(CommonSecurityServiceManagerDelegateImpl.java:442)
at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadRealm(CommonSecurityServiceManagerDelegateImpl.java:840)
Truncated. see log file for complete stacktrace
Caused By: com.bea.common.engine.ServiceInitializationException: java.lang.RuntimeException
at com.bea.common.engine.internal.ServiceEngineImpl.findOrStartService(ServiceEngineImpl.java:365)
at com.bea.common.engine.internal.ServiceEngineImpl.findOrStartService(ServiceEngineImpl.java:315)
at com.bea.common.engine.internal.ServiceEngineImpl.lookupService(ServiceEngineImpl.java:257)
at com.bea.common.engine.internal.ServicesImpl.getService(ServicesImpl.java:72)
at weblogic.security.service.internal.WLSIdentityServiceImpl.initialize(WLSIdentityServiceImpl.java:46)
Truncated. see log file for complete stacktrace
Caused By: java.lang.RuntimeException
at oracle.security.wls.oam.util.OAMUtil.(OAMUtil.java:172)
at oracle.security.wls.oam.providers.asserter.OAMIdentityAssertionProviderImpl.initialize(OAMIdentityAssertionProviderImpl.java:403)
at com.bea.common.security.internal.legacy.service.SecurityProviderImpl.init(SecurityProviderImpl.java:60)
at com.bea.common.engine.internal.ServiceEngineImpl.findOrStartService(ServiceEngineImpl.java:363)
at com.bea.common.engine.internal.ServiceEngineImpl.findOrStartService(ServiceEngineImpl.java:315)
Truncated. see log file for complete stacktrace
Caused By: java.lang.ArrayIndexOutOfBoundsException: 1
at oracle.security.wls.oam.util.OAMUtil.createServerEntry(OAMUtil.java:367)
at oracle.security.wls.oam.util.OAMUtil.createAAAClient(OAMUtil.java:252)
at oracle.security.wls.oam.util.OAMUtil.(OAMUtil.java:168)
at oracle.security.wls.oam.providers.asserter.OAMIdentityAssertionProviderImpl.initialize(OAMIdentityAssertionProviderImpl.java:403)
at com.bea.common.security.internal.legacy.service.SecurityProviderImpl.init(SecurityProviderImpl.java:60)
Truncated. see log file for complete stacktrace
>
Regards,
Babji
@ babji_007,
You said you used “online document provided in oracle website”
Which document you used ? Most of document as of today in OBIEE are for 10g OAM integration. Share Oracle Document you used so that I can verify.
Hi Atul,
Forgot to mention in my previous post .
Your post on OAM and OBIEE integration is really nice .
Thanks ,
Babji
Hi Atul,
Thank you .What I meant was in the post you have provided for OBIEE – OAM integration there are links to oracle website to configure authentication providers and OHS .For that I have used .
Remaining I have followed your post and bit of below url
http://docs.oracle.com/cd/E17904_01/core.1111/e10043/osso_b_oam11g.htm#BABBEBIH
Regards,
Babji .
@ Babji_007,
What is control flag JAAS flag ( More here http://onlineappsdba.com/index.php/2010/02/04/how-to-integrate-weblogic-with-oracle-internet-directory-for-login-authentication/ ) for OAM Identity Asserter Provider in myrealm security realm.
Do not set it to REQUIRED.
Hi Atul,
Thanks for that ,currently I have set it as “REQUIRED” ,I will make it “SUFFICIENT” or “OPTIONAL” ,but why in oracle website they have mentioned in that way any excerpts if you can ?.
Regards,
Babji
Hi Atul,
I have tried putting Authentication Providers in following order and flag .
OAM – SUFFICIENT
OID – SUFFICIENT
Default – SUFFICIENT .
But same error is being thrown .
Regards,
Babji
Hi Atul,
After setting the Provider order as mentioned in my previous post and updating the config file I was able to restart successfully .
But after restart ,post-authentication its going to OBIEE logout page .Seems there is issue with the header set .
Is the header that needs to be set for OID $user.uid or $user.userid and
is the logon url mandatory because we have configured our own login page which is deployed on OAM .
Regards,
Babji
@ Babji_007,
Did you run oamcfgtool.jar by any chance as shown in below doc
http://docs.oracle.com/cd/E21764_01/doc.1111/e15722/oid.htm#CIHGHBFA
Hi Atul,
Thanks ,initially I tried running oamcfgtool.jar but it was unable to connect to access server ,so have created all the oam configurations manually ,seems it doesnot work in oam 11g as the configuration are mentioned for oam 10g .
Regards,
Babji
@ Babji_007,
Yes oamcfgtool.jar is only for OAM 10g and should not be used with OAM 11g
Hi Atul!
There is the first step in the config of the OHS, where I can choose this:”Associate Selected component with weblogic domain”. Should I check this check-box? Or the OHS can work stand alone?
Regards, Jani
Hi Atul,
In which of these can I install OBIEE 11.1.1.5 (complete i mean server, database ….)
Windows 7 Home Premium
Windows 7 Professional
Windows 7 Ultimate
Regards
Prema
Leave A Reply