Tuesday, July 1, 2014

Installation and Configurations of OBIA 11.1.1.7.1

Prerequisites to install 11.1.1.7.1 :
  1. Oracle Business Intelligence 11.1.1.7.0 if you are on 11.1.1.6.X upgrade your environment to 11.1.1.7.0 by following this link
  2. Oracle Business Intelligence Enterprise Edition when you install directly 11.1.1.7.0 in Software Only Install mode requires WebLogic Server 10.3.6 as a prerequisite where as Enterprise Install mode installs WebLogic Server 10.3.5. You must upgrade to WebLogic Server 10.3.6 after installation of Oracle BI Applications is complete.
  3. Oracle Data Integrator 11.1.1.7.0
  4. Oracle SOA (required only for Indirect Spend Planning).
  5. Create schemas for Oracle BI Applications and Indirect Spend Planning                    5.a) In this step you run the Business Analytics Applications Suite Repository Creation Utility (RCU) to create the necessary schemas for Oracle BI Applications and Indirect Spend Planning.
  6.  Apply Fusion Middleware Platform Patches.
  7.    Configure Oracle Business Intelligence when you install 11.1.1.7.0 as software mode (step2)
  8. Configure BI Applications and Indirect Spend Planning
  9.  Apply post-installation patches.
  10.   Perform system setup tasks. 
Go to below URL, download relevant JDK and install it.
http://www.oracle.com/technetwork/java/javase/downloads/index.html

Oracle BI Applications requires WebLogic Server 11g Release 1 (10.3.6).
To install WebLogic server open cmd/terminal, go to the directory where you have downloaded generic version of WebLogic and enter command as below

Follow the steps Next,Next on the screen and don't configure weblogic at this time just hit Finsh when you are done
2) Now Install RCU which you downloaded for 11.1.1.7.0 (if you are doing fresh installation) otherwise you can ignore it when you upgraded from 11.1.1.6.X to 11.1.1.7.0
3) Oracle BI Applications requires an installation of Oracle Business Intelligence Enterprise Edition 11g deployed on WebLogic Server 10.3.6. WebLogic Server 10.3.5 is not supported  install 11.1.1.7.0  as shown below


Select software only install if you have already installed WebLogic 10.3.6 or later give the path where webLogic is already installed, then next, next and press install


Once it is installed now install ODI 11g 


In the selection type select All we need everything to ODI Studio and Agents in the next screen make sure that you select Middleware location where 11.1.1.7.0 is installed and ODI home looks like 'Oracle_ODI1' you can skip the Repository Configuration step give some Agent name and port number which is not in use by OBI.

At the end you should see ODI configuration is successful


So far  we completed Installing/upgrading our environment to 11.1.1.7.0  and  ODI 11g

 Lets start with step of creating Business Analytics Warehouse schema requires of OBIA Repositories 
When you install Business Analytic Warehouse (RCU) it installs below schema

Ø  Business Analytic Warehouse :Repository which supports the different source systems(eBs,PPSF,Siebel) this schema can be installed on Oracle Database
Ø  Business Intelligence Applications Components Repository (BIACOMP) :
All the configuration settings supported by functional manager and Configuration setup manager like Load plans, Mappings ,Domain files config, source files information ...
Ø  Load Plan Generator  : Jar files supported for ODI Repository for loads (kind of hibernate files in DAC)
Ø  ATGLite - This component is a J2EE component used by Oracle BI Applications Configuration Manager and Functional Setup Manager.

Components Deployed Into Managed Server "odi_server1"

ODI Studio - This component enables you to control and monitor ETL.
ODI Agent - Java EE Agent, which handles schedules the interfaces/package/scenarios in ODI

It's a best practice to have separate database for Business Analytic Warehouse (OLAP) and source system (OLTP) don't install both on same database you must create database instances to hold the following:
Business Analytics Warehouse schema
  • Oracle BI Applications Components Repository (for Configuration Manager and Functional Setup Manager)
  • ODI Repository for Oracle BI Applications (includes Master and Work repositories)
Double click on rcu.bat(\11_1_1_7_BI\Bus_Analytics_Apps_Suite_RCU_Win64\bin\rcu.bat) file from the file you downloaded(Bus_Analytics_Apps_Suite_RCU_Win64) 

Click on Create then enter your DB credentials and select the components as shown below


  • Select Oracle Operation Planning if you want to configure (Indirect Spend Planning)
  • Enter your schema password (Remember it we need those credentials in another section)
  • The RCU uses .dmp files to create the required schemas. Before you perform the action in the Custom Variables screen, you must copy the .dmp files for each schema to a directory with global write access on the appropriate database server host machine. (RCU writes log files to this directory). The .dmp files are located in BIA_RCU_HOME\rcu\integration\biapps\schema. I have copied those files to my App folder (DB install directory)

