We recently installed Oracle OBIEE with ODI on AWS and implemented PeopleSoft HR reporting. If you follow below document, you should have a functional system.

If you have any question, please reach out to laniakeagroupllc@gmail.com

c:\app\oracle\middleware\Oracle_BI1\biapps\tools\bin>perl APPLY_PATCHES.pl apply

_patches_import.txt

Oracle\tmp\patches\oracle_common\generic

7-Zip 18.01 (x64) : Copyright (c) 1999-2018 Igor Pavlov : 2018-01-28

Scanning the drive for archives:

1 file, 16105 bytes (16 KiB)

Extracting archive: C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\or

acle_common\generic\p16433147_111170_Generic.zip

Path = C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\oracle_common\g

eneric\p16433147_111170_Generic.zip

Type = zip

Physical Size = 16105

Everything is Ok

Folders: 11

Files: 7

Size:       101278

Compressed: 16105

Will try to explode the patch zip file:  C:\Users\Administrator\Downloads\BI_App

s_11.1.1.7.1_patch\oracle_common\generic\SOACOMMON_REL7B8_16438735.zip

Can’t create dir C:\Oracle\tmp\patches\oracle_common\generic.

Cheking C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\oracle_common\

generic\SOACOMMON_REL7B8_16438735.zip  is a BI Tech Patch

Extracting: “C:\Program Files\7-Zip\7z.exe” x C:\Users\Administrator\Downloads\B

I_Apps_11.1.1.7.1_patch\oracle_common\generic\SOACOMMON_REL7B8_16438735.zip -oC:

\Oracle\tmp\patches\oracle_common\generic

7-Zip 18.01 (x64) : Copyright (c) 1999-2018 Igor Pavlov : 2018-01-28

Scanning the drive for archives:

1 file, 17719421 bytes (17 MiB)

Extracting archive: C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\or

acle_common\generic\SOACOMMON_REL7B8_16438735.zip

Path = C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\oracle_common\g

eneric\SOACOMMON_REL7B8_16438735.zip

Type = zip

Physical Size = 17719421

Comment = PCBPEL_11.1.1.7.0SOA-FAREL7-BP_GENERIC_130319.1000.0021

Everything is Ok

Folders: 15

Files: 17

Size:       20343214

Compressed: 17719421

Will try to explode the patch zip file:  C:\Users\Administrator\Downloads\BI_App

s_11.1.1.7.1_patch\oracle_common\generic\WebCenter_BP1REL7RC3_16311963.zip

Can’t create dir C:\Oracle\tmp\patches\oracle_common\generic.

Cheking C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\oracle_common\

generic\WebCenter_BP1REL7RC3_16311963.zip  is a BI Tech Patch

Extracting: “C:\Program Files\7-Zip\7z.exe” x C:\Users\Administrator\Downloads\B

I_Apps_11.1.1.7.1_patch\oracle_common\generic\WebCenter_BP1REL7RC3_16311963.zip

-oC:\Oracle\tmp\patches\oracle_common\generic

7-Zip 18.01 (x64) : Copyright (c) 1999-2018 Igor Pavlov : 2018-01-28

Scanning the drive for archives:

1 file, 809907434 bytes (773 MiB)

Extracting archive: C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\or

acle_common\generic\WebCenter_BP1REL7RC3_16311963.zip

Path = C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\oracle_common\g

eneric\WebCenter_BP1REL7RC3_16311963.zip

Type = zip

Physical Size = 809907434

Everything is Ok

Folders: 77

Files: 280

Size:       830258883

Compressed: 809907434

Will try to explode the patch zip file:  C:\Users\Administrator\Downloads\BI_App

s_11.1.1.7.1_patch\oracle_common\generic\Webservices_Patch-3-PS6RC3_bug-16487786

.zip

Can’t create dir C:\Oracle\tmp\patches\oracle_common\generic.

Cheking C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\oracle_common\

generic\Webservices_Patch-3-PS6RC3_bug-16487786.zip  is a BI Tech Patch

Extracting: “C:\Program Files\7-Zip\7z.exe” x C:\Users\Administrator\Downloads\B

I_Apps_11.1.1.7.1_patch\oracle_common\generic\Webservices_Patch-3-PS6RC3_bug-164

87786.zip -oC:\Oracle\tmp\patches\oracle_common\generic

7-Zip 18.01 (x64) : Copyright (c) 1999-2018 Igor Pavlov : 2018-01-28

