Configuring BIAPPS 11.8 and ODI for Fusion applications

CONFIGURING BIAPPS 11.8 For FUSION APPLICATIONS 

As in this part we are going to configure the Bi apps and the ODI .. we need to extend the existing the bi domain for the configuration of the biapps

Step 1 Starting the Configuration

Start the configuration from the  by invoking the configapps.sh 

 

Step 2  Prerequisite Check

Check all the prerequisites are completed successfully

Step 3 Extending the Domain

As we have installed the ODI and BIapps in the same middle ware home where the BI had been installed we need to extend the weblogic Domain to add the new managed server for the ODI
Host name  :     Middle ware Host name where the Bi had been installed
Port            :     BI Weblogic Port Number
User Name  :    Weblogic_super_user_name
User Password  Weblogic Password Name

Step  4 Details of the BI Domain
We need to specify the path's and details of the Bi Domain
Middle ware Home : The Middle where home where the BI,BIAPPS,ODI are installed
Oracle Home          :BI Oracle Home
Weblogic Server Home : MW_Home/wlsserver_10.3
Domain_Home               :BI Domain Home
Instance Home               :BI Instance home
Instance Name               :Bi Instance Name

Step 5 :=Details of configuration components

Check the Oracle Business Intelligence Applications and Bi applications components

Step 6 :=RPD Password 
Provide the RPD Password which will be used to open the RPD in the bi admin toll later while mapping and developing the subject area's

Step 7 := Admin user Name Password 

Provide the Admin User Name Password

Step 8 :=MDS schema Details 
Database Type       :Oracle database
Connect String        :Hostnameod dw database :port number:<data ware house service name>
MDS Schema Username : User_ending with the MDS which is created by BI apps RCU
MDS Schema Password  :password for MDS Schema

Step 9 := BIACOMP user details 
Database Type :=Oracle database
Connect String :=Data ware House DB Host name: DB port:DB service
ODI Repository Schema Username:=User created by the ODI RCU ending with BIACOMP
BIA Components Repository Schema Schema Password: Password for biacomp

Step 10 BI analytic schema

Database Type :=Oracle database
Connect String :=Data ware House DB Host name: DB port:DB service
Business Analytic Ware House Schema Username:= user ending with the DW create by the RCU
Business analytic warehouse Schema Password :=  password for the user _DW

Step 11 Bi applications ODI
Database Type :=Oracle database
Connect String :=Data ware House DB Host name: DB port:DB service
ODI Repository Schema Username :=User name end with BIA_OIDREPO
ODI Repository Schema Password  : -password for the BIA_OIDREPO

Step 12 Port Configuration
We had select the auto port to go with the default port values .. if you had specified the custom port values during the installation of software .. then use the same staticport.ini file for defining the ports

Step 13 Summary Page 

Step 14 Configuration Process 

Step 15 Complete the Configuration 

Note: On success full  completion of the configuration Start the Node manager ,admin server and the two admin server's one for BI and another for ODI

ODI and BIAPPS Installation for BIAPPS 11.8

ORACLE DATA INTEGRATOR AND BI APPLICATIONS[11.8] INSTALLATION [part 4] 

In This practice [part 4] we go through the  steps for installing the ODI and BIAPPS binaries and once we apply the required patches we will go through the configuration steps in next part

Step 1
When you start the Installer the installer will Prompt  for the jdk location we need to specify the jdk location of the BI
Start the Installer an click the next page to Proceed

Step 2 Software updates 

Skip software Updates and Proceed for Next Page

Step 3 selecting the install products 
Select the Product for the installation
 we need to select the ODI studio,ODI SDK ,java EE Installation Java EE Agent,ODI console,Public Web service

Step 4 Prerequisite checking

Once all the Prerequisite's are completed then go with the next step

Step 5 MW_HOME Selection

Oracle Middle ware Home := provide the existing oracle MW_Home which is used for the BI installation
Oracle Home Directory      :=Oracle_OID1[it will be create in the MW_HOME]

Step 6 Choosing the application server

ODI can be installed in web logic or WebSphere since we had installed the BI on weblogic we need to install the ODI in the weblogic as we are going to extend the existing domain for ODI

Step 7 repository configuration 

Skip the ODI configuration we can configure after all the Patches had been applied

