Download - Obiee Install Guide (Ldap)
![Page 1: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/1.jpg)
Install JDK (jrockit)
Execute the .bin directly
/apps/obiee/src/11.1.1.5]$ jrckit-jdk1.6.0_24-R28.1.3-4.0.1-linux-x64.bin
![Page 2: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/2.jpg)
![Page 3: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/3.jpg)
Ensure JAVA_HOME and Path are correct in .profile
PATH=/apps/obiee/JDK/bin:$PATH:$HOME/bin:.
export PATH
df
JAVA_HOME=/apps/obiee/JDK
export JAVA_HOME
Log out and log back in to pickup the java path changes
Install WLoraclebi[/apps/obiee/src/11.1.1.5]$ java -jar WL10.3.5.zip
![Page 4: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/4.jpg)
![Page 5: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/5.jpg)
![Page 6: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/6.jpg)
![Page 7: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/7.jpg)
![Page 8: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/8.jpg)
![Page 9: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/9.jpg)
Do not check “Run QuickChange”
Install OHShttp://download.oracle.com/docs/cd/E21764_01/doc.1111/e14260/toc.htm
oraclebi[/apps/obiee/src/11.1.1.5/ohs_install/Disk1/install/linux64]$ runInstaller
![Page 10: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/10.jpg)
![Page 11: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/11.jpg)
![Page 12: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/12.jpg)
![Page 13: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/13.jpg)
![Page 14: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/14.jpg)
![Page 15: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/15.jpg)
![Page 16: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/16.jpg)
Install OHS (patch)oraclebi[/apps/obiee/src/11.1.1.5/ohs-patch/Disk1]$ runInstaller
![Page 17: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/17.jpg)
![Page 18: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/18.jpg)
![Page 19: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/19.jpg)
![Page 20: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/20.jpg)
![Page 21: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/21.jpg)
![Page 22: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/22.jpg)
Install OBIEE (software only)
Configure OBIEE/apps/obiee/orapps/Oracle_BI1/bin/config.sh
![Page 23: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/23.jpg)
![Page 24: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/24.jpg)
![Page 25: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/25.jpg)
![Page 26: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/26.jpg)
![Page 27: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/27.jpg)
![Page 28: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/28.jpg)
![Page 29: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/29.jpg)
![Page 30: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/30.jpg)
![Page 31: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/31.jpg)
Add boot.properties
/apps/obiee/orapps/user_projects/domains/bifoundation_domain/servers/AdminServer/security
username=obisa
password={password]
![Page 32: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/32.jpg)
Configure OHS
Turn off web cache
![Page 33: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/33.jpg)
![Page 34: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/34.jpg)
![Page 35: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/35.jpg)
![Page 36: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/36.jpg)
![Page 37: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/37.jpg)
![Page 38: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/38.jpg)
![Page 39: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/39.jpg)
![Page 40: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/40.jpg)
Setup OHS to connect to weblogicOpen mod_wl_ohs_Configuration
![Page 41: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/41.jpg)
Add a new location
![Page 42: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/42.jpg)
/analytics
/analyticsRes
/ui
/xmlpserver
SSO IntegrationOpen WL Console
Add new OpenLDAP provider
Name it CDSN
![Page 43: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/43.jpg)
![Page 44: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/44.jpg)
Make it sufficient
![Page 45: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/45.jpg)
Update the provider specific tab
![Page 46: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/46.jpg)
Host:cdsn-dev.bankofamerica.com
Port:389
Principal:bofaUniqueID=hpsu,ou=service,ou=users,dc=bankofamerica,dc=com
User Base DN:ou=users,dc=bankofamerica,dc=com
Credential = (hpsu password)
![Page 47: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/47.jpg)
All Users Filter: bofaUniqueID=hpsu
User From Name Filter: uid=%u
User Search Scope:subtree
User Name Attribute:uid
User Object Class: bofaAuthenticate
Use Retrieved User Name as Principal: Checked
Group Base DN:ou=oracle,ou=applications,dc=bankofamerica,dc=com
All Groups Filter:uid
Group From Name Filter:(&(uniquemember=%g)(objectclass=groupofuniquenames))
Group Search Scope:onelevel
Group Membership Searching:limited
Max Group Membership Search Level:0
Ignore Duplicate Membership=unchecked
Static Group Name Attribute:uniquemember
Static Group Object Class:groupofuniquenames
Static Member DN Attribute:uniquemember
Static Group DNs from Member DN Filter:(&(uniquemember=%M)(objectclass=groupofuniquenames))
Dynamic groups
all null
General
defaults
GUID Attribute:bofaUniqueID
Save then activate changes
Open EM
Update the application roles, remove bisystem user
![Page 48: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/48.jpg)
Select Application Stripe = obi
Then edit BISystem Role
Remove BISystem User
![Page 49: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/49.jpg)
![Page 50: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/50.jpg)
![Page 51: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/51.jpg)
Update the identity store attributes
![Page 52: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/52.jpg)
![Page 53: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/53.jpg)
user.login.attr:uid
username.attr:uid
PROPERTY_ATTRIBUTE_MAPPING:GUID=bofaUniqueID
Update the credentials for the oracle.bi.system user
![Page 54: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/54.jpg)
![Page 55: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/55.jpg)
Go back to Console
Reorder the providers so that CDSN is first
![Page 56: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/56.jpg)
Update Default Authentication provider to sufficient
![Page 57: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/57.jpg)
Save and activate changes
Stop both the BI server and Admin server via console
Start the admin server via script (/apps/obiee/orapps/user_projects/domains/bifoundation_domain/ startWebLogic.sh&
Re-open console
Restart the managed server (bi_server1)
![Page 58: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/58.jpg)
Add our new system user (HPSU) to the global admin role
![Page 59: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/59.jpg)
Back to EM
Add the our new system user to the bisystem group (following screen shots have not been updated to reflect new domain name)
![Page 60: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/60.jpg)
![Page 61: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/61.jpg)
![Page 62: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/62.jpg)
Setup Siteminder Providerhttps://ssologon-stage.bankofamerica.com
https://ssologon-stage.bankofamerica.com/unauthorized/sso_logoff.html
![Page 63: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/63.jpg)
Install Skinscd /apps/obiee/orapps/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes
unzip /apps/obiee/src/skins/s_BOA.zip
unzip /apps/obiee/src/skins/sk_BOA.zip
unzip /apps/obiee/src/skins/customMessages.zip
(if needed update the compant name Enterprise BI & Analytics )
Deploy the analyticsRes directory as an application
![Page 64: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/64.jpg)
![Page 65: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/65.jpg)
![Page 66: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/66.jpg)
![Page 67: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/67.jpg)
![Page 68: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/68.jpg)
save and activate changes
Start the application
![Page 69: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/69.jpg)
Shut everything down
OPMN
Managed server (bi_server1)
Admin server
![Page 70: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/70.jpg)
Update NQSCONFIGUdate Cache
To upgrade guids (if moving catalog from one evn to another) add the following and bounce BI service… be sure to set it back to “NO” and bounce again……
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;
Update InstanceConfig Add the following to the <ServerInstance> section
<!-- EBIA/JGS 2011.04.21 Added Default skin and style setting --><URL> <CustomerResourcePhysicalPath>/apps/obiee/orapps/Middleware/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes</CustomerResourcePhysicalPath> <CustomerResourceVirtualPath>/analyticsRes</CustomerResourceVirtualPath></URL><UI> <DefaultSkin>BOA</DefaultSkin> <DefaultStyle>BOA</DefaultStyle></UI>
Add the following to the <Views><Pivot> section <!--EBIA/JGS Updated DefaultRowsDisplayedInDownload>2500--> <DefaultRowsDisplayedInDownload>50000</DefaultRowsDisplayedInDownload>
<!-- EBIA/JGS 2011.06.14 Begin Changes to pivot governors --><MaxVisibleColumns>1000</MaxVisibleColumns><MaxVisiblePages>1000</MaxVisiblePages><MaxVisibleRows>100000</MaxVisibleRows><MaxVisibleSections>1000</MaxVisibleSections><DefaultRowsDisplayed>30</DefaultRowsDisplayed><!-- EBIA/JGS 2011.06.14 End Changes to pivot governors -->
Add the following to the <Views><Table> section <!--EBIA/JGS Updated DefaultRowsDisplayedInDownload>2500 --> <DefaultRowsDisplayedInDownload>50000</DefaultRowsDisplayedInDownload> <!-- EBIA/JGS 2011.06.14 Begin Changes to table governors -->
<MaxVisiblePages>1000</MaxVisiblePages><MaxVisibleRows>100000</MaxVisibleRows><MaxVisibleSections>1000</MaxVisibleSections><DefaultRowsDisplayed>30</DefaultRowsDisplayed><!-- EBIA/JGS 2011.06.14 End Changes to table governors -->*note: DefaultRowsDisplayedInDownload is an existing setting, delete the existing line before adding these.Add a <Charts> section to <Views> <!-- EBIA/JGS 2011.04.01 - Added slider default and slider limit option --><Charts><SectionSliderDefault>15</SectionSliderDefault><SectionSliderLimit>30</SectionSliderLimit></Charts>
![Page 71: Obiee Install Guide (Ldap)](https://reader038.vdocuments.us/reader038/viewer/2022102518/544d6891b1af9fc5378b461a/html5/thumbnails/71.jpg)
Copy RPDCopy WebcatCopy ODBC.INICOPY tnsnames.oraAdd users / Update Security