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
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
No comments:
Post a Comment