Step 8 installation summary 
Check the Installation Summary

Step 10 Configure Progress

Once the Installation process completes and  the configuration process starts..
The configuration Process Finishes successfully then we can go the next Page

Step 11 Install complete 

Save the config file for further reference and finish to complete the installation

INSTALLING BIAPPS 11.8

Download the BI Apps binaries from the oracle site and unzip in the temporary folder and Navigate to Disk1 and start the runinstaller 

Step 1

Run the installer and provide the jdk location  when it is asked 

Step 2 click next to proceed with the installation 

Step 3 Prerequisite checks 

Once all the requisite checks had been successful then proceed to next step

Step 4 MW_HOME and ORACLE_HOME location

Oracle Middle ware Home := [Provide the Middle ware Home Location where the BI Had been installed]
Oracle Home Directory      :=Provide the BI[OBIEE] oracle home

Step 5:=Check the summary page

check the summary page and save the summary file for further reference

Step 6 Installation IN Progress

Once the installation completes click next to proceed

Step 6

Save the Repository file for further reference and click finish

APPLYING PATCHES FUSION MIDDLE WARE ARTIFACTS FOR BIAPPS 11.8


Step 1
unzip all the patches in the directory and modify the  apply_patches_import.txt  file with the necessary changes MW_HOME/Oracle_BI1/biapps/tools/bin/

[orabi@biapp bin]$ cat /u02/app/oracle/fmw/Oracle_BI1/biapps/tools/bin/apply_patches_import.txt
# Required JAVA_HOME - Java home
JAVA_HOME=/u02/app/oracle/fmw/Oracle_BI1/jdk
# Required INVENTORY_LOC - Inventory Location
INVENTORY_LOC=/u01/app/oracle/oraInventory
ORACLE_HOME=/u02/app/oracle/fmw/Oracle_BI1
MW_HOME=/u02/app/oracle/fmw
COMMON_ORACLE_HOME=/u02/app/oracle/fmw/oracle_common
WL_HOME=/u02/app/=oracle/fmw/wlserver_10.3
SOA_HOME=
ODI_HOME=/u02/app/oracle/fmw/Oracle_ODI1
SKIP_BITECH_PATCHES=false

WORKDIR=/home/orabi/Patch/log

PATCH_ROOT_DIR=/home/orabi/Patch

Legends

JAVA_HOME:=Provide the value of the OBIEE java Home the java located inside the bi oracle home

INVENTORY_LOC:=Provide the central inventory Location 

ORACLE_HOME:=Provide the Location of the Bi oracle Home

MW_HOME:=Provide the Location of the Middle ware Home 

COMMON_ORACLE_HOME:=Provide the location of oracle_common directory which resides in MW_HOME

WL_HOME:=Provide the Location of the Weblogic Home

ODI_HOME:=Provide the Location of the ODI home

WORKDIR:=Create the Directory with read and write permission for the BI /Os user to create the log file

PATCH_ROOT_DIR:=Directory where the patch are  unzipped 

Step 2
Run the APPLY_PATCHES.pl  from the MW_HOME/Oracle_BI1/biapps/tools/bin with the
MW_HOME/Oracle_BI1/biapps/tools/bin/apply_patches_import.txt

[orabi@biapp bin]$ perl /u02/app/oracle/fmw/Oracle_BI1/biapps/tools/bin/APPLY_PATCHES.pl /u02/app/oracle/fmw/Oracle_BI1/biapps/tools/bin/apply_patches_import.txt

----------START OF PATCHING REPORT------------------

Current PLATFORM Detected :linuxx8664

* BIAPPSSHIPHOME Patching Report ..........
Patch Succeded: fsmlitedb_rel8pmlr2_17937188.zip
Patch Succeded: p17463314_111170_Generic.zip
Patch Succeded: fsmlite_rel8pmlr2_18529692.zip
Patch Succeded: p16913445_111170_Generic.zip
Patch Succeded: fsclite_rel8pmlr2_17937189.zip
Patch Succeded: p17463403_111170_Generic.zip
Patch Succeded: p17300045_111170_Generic.zip
Patch Succeded: p16997936_111170_Generic.zip
Patch Succeded: atglite_rel8mlr12_17657541.zip
Patch Succeded: atglite_rel8mlr11_database_17533000.zip
Patch Succeded: BIFNDNEPM_11_1_1_7_0OBIEEBP_LINUX_X64_130816_0640_17314326.zip
Patch Succeded: BISERVER_11_1_1_7_0OBIEEBP_LINUX_X64_130919_2217_17463395.zip
Patch Succeded: BIFNDN_11_1_1_7_0OBIEEBP_LINUX_X64_131008_1224_5_17463376.zip
Patch Succeded: p16569379_111170_Linux-x86-64.zip