Select the table space it should have more space to install all the .dmp files for each schema it is recommended to have more than 15 GB (future purpose) and click on Create it takes some time (around 30 mins)


Click on Create it creates necessary work repository and BI Apps schemas as shown below you can check the log file.


Business Analytics Applications installation as  shown below:


Installation location is same as where we installed 11.1.1.7.0 (D:\11g\Oracle_BI1) next, and hit Install it takes around 30 mins to complete depending on your system configuration

Configuring Oracle Business Intelligence You can configure the BI Domain by running the config.bat or config.sh file(\BI11g\Oracle_BI1\bin\config.bat). You need to perform this procedure if you installed Oracle BI EE in Software Only Install mode.
Note:If you installed Oracle BI EE in Enterprise Install mode in the first step, you do not have to perform this procedure.

Installing Fusion Middleware Patches :

http://download.oracle.com/otn/nt/bi/111171/BI_Apps_11.1.1.7.1_generic_part_1of2.zip
http://download.oracle.com/otn/nt/bi/111171/BI_Apps_11.1.1.7.1_generic_part_2of2.zip
http://download.oracle.com/otn/nt/bi/111171/BI_Apss_11.1.1.7.1_win64.zip


Once patches are installed we are all set to start our OBI Apps using ODI ! hold on, still we need to configure ConfigApps.bat (\BI11g\Oracle_BI1\bin\configApps.bat) which is used to create ODI managed server , Oracle configuration Manager,Oracle Functional Manager used to configure the parameters for the loads  

Step 1 : 

Step 2: 



Step 3: Specify the location where you installed OBIEE  11.1.1.7.1(Apps) and select components 


Step 4 : RPD Encryption password used to open your BIApps rpd 


Step 5 :  BI administrator password used to login ODI Studio make sure you remember it otherwise you can not login to ODI Studio



Step 6 : Give the schema locations for BI Application component,BAW, BI ODI repo & MDS Schema 
DEV_BICOMP SCHEMA DETAILS:


DEV_DW SCHEMA DETAILS:


DEV_BIA_ODIREPO SCHEMA


Step 7 : Click on Configure to start your configuration of Bi Apps it took 2 hr 30mins to complete it because of some configuration issues while restarting odi_server1 (make sure you have started Node Manager) other the odi_server1 restarting is going to fail 

Generating Security Files for ODI Studio

The ODI Repository is configured for external authentication against WebLogic Server's embedded LDAP server. System administrators must generate the appropriate security files for authentication as specified below, and provide these to developers who have installed ODI Studio on their machines.

run this command  :

middleware\Oracle_BI1\common\bin>wlst.cmd \middleware\Oracle_BI1\bifoundation\install\createJPSArtifactsODI.py embedded --ADMIN_USER_NAME weblogic --DOMAIN_HOSTNAME lenovo-pc --DOMAIN_PORT 7001 --DOMAIN_HOME_PATH \middleware\user_projects\domains\bifoundation_domain



  1. Copy cwallet.sso and jps-config-jse.xml from:

    <MW_Home>/user_projects/domains/bifoundation_domain/odi-client-config/embedded
    
    To:
    <ODI_Home>/oracledi/client/odi/bin
    
  2. Edit <ODI_Home>/oracledi/client/odi/bin/odi.conf by updating the JPS configuration file name as follows:
    AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml

Applying the ATGLite Patch

ATGLite is a J2EE component used by Oracle BI Applications Configuration Manager and Functional Setup Manager . Stop all the services related to Business Intelligence components and execute the below script as shown below  

Log into ODI by entering following details as shown below  where user and password is from the screen where we configured configapps.bat (BI Administrator)
  1. Copying Source Files

    During installation of Oracle BI Applications, source files are installed in the BI_Oracle_Home/biapps/etl directory.

    To copy source files:
    1. Navigate to the BI_Oracle_Home/biapps/etl directory.
    2. Copy all files under the BI_Oracle_Home/biapps/etl directory into a location that ODI Agent deployed in WebLogic Server can access but is outside of the Oracle Home for BI directory.
      Setting the Business Analytics Warehouse Connection in ODI
      Use ODI Studio to set the connection properties in the ODI Repository of the physical schema associated with the 'BIAPPS_DW_FILE' physical server.
      To set the Business Analytics Warehouse physical schema connection in ODI:
      1. Log into ODI Studio using the BI Applications Administrator credentials.
      2. In the navigation pane, go to Topology, and expand Technologies, and then expand File.
      3. Double-click BIAPPS_DW_FILE.



      Now login to ODI Designer you should see BIApps Project and Models(Sources)

      Loginto configuration manager with the same credentials you used to login for ODI(weblogic)


      This completes our complete installation and configuration of BIApps 11.1.1.7.1 on 64-bit