OBIEE ODI INFORMATICA OBIA INSTALLATION

OBIEE 12C Installation

STEP 1 : Microsoft Loop Back Adatptor

STEP 2 :  Oracle Database 11G

STEP 3 :  JDK

STEP 4 :  Web Logic Server Installation
STEP 5  : OBIEE 12C Installation
STEP 6  : OBIEE 12C Configuration

OBIA 11.1.1.8.1 Installation

STEP 1 : http://rritec.blogspot.in/2014/09/01-installing-microsoft-loop-back.html

STEP 2 : http://rritec.blogspot.in/2014/09/02-oracle-database-installation.html

STEP 3: http://rritec.blogspot.in/2014/09/03-obiee-rcu.html

STEP 4 : http://rritec.blogspot.in/2014/09/04-obiee-11g-installation.html

STEP 5: http://rritec.blogspot.in/2014/09/05-upgrade-weblogic-server-105-to-106.html

STEP 6: http://rritec.blogspot.in/2014/09/06-odi-11g-installation.html

STEP 7: http://rritec.blogspot.in/2014/09/07-obia-rcu.html

STEP 8: http://rritec.blogspot.in/2014/09/08-obia-installation.html

STEP 9: http://rritec.blogspot.in/2014/09/09-obia-patch-updates.html

STEP 10: http://rritec.blogspot.in/2014/09/11-configuration-of-obia.html

11 Configuration of OBIA

Configuration of OBIA

1. Go to path C:\OBIEE_HOME\Oracle_BI1\bin → Double click on configapps

2. Click on NEXT

3. Click on NEXT

4. Provide password as RRitec123 → Click on NEXT

5. Observe all parameters → you can not modify any parameters → click on NEXT

6. Select BI Application Components → Click on NEXT

7. Provide RPD password as RRitec123 →  Click on NEXT

8. Provides username as biapps password as RRitec123
   

   

   Provide below details → Click on NEXT 

9. Provide below Details → Click on NEXT

10. Provide below Details → Click on NEXT

11. Provide below Details → Click on NEXT

12. Select Auto Port Configuration → Click on NEXT

13. Click on Continue

14. 

15. To synchronize the security between ODI Studio and the Weblogic server
16. Copy the files cwallet.sso and jps-config-jse.xml from C:\OBIEE_HOME\user_projects\domains\bifoundation_domain\odi-client-config\embedded to C:\OBIEE_HOME\Oracle_ODI1\oracledi\client\odi\bin
17. 
18. Now edit the file <ODI_Home>/oracledi/client/odi/bin/odi.conf
19. 
20. Locate the line AddVMOption -Doracle.security.jps.config=./jps-config.xml   
21. Modify as shown below

IncludeConfFile ../../ide/bin/ide.conf AddVMOption -XX:MaxPermSize=256M AddVMOption -Doracle.core.ojdl.logging.config.file=ODI-logging-config.xml AddVMOption -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger AddVMOption -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration AddJavaLibFile ../../../../oracledi.sdk/lib/ojdl.jar AddJavaLibFile ../../../../oracledi.sdk/lib/dms.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/log4j-1.2.8.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odi_hfm.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odihapp_common.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/ess_es_server.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/ess_japi.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odihapp_essbase.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odihapp_planning.jar AddVMOption -Dnative.canonicalization=false AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml AddVMOption -Doracle.odi.studio.ess=false AddVMOption -Dide.AssertCheckingDisabled=true AddVMOption -Dide.AssertTracingDisabled=true AddVMOption -DLOG_FILE=studio.log AddVMOption -Dsun.java2d.noddraw=true SetJavaHome C:\OBIEE_HOME\Oracle_BI1\jdk

23. save → Close

Load Plan Generator Plug-in

24. The load plan generator plug-in for ODI is supplied in a zip file and it is used by BIACM
25. Copy and  paste  the file from the location C:\OBIEE_HOME\Oracle_BI1\clients\biappsclients\odi to C:\OBIEE_HOME\Oracle_ODI1\oracledi\client\ide\extensions

26. Unzip the file OBIA_LPG_PLUGIN
27. 
28. ll