* Oracle Common Patching Report ..........
Patch Succeded: EM_p14670290_111170_Generic.zip
Patch Succeded: WebCenter_BP8REL8_2_17483105.zip
Patch Succeded: p16433036_111170_Generic.zip
Patch Succeded: JDEVADF_REL8MLR9-RT_17611288.zip
Patch Succeded: idmpatch-1309a-ps6-17440204-urapi.zip
Patch Succeded: fmw_diagnostics_17714493.zip
Patch Succeded: idmpatch-1310a-ps6-17447428-owsmrel8.zip
Patch Succeded: SOACOMMON_REL8B7_17549390.zip
Patch Succeded: J2EE_Patch-3-PS6RC3_bug-17237952.zip
Patch Succeded: Webservices_Patch-2-PS6REL8_bug-17629596.zip
Patch Succeded: p16080773_111170_Generic.zip
Patch Succeded: p16830801_111170_Generic.zip
Patch Succeded: appstrace_17363039.zip
Patch Succeded: T2P_FW_REL8_Patch2_17353546.zip
Patch Succeded: p16433147_111170_Generic.zip
Patch Succeded: idmpatch-1311a-ps6-17665823-opss.zip

* SOA Patching Report ..........
 Not applying SOA Patches since SOA Home (SOA_HOME) value is not specified

* ODI Patching Report ..........
Patch Succeded: p18204886_111170_Generic.zip

* Weblogic Patching Report ..........
Successfully installed Patch ID:  2GH7
Successfully installed Patch ID:  W3Q6
Successfully installed Patch ID:  RJNF
Successfully installed Patch ID:  FKGW
Successfully installed Patch ID:  JEJW
Successfully installed Patch ID:  LJVB
Successfully installed Patch ID:  IHFB
Successfully installed Patch ID:  6AEJ
Successfully installed Patch ID:  EAS7
Successfully installed Patch ID:  TN4A
Successfully installed Patch ID:  KPFJ

----------END OF PATCHING REPORT------------------

This final patching report log file is also located at: /home/orabi/Patch/log/final_patching_report.log


Check the Log files for the Each location
[1]check the  biappshiphome_generic_patches.log and verify Patches had Been applied
Verifying the update...
Patches 16913445,16997936,17300045,17463314,17463403,17533000,17657541,17937188,17937189,18529692 successfully applied.
Log file location: /u02/app/oracle/fmw/Oracle_BI1/cfgtoollogs/opatch/opatch2014-07-13_17-20-50PM_1.log
OPatch succeeded.

[2]Check biappshiphome_linux64_patches.log as we are using the Linux 64x84 

Verifying the update...

Patches 16569379,17314326,17463376,17463395 successfully applied.

Log file location: /u02/app/oracle/fmw/Oracle_BI1/cfgtoollogs/opatch/opatch2014-07-13_17-29-05PM_1.log

OPatch succeeded.

[3] Check the odi_generic_patches.log 

Verifying the update...

Patches 18204886 successfully applied.

Log file location: /u02/app/oracle/fmw/Oracle_ODI1/cfgtoollogs/opatch/opatch2014-07-13_17-40-39PM_1.log

OPatch succeeded.

[4]Check the oracle_common_generic_patches.log

Verifying the update...

Patches 14670290,16080773,16433036,16433147,16830801,17237952,17353546,17363039,17440204,17447428,17483105,17549390,17611288,17629596,17665823,17714493 successfully applied.

Log file location: /u02/app/oracle/fmw/oracle_common/cfgtoollogs/opatch/opatch2014-07-13_17-37-25PM_1.log

OPatch succeeded.

[5] cat weblogic_patching.log

Identifying patches that may be installed ...