Scanning the drive for archives:

1 file, 9382241 bytes (9163 KiB)

Extracting archive: C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\or

acle_common\generic\Webservices_Patch-3-PS6RC3_bug-16487786.zip

Path = C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\oracle_common\g

eneric\Webservices_Patch-3-PS6RC3_bug-16487786.zip

Type = zip

Physical Size = 9382241

Everything is Ok

Folders: 8

Files: 28

Size:       10173115

Compressed: 9382241

The value of OPATCH_SHIPHOME: C:\app\oracle\middleware\oracle_common\OPatch

Performing OPatch apply as follows: C:\app\oracle\middleware\oracle_common\OPatc

h\opatch  napply C:\Oracle\tmp\patches\oracle_common\generic -silent -oh C:\app\

oracle\middleware\oracle_common  > C:\Oracle\tmp\oracle_common_generic_patches.l

og

Sleeping for 0 hours…

Analyzing logs ………….

Cheking fmw_diagnostics_14757820_2.zip  is a BI Tech Patch

found zip file fmw_diagnostics_14757820_2.zip

Cheking JDEVADF_REL7MLR10-RT_16525527.zip  is a BI Tech Patch

found zip file JDEVADF_REL7MLR10-RT_16525527.zip

Cheking p16080773_111170_Generic.zip  is a BI Tech Patch

found zip file p16080773_111170_Generic.zip

Cheking p16433036_111170_Generic.zip  is a BI Tech Patch

found zip file p16433036_111170_Generic.zip

Cheking p16433147_111170_Generic.zip  is a BI Tech Patch

found zip file p16433147_111170_Generic.zip

Cheking SOACOMMON_REL7B8_16438735.zip  is a BI Tech Patch

found zip file SOACOMMON_REL7B8_16438735.zip

Cheking WebCenter_BP1REL7RC3_16311963.zip  is a BI Tech Patch

found zip file WebCenter_BP1REL7RC3_16311963.zip

Cheking Webservices_Patch-3-PS6RC3_bug-16487786.zip  is a BI Tech Patch

found zip file Webservices_Patch-3-PS6RC3_bug-16487786.zip

Opening Logfile for validation: C:\Oracle\tmp\oracle_common_generic_patches.log

Patches 14757820,16080773,16311963,16433036,16433147,16438735,16487786,16525527

successfully applied.

Installed Patch 16525527

Installed Patch 16311963

Installed Patch 16080773

Installed Patch 16487786

Installed Patch 16438735

Installed Patch 16433147

Installed Patch 14757820

Installed Patch 16433036

p16433147_111170_Generic.zip is successfully installed

p16080773_111170_Generic.zip is successfully installed

Webservices_Patch-3-PS6RC3_bug-16487786.zip is successfully installed

p16433036_111170_Generic.zip is successfully installed

JDEVADF_REL7MLR10-RT_16525527.zip is successfully installed

WebCenter_BP1REL7RC3_16311963.zip is successfully installed

fmw_diagnostics_14757820_2.zip is successfully installed

SOACOMMON_REL7B8_16438735.zip is successfully installed

Will try to install SOA patchesThe Patch Location is:  C:\Users\Administrator\Do

wnloads\BI_Apps_11.1.1.7.1_patch\soa\generic

The Unzip Patch Location is: C:\Oracle\tmp\patches\soa\generic

Will try to explode the patch zip file:  C:\Users\Administrator\Downloads\BI_App

s_11.1.1.7.1_patch\soa\generic\SOA_REL7B8_16438735.zip

Can’t create dir C:\Oracle\tmp\patches\soa\generic.

Cheking C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\soa\generic\SO

A_REL7B8_16438735.zip  is a BI Tech Patch

Extracting: “C:\Program Files\7-Zip\7z.exe” x C:\Users\Administrator\Downloads\B

I_Apps_11.1.1.7.1_patch\soa\generic\SOA_REL7B8_16438735.zip -oC:\Oracle\tmp\patc

hes\soa\generic

7-Zip 18.01 (x64) : Copyright (c) 1999-2018 Igor Pavlov : 2018-01-28

Scanning the drive for archives:

1 file, 923106920 bytes (881 MiB)

Extracting archive: C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\so

a\generic\SOA_REL7B8_16438735.zip

Path = C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\soa\generic\SOA

_REL7B8_16438735.zip

Type = zip

Physical Size = 923106920