Login to ODI

29. Make sure weblogic server is running
30. open ODI studio
31. click on connect to repository
32. click on new connection
33. provide below details
34. 
35. Click on OK
36. 
37. Again ok
38. In previous step we extracted load plan generator ZIP file because of that we got below plugin
39. 
40. Now we can see all predefined interfaces of SDE SIL and PLP
41. 
42. Copy Boot file from C:\OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\bi_server1\security to C:\OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\odi_server1\security
43. Enjoy :)

09 OBIA PATCH UPDATES

1. Make sure all servers like weblogic ,Node manager ,opmnctl ..etc are stopped
2. if you are not sure how to stop all restart your PC
3. Navigate to path C:\OBIEE_HOME\Oracle_BI1\biapps\tools\bin → open apply_patches_import file

4. Modify all parameters as shown below
   

# Required JAVA_HOME - Java home JAVA_HOME=C:\OBIEE_HOME\Oracle_BI1\jdk # Required INVENTORY_LOC - Inventory Location INVENTORY_LOC=C:\Program Files\Oracle\Inventory ORACLE_HOME=C:\OBIEE_HOME\Oracle_BI1 MW_HOME=C:\OBIEE_HOME COMMON_ORACLE_HOME=C:\OBIEE_HOME\oracle_common WL_HOME=C:\OBIEE_HOME\wlserver_10.3 ODI_HOME=C:\OBIEE_HOME\Oracle_ODI1 SKIP_BITECH_PATCHES=false # Optionally Required WINDOWS_UNZIP_TOOL_EXE - If platform is windows, then specify unzip tool exe with complete path # Currently only two tools : Winzip command line and 7-Zip command line are supported tools. # Eg for Winzip tool - c:{PathSep}Program Files{PathSep}WinZip{PathSep}wzunzip.exe # Eg for 7-Zip tool - c:{PathSep}Program Files{PathSep}7-Zip{PathSep}7z.exe WINDOWS_UNZIP_TOOL_EXE=C:\Program Files\7-Zip\7z.exe # Required WORKDIR - An existing writable directory to create logs and temp patch files WORKDIR=C:\TEMP # Required PATCH_ROOT_DIR - Path of patch directory till the release patch-set folder which is inside patches4fa/dist. # i;e the patch-set folder for a particular release to apply patch from # eg; /scratch/aime/tmp/ps1/biappsshiphome/patches4fa/dist/ps6rc3 PATCH_ROOT_DIR=C:\OBIAPATCH

5. Open command prompt window → execute below perl script

6. It should apply all patches successfully
7. Due to my bad :( for me weblogic patches are failed .

8. So i went to log file and noticed it is not able to backup jar file

9. After some research i noticed the problem is because of beasvc .exe file → i killed from task manager and ran same perl script → it skipped all successful patches and installed previous patches

10. UPDATE ATGLITE PATCH → by running below command in command prompt

C:\OBIEE_HOME\Oracle_BI1\jdk\bin\java -jar C:\OBIEE_HOME\Oracle_BI1\biapps\tools\lib\biappsrepositoryutil.jar upgradeATG bi.oracle.home=C:\OBIEE_HOME\Oracle_BI1 work.dir=C:\TEMP\ATG biacomp.user=DEV_BIACOMP biacomp.password=RRitec123 db.conn.sid.url=localhost:1521:orcl atg.db.seed.url=localhost:1521/orcl db.sys.user=sys db.sys.password=RRitec123

11. UPDATE FSM LITE

C:\OBIEE_HOME\Oracle_BI1\jdk\bin\java -jar C:\OBIEE_HOME\Oracle_BI1\biapps\tools\lib\biappsrepositoryutil.jar upgradeFSM bi.oracle.home=C:\OBIEE_HOME\Oracle_BI1 work.dir=C:\TEMP\ATG biacomp.user=DEV_BIACOMP biacomp.password=RRitec123 db.conn.sid.url=localhost:1521:orcl fsm.db.seed.url=localhost:1521/orcl db.sys.user=sys db.sys.password=RRitec123

12.