Installable patches:[2GH7, RJNF, FKGW, JEJW, LJVB, IHFB, 6AEJ, EAS7, W3Q6, TN4A, KPFJ]

Identifying patches that may be removed ...

Remove candidates: [GFWZ, ITL9, P9A6, H2FT, 6D9T, TWDG, GVYL, 7AAZ, 9BPB, LYRQ, SRUM, TZFH, TL3Y, 99BQ, LWLH, HYKC, Z8MQ, 91SX, A1DL, S39F, I3HZ, AW1V, 3DM4, 81X7, 4GG5, 3BBT, 7YZB, IUZI, 7BG3, 956R, 9887, S76X, 6X2J, 4GPI, GKQW, 6V9V, IH4D, QKPF, HS7H, XA6W, 8JYQ, U1RB, 2277, ZR38, 27QC, S4BN, 81QF, YJI2, EUW3, 7YU1, YHFH, RFP7, 16ZR, 61K2, 9T2G, ZPB8, 1IHE, WYRU, ALFS, CHEE, JG58, 56MM, HW5A, SFAZ, GP9A, F89C, G72F, EG2S, FL81, SZXM, QEUF, ANVN, KIGI, 1PI6, RNQP, BS5P, W4F6, CM69, Q1UZ, UDN7, F6G7, 7WVY, JZED, E9FL, RPI1, 9264, SKLY, B8V1, 9I9D, MYFD, F31P, BCSD, XLVS, FFRX, BADF, K1J3, 2NUX, RIPQ, CLLX, 1NRR, XIJ8, QK63, JLJ6, RUNT, AI76, 4SYF, V41Y, XLUK, YJTB, 72TK, MB4Y, Z4W7, EF1X, BEJG, BJY4, 879N, 546H]

Removable patches:[]

Installing patches ...

Patches to be installed in following order: [2GH7, W3Q6, RJNF, FKGW, JEJW, LJVB, IHFB, 6AEJ, EAS7, TN4A, KPFJ]

Installing patch: KPFJ

Sun Jul 13 18:06:11 GST 2014: Executing command:

  /u02/app/oracle/fmw/Oracle_BI1/jdk/jre/bin/java

  -Duser.country=US

  -Duser.language=en

  -jar

  /u02/app/oracle/fmw/utils/bsu/patch-client.jar

  -prod_dir=/u02/app/oracle/fmw/wlserver_10.3

  -install

  -patchlist=KPFJ

  -log=/tmp/bsu-wrapper-logs/bsu-wrapper-2014.07.13.17.41.10.log

  -log_priority=debug

Checking for conflicts...

No conflict(s) detected

Installing Patch ID: KPFJ.

Result: Success

Once the Patching Process complete's  Successfully start the Node manage and Weblogic server through wls script

ATGLITE Upgrade
Run the below command to upgrade the ATG
[orabi@biapp lib]$ /u02/app/oracle/fmw/Oracle_BI1/jdk/bin/java -jar  biappsrepositoryutil.jar upgradeATG bi.oracle.home=/u02/app/oracle/fmw/Oracle_BI1/ work.dir=/home/orabi/Patch/log biacomp.user=BIAPPS_BIACOMP  biacomp.password=OMsys123 db.conn.sid.url=<hostname>:1521:<SID> atg.db.seed.url=<hostname>:1521/<service_name> db.sys.user=SYS db.sys.password=<passowrd>

Jul 13 2014 19:58:07 INFO : Connecting to database: user:SYS as sysdba, connectString:jdbc:oracle:thin:SYS as sysdba/*****@<hostname>:1521:biapp

Jul 13 2014 19:58:07 INFO : Finished   ATGSeedDataUpgradeTask execution.

Jul 13 2014 19:58:07 INFO : Completed upgrade task: ATGSeedDataUpgradeTask

Jul 13 2014 19:58:07 INFO : Completed  upgrade command execution for component -ATG

Jul 13 2014 19:58:07 INFO : Completed component upgrade - ATG

UPGRADING FSM

 /u02/app/oracle/fmw/Oracle_BI1/jdk/bin/java -jar  biappsrepositoryutil.jar upgradeFSM bi.oracle.home=/u02/app/oracle/fmw/Oracle_BI1/ work.dir=/home/orabi/Patch/log biacomp.user=BIAPPS_BIACOMP  biacomp.password=OMsys123 db.conn.sid.url=<host_name>:1521:biapp fsm.db.seed.url=<host_name>:1521/<service_name>  db.sys.user=SYS db.sys.password=OMsys123

Jul 13 2014 20:18:19 INFO : Calling JDBCEngine constructor

Jul 13 2014 20:18:19 INFO : Connecting to database: user:SYS as sysdba, connectString:jdbc:oracle:thin:SYS as sysdba/*****@192.168.4.120:1521:biapp

Jul 13 2014 20:18:19 INFO : Finished   FSMSeedDataUpgradeTask execution.

Jul 13 2014 20:18:19 INFO : Completed upgrade task: FSMSeedDataUpgradeTask

Jul 13 2014 20:18:19 INFO : Completed  upgrade command execution for component -FSM

Jul 13 2014 20:18:19 INFO : Completed component upgrade - FSM

RCU for BIAPPS and ODI

BI APPS 11.8 Installation[CREATING RCU for ODI and BIAPP]part -3

In this Part 3 of Bi Apps Installation we will  have the Practice of Installing the RCU for BI APPS and ODI

for Running the Rcu we need to download the  software and unzip in the database server temp folder 

 

CREATING RCU FOR BIAPPS

Step 1

Navigate to the /home/oracle/rcu/bin-- rcu is the staging directory where we unzip the V44918-01.zip 

run ./rcu to invoke the installer 

Step 2
Click create Button to create the RCU for BIAPPS

Step 3
Provide the data warehouse database details 
Host name      :=data warehouse database host name
Port               :=  Database Port
ServiceName  :=Data warehouse database service Name
Username       :=SYS
Password       :=Password of SYS user

Once the Prerequisite check completes fine then click ok and proceed to next step

Step 3
Create the Prefix as BIAPPS
and select the Oracle Business Analytic Warehouse-- it will create only the BI apps repository and we will create the ODI repository later

Step 4 

Provide the password for the BIAPPS schema user

Step 5
we need to provide the dump file location .. there are three dump file available and two of  ODI and one for BIAPPS

[oracle@biapp schema]$ pwd
/home/oracle/rcu/rcu/integration/biapps/schema
[oracle@biapp schema]$ ls
-rwxrwxr-x. 1 oracle oinstall 379461632 Apr 18 18:43 obia_comp.dmp
-rwxrwxr-x. 1 oracle oinstall 125952000 Apr 18 18:43 obia.dmp
-rwxrwxr-x. 1 oracle oinstall 857681920 Apr 18 18:42 obia_odi.dmp
-rwxrwxr-x. 1 oracle oinstall                70 Apr18 18:43 dmplabel.txt
[oracle@biapp schema]$
if you are installing the BI rcu from the different server then we need to keep this three files in the DW database server tmp directory and we need to mention the location in the value column

Step 6

Check the table space the will be create for the new schema

Increase the size of the  table space according to the requirement

Step 7
Check the summary and proceed with the installation of RCU

Step 8

Check the summary and click finish for complete the RCU

CREATING RCU FOR ODI

Step 1

Run the ./rcu from the /home/oracle/rcu/bin  /home/oracle/ruc is the staging directory where the ruc software had been unzipped 

Step 2
Click create to create the new RCU

Step 3
Host name    Data Warehouse  database host name
Port              Database port
Service         Database Port
User Name  SYS
Password    OMsys123
check ok after the prerequisite check's had been completed successfully

Step 4

Create the prefix for the ODI Scheme's

select the components show in screen  to create the ODI schema

Step 5

[oracle@biapp schema]$ pwd
/home/oracle/rcu/rcu/integration/biapps/schema
[oracle@biapp schema]$ ls
-rwxrwxr-x. 1 oracle oinstall 379461632 Apr 18 18:43 obia_comp.dmp
-rwxrwxr-x. 1 oracle oinstall 125952000 Apr 18 18:43 obia.dmp
-rwxrwxr-x. 1 oracle oinstall 857681920 Apr 18 18:42 obia_odi.dmp
-rwxrwxr-x. 1 oracle oinstall                70 Apr18 18:43 dmplabel.txt
[oracle@biapp schema]$
provide the path in the value

Step 6

Step 7

Check the summary