Comment = PCBPEL_11.1.1.7.0SOA-FAREL7-BP_GENERIC_130319.1000.0021

Everything is Ok

Folders: 178

Files: 1114

Size:       1026159816

Compressed: 923106920

The value of OPATCH_SHIPHOME: /scratch/aime/work/mw_home/Oracle_SOA1\OPatch

Performing OPatch apply as follows: /scratch/aime/work/mw_home/Oracle_SOA1\OPatc

h\opatch  napply C:\Oracle\tmp\patches\soa\generic -silent -oh /scratch/aime/wor

k/mw_home/Oracle_SOA1  > C:\Oracle\tmp\soa_generic_patches.log

The system cannot find the path specified.

Sleeping for 0 hours…

Analyzing logs ………….

Cheking SOA_REL7B8_16438735.zip  is a BI Tech Patch

found zip file SOA_REL7B8_16438735.zip

Opening Logfile for validation: C:\Oracle\tmp\soa_generic_patches.log

SOA_REL7B8_16438735.zip failed to install

Will try to install ODI patchesThe Patch Location is:  C:\Users\Administrator\Do

wnloads\BI_Apps_11.1.1.7.1_patch\odi\generic

The Unzip Patch Location is: C:\Oracle\tmp\patches\odi\generic

Will try to explode the patch zip file:  C:\Users\Administrator\Downloads\BI_App

s_11.1.1.7.1_patch\odi\generic\p16629917_111170_Generic.zip

Can’t create dir C:\Oracle\tmp\patches\odi\generic.

Cheking C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\odi\generic\p1

6629917_111170_Generic.zip  is a BI Tech Patch

Extracting: “C:\Program Files\7-Zip\7z.exe” x C:\Users\Administrator\Downloads\B

I_Apps_11.1.1.7.1_patch\odi\generic\p16629917_111170_Generic.zip -oC:\Oracle\tmp

\patches\odi\generic

7-Zip 18.01 (x64) : Copyright (c) 1999-2018 Igor Pavlov : 2018-01-28

Scanning the drive for archives:

1 file, 128951444 bytes (123 MiB)

Extracting archive: C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\od

i\generic\p16629917_111170_Generic.zip

Path = C:\Users\Administrator\Downloads\BI_Apps_11.1.1.7.1_patch\odi\generic\p16

629917_111170_Generic.zip

Type = zip

Physical Size = 128951444

Everything is Ok

Folders: 27

Files: 17

Size:       134867098

Compressed: 128951444

The value of OPATCH_SHIPHOME: C:\app\oracle\middleware\Oracle_ODI1\OPatch

Performing OPatch apply as follows: C:\app\oracle\middleware\Oracle_ODI1\OPatch\

opatch  napply C:\Oracle\tmp\patches\odi\generic -silent -oh C:\app\oracle\middl

eware\Oracle_ODI1  > C:\Oracle\tmp\odi_generic_patches.log

Sleeping for 0 hours…

Analyzing logs ………….

Cheking p16629917_111170_Generic.zip  is a BI Tech Patch

found zip file p16629917_111170_Generic.zip

Opening Logfile for validation: C:\Oracle\tmp\odi_generic_patches.log

Patches 16629917 successfully applied.

Installed Patch 16629917

p16629917_111170_Generic.zip is successfully installed

SKIP_PATCHID_LIST is blank. No need to rollback any patches

APPLY_PATCHLOC_LIST is blank. No need to apply extra patches

applying weblogic patches

BSU dir location C:\app\oracle\middleware\utils\bsu

Cache dir location C:\app\oracle\middleware\utils\bsu\cache_dir

Directory already exists

The Base Patch is found HYKC.jar at the patch location!

C:\app\oracle\middleware\Oracle_BI1\jdk\bin\java -jar patch-client.jar -prod_dir

=C:\app\oracle\middleware\wlserver_10.3 -install -patchlist=HYKC,1IHE,1PI6,9I9D,

BEJG,CM69,EUW3,F6G7,H2FT,JG58,QKPF,RPI1,RUNT,S4BN,SKLY,SRUM,TWDG,UDN7,WYRU,Z8MQ,

ZR38

‘tee’ is not recognized as an internal or external command,

operable program or batch file.

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

* BIAPPSSHIPHOME Patching Report ……….

Patch Succeded: fsclite_rel7mlr2_16424872.zip

Patch Succeded: BISHIPHOME_11_1_1_7_0_GENERIC_130409_1210_16492220.zip

Patch Succeded: atglite_rel7mlr5A_database_16239380.zip

Patch Succeded: atglite_rel7mlr5_16480022.zip

Patch Succeded: fsmlitedb_rel7mlr2_16424869.zip

Patch Succeded: fsmlite_rel7mlr2_16424870.zip

* Oracle Common Patching Report ……….

Patch Succeded: p16433147_111170_Generic.zip

Patch Succeded: p16080773_111170_Generic.zip

Patch Succeded: Webservices_Patch-3-PS6RC3_bug-16487786.zip

Patch Succeded: p16433036_111170_Generic.zip

Patch Succeded: JDEVADF_REL7MLR10-RT_16525527.zip

Patch Succeded: WebCenter_BP1REL7RC3_16311963.zip

Patch Succeded: fmw_diagnostics_14757820_2.zip

Patch Succeded: SOACOMMON_REL7B8_16438735.zip

* SOA Patching Report ……….

Patch Failed: SOA_REL7B8_16438735.zip

* ODI Patching Report ……….

Patch Succeded: p16629917_111170_Generic.zip

* Weblogic Patching Report ……….

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

This final patching report log file is also located at: C:\Oracle\tmp\final_patc

hing_report.log

c:\app\oracle\middleware\Oracle_BI1\biapps\tools\bin>

Password is – Brfc2017

Password is Brfc2017

Dev_mds/Brfc2017

Started node manager as this process failed restart the server due to node manager down.

Started bi_server1 manually.

Went past the waiting as soon as the server was up.

Release the lock in 7001 console as it needs later on

Web logic upgrade to 10.3.6

DW patch

Very Critical bug and must be fixed before the next step. – https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=558058609092533&id=1628870.1&_afrWindowMode=0&_adf.ctrl-state=1qi1uckz3_332

Microsoft Windows [Version 6.1.7601]

Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>cd ..

C:\Users>cd ..

C:\>cd app\oracle\middleware\Oracle_BI1

C:\app\oracle\middleware\Oracle_BI1>cd common\bin

C:\app\oracle\middleware\Oracle_BI1\common\bin>C:\app\oracle\middleware\Oracle_BI1\common\bin\wlst.cmd C:\app\oracle\middleware\Oracle_BI1\bifoundation\install\createJPSArtifactsODI.py embedded –ADMIN_USER_NAME weblogic –DOMAIN_HOSTNAME WIN-L1IJ5FHGSMJ –DOMAIN_PORT 7001 –DOMAIN_HOME_PATH C:\app\oracle\middleware\user_projects\domains\bifoundation_domain\

CLASSPATH=C:\app\oracle\MIDDLE~1\patch_wls1036\profiles\default\sys_manifest_classpath\weblogic_patch.jar;C:\app\oracle\MIDDLE~1\patch_ocp371\profiles\default\sys_manifest_classpath\weblogic_patch.jar;C:\app\oracle\MIDDLE~1\ORACLE~2\jdk\lib\tools.jar;C:\app\oracle\MIDDLE~1\WLSERV~1.3\server\lib\weblogic_sp.jar;C:\app\oracle\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar;C:\app\oracle\MIDDLE~1\modules\features\weblogic.server.modules_10.3.6.0.jar;C:\app\oracle\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;C:\app\oracle\MIDDLE~1\modules\ORGAPA~1.1/lib/ant-all.jar;C:\app\oracle\MIDDLE~1\modules\NETSFA~1.0_1/lib/ant-contrib.jar;”.;C:\app\oracle\middleware\wlserver_10.3\server\lib\weblogic.jar;C:\app\oracle\MIDDLE~1\ORACLE~2/common/wlst/lib/webcenter-admin-commands.jar;C:\app\oracle\MIDDLE~1\ORAC

LE~2/analytics-collector/archives/applications/analytics-collector-jee.jar”;C:\app\oracle\MIDDLE~1\ORACLE~2\common\wlst\lib\WEBCEN~1.JAR;C:\app\oracle\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-wlstman.jar;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\lib\ADFSCR~1.JAR;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\lib\mdswlst.jar;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\IGFWLS~1.JAR;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\JPS-WL~1.JAR;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;C:\app\orac

le\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OVDWLS~1.JAR;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;C:\app\oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar;C:\app\oracle\MIDDLE~1\utils\config\10.3\config-launch.jar;C:\app\oracle\MIDDLE~1\WLSERV~1.3\common\derby\lib\derbynet.jar;C:\app\oracle\MIDDLE~1\WLSERV~1.3\common\derby\lib\derbyclient.jar;C:\app\oracle\MIDDLE~1\WLSERV~1.3\common\derby\lib\derbytools.jar;;

Initializing WebLogic Scripting Tool (WLST) …

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

[Enter the password for user :weblogic]

Connecting to t3://WIN-L1IJ5FHGSMJ:7001 with userid weblogic …

Successfully connected to Admin Server ‘AdminServer’ that belongs to domain ‘bifoundation_domain’.

Warning: An insecure protocol was used to connect to the

C:\app\oracle\middleware\Oracle_BI1\common\bin>del C:\app\oracle\middleware\Oracle_BI1\clients\biappsclients\odi\Readme.txt

C:\app\oracle\middleware\Oracle_BI1\common\bin>

server. To ensure on-the-wire security, the SSL port or

Admin port should be used instead.

Disconnected from weblogic server: AdminServer

jps-config file created successfully

jps-config-jse.xml file created successfully at:C:\app\oracle\middleware\user_projects\domains\bifoundation_domain\/odi-client-config/embedded/jps-config-jse.xml

Connecting to t3://WIN-L1IJ5FHGSMJ:7001 with userid weblogic …

Successfully connected to Admin Server ‘AdminServer’ that belongs to domain ‘bifoundation_domain’.

Warning: An insecure protocol was used to connect to the

server. To ensure on-the-wire security, the SSL port or

Admin port should be used instead.

Creating Bootstrap Credential

Apr 13, 2018 7:38:16 PM oracle.security.jps.internal.common.util.XmlSchemaValidationUtil$StrictErrorHandler warning

WARNING: Invalid xml content was found. SchemaLocation: schemaLocation value = ‘http://xmlns.oracle.com/oracleas/schema/11/jps-config-11_1.xsd‘ must have even number of URI’s. Location: line 2 column 272.

key created succesfully

credential updated successfully

Disconnected from weblogic server: AdminServer

JPS config file and credential wallet at location: C:\app\oracle\middleware\user_projects\domains\bifoundation_domain\/odi-client-config/embedded

C:\app\oracle\middleware\Oracle_BI1\common\bin>copy C:\app\oracle\middleware\user_projects\domains\bifoundation_domain\odi-client-config\embedded\cwallet.sso C:\app\oracle\middleware\Oracle_ODI1\oracledi\client\odi\bin\

1 file(s) copied.

C:\app\oracle\middleware\Oracle_BI1\common\bin>copy C:\app\oracle\middleware\user_projects\domains\bifoundation_domain\odi-client-config\embedded\jps-config-jse.xml C:\app\oracle\middleware\Oracle_ODI1\oracledi\client\odi\bin\

1 file(s) copied.

C:\app\oracle\middleware\Oracle_BI1\common\bin>xcopy C:\app\oracle\middleware\Oracle_BI1\clients\biappsclients\odi\* C:\app\oracle\middleware\Oracle_ODI1\oracledi\client\ide\extensions /s /i /e

Overwrite C:\app\oracle\middleware\Oracle_ODI1\oracledi\client\ide\extensions\lpggui.jar (Yes/No/All)? Y

C:\app\oracle\middleware\Oracle_BI1\clients\biappsclients\odi\lpggui.jar

C:\app\oracle\middleware\Oracle_BI1\clients\biappsclients\odi\OBIA_LPG_Plugin.zip

C:\app\oracle\middleware\Oracle_BI1\clients\biappsclients\odi\Readme.txt

C:\app\oracle\middleware\Oracle_BI1\clients\biappsclients\odi\OBIALoadPlanGenerator\config\config.properties

C:\app\oracle\middleware\Oracle_BI1\clients\biappsclients\odi\OBIALoadPlanGenerator\lib\lpgengine.jar

5 File(s) copied

C:\app\oracle\middleware\Oracle_BI1\common\bin>del C:\app\oracle\middleware\Oracle_BI1\clients\biappsclients\odi\OBIA_LPG_Plugin.zip

Mkdir C:\app\oracle\middleware\Oracle_ODI1\oracledi\etl

xcopy C:\app\oracle\middleware\Oracle_BI1\biapps\etl C:\app\oracle\middleware\Oracle_ODI1\oracledi\etl /s /i /e