OBIEE - 12.2.1.3 - Windows Installation 12C on Azure

About

An installation procedure:

on a Azure VM Windows.
with a SQL Server database
with a standard topology (ie a WebLogic Server domain that contains an Administration Server and a cluster that contains two Managed Servers).

Articles Related

Planning and pre-requisites

This section gives:

tips on where to search about planning information (ie which hardware and software are needed to plan an OBIEE installation).
and the database prerequisites (SQL Server in this page)

Software - Certification Matrix

Oracle Fusion Middleware 12c Certifications
- The certified database can be found in the Additional DB tab
- The OS in the System tab

Example for the RCU database:

Database RCU (SQL Server)

OBIEE stores information in an external database with the help of an RCU utility. The extern database is then important.

The Repository Creation Utility is responsible for the creation of this database schema. Repository Creation Utility Requirements

Install a Sql Server: SQL Server - Installation
Configure it: Configuring a Microsoft SQL Server Database for the Metadata Services (MDS) Schema. Example:

CREATE DATABASE OBI;
ALTER DATABASE OBI SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE OBI SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE OBI COLLATE SQL_Latin1_General_CP1_CS_AS;

This can be verified with.

select * from sys.databases;

Create an Azure VM

Hardware requirement

Oracle® Fusion Middleware - System Requirements and Specifications. You will find the | Oracle® Fusion Middleware System Requirements and Specifications 12c (12.2.1.3.0) that have a section on Oracle Business Intelligence Requirements

Recommended hardware and system configuration requirements:

CPU Speed: minimum 1-GHz CPU.
Disk Space: 20 GB or more
Available Memory: 8 GB or more for 64-bit operating systems
Temp Space: 2 GB or more
Swap Space: 8 GB or more for 64-bit operating systems

Recommended database requirements:

500 MB for RCU schemas such as Oracle Business Intelligence Scheduler database tables.

Memory

3 GB for the operating system and other software
   3 GB for the Admin Server 
 + 3 GB by Managed Servers
--------------------------------------
  9 GB

Via the Marketplace

via the web portal

Via the cli

Azure - Cli

Create statement. An E2S_v3 VM estimated cost are 100 Euro by month. It has 2 Core and 16Gb memory.

az vm create \
    --resource-group myResourceGroup \
    --name myVM \
    --image MicrosoftWindowsServer:WindowsServer:2016-Datacenter:2016.127.20171217 \
    --size Standard_E2s_v3 \
    --authentication-type password \
    --admin-username adm \
    --admin-password xxxxx \
    --location westeurope

Steps

Download

Download all files and transfer them in the C;\tmp directory.

On this OBIEE download Page:

The Web Logic Server
- fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip
Oracle Business Intelligence 12c version 12.2.1.3.0 for Windows x64. Example
- File1: fmw_12.2.1.3.0_bi_windows64_Disk1_1of2.zip
- File2: fmw_12.2.1.3.0_bi_windows64_Disk1_2of2.zip

On this Jdk Download page:

The JDK - jdk1.8.0_131 and above . Example:
- jdk-8u161-windows-x64.exe

Jdk

In the 12 c 12.2.1.3.0, the Fusion Middleware products, the platform-specific distributions no longer include and configure a JDK automatically.

Installation

Installation Software Preparation

Unzip and set the installation files ready to use for the oracle user.

Unzip all OBI software in one installation directory

The Weblogic software
The OBI installer (1 of 1)
The OBI Software delivered as a zip (2 of 2)

At the end, you got the following files in one directory:

setup_bi_platform-12.2.1.3.0_win64.exe
setup_bi_platform-12.2.1.3.0_win64-2.zip
fmw_12.2.1.3.0_infrastructure.jar

Directory Structure

Directory Structure

# A base location (Oracle base)
ORACLE_BASE=C:\Oracle\Middleware\
# The product directory should contain the product binary files and all the Oracle home directories.
# Multiple products will exist in the Oracle home (fmw + obi)
ORACLE_HOME=C:\Oracle\Middleware\Fmw
BI_PRODUCT_HOME=%ORACLE_HOME%
# The config directory should contain your domain and application data.
# They comes after the configuration
# Normally DOMAIN_HOME=/home/oracle/config/domains/bi_domain but for OBI
DOMAIN_HOME=%ORACLE_HOME%\user_projects\domains
# Normally APPLICATION_HOME=/home/oracle/config/applications/ but for OBI
APPLICATION_HOME=%ORACLE_HOME%\user_projects\applications

As the installation user

Weblogic Installation

Via Wizard

The java executable must be a JDK executable. Personally, I have changed the PATH in the environment variable in order to have the JDK first.

PATH=C:\Java\jdk1.8.0_161\bin;%PATH%

Then start the installer.

java -jar fmw_12.2.1.3.0_infrastructure.jar

And follow the screens with all default (Installation directory: C:\Oracle\Middleware\Fmw)

Via the command line (silence)

# start the installation
java -jar /tmp/fmw_12.2.1.3.0_infrastructure.jar ^
   -silent ^
   -responseFile C:\tmp\fmw.rsp.ini

Output:

Launcher log file is C:\Users\adminsql\AppData\Local\Temp\2\OraInstall2018-02-05_12-00-41PM\launcher2018-02-05_12-00-41PM.log.
Extracting the installer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Done
Checking if CPU speed is above 300 MHz.   Actual 2394    Passed
Checking swap space: must be greater than 512 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Checking temp space: must be greater than 300 MB.   Actual 78228 MB    Passed
Preparing to launch the Oracle Universal Installer from C:\Users\adminsql\AppData\Local\Temp\2\OraInstall2018-02-05_12-00-41PM
Log: C:\Users\adminsql\AppData\Local\Temp\2\OraInstall2018-02-05_12-00-41PM\install2018-02-05_12-00-41PM.log
Copyright (c) 1996, 2017, Oracle and/or its affiliates. All rights reserved.
Reading response file..
Skipping Software Updates
Starting check : CertifiedVersions
Expected result: One of Windows 7, Windows Server 2012, Windows Server 2012 R2, Windows 8.1, Windows 10, Windows Server 2016
Actual Result: Windows Server 2016 Datacenter
Check complete. The overall result of this check is: Passed
CertifiedVersions Check: Success.


Starting check : CheckJDKVersion
Expected result: 1.8.0_131
Actual Result: 1.8.0_161
Check complete. The overall result of this check is: Passed
CheckJDKVersion Check: Success.


Validations are enabled for this session.
Verifying data
Copying Files
Percent Complete : 10
Percent Complete : 20
Percent Complete : 30
Percent Complete : 40
Percent Complete : 50
Percent Complete : 60
Percent Complete : 70
Percent Complete : 80
Percent Complete : 90
Percent Complete : 100

The installation of Oracle Fusion Middleware 12c Infrastructure 12.2.1.3.0 completed successfully.
Logs successfully copied to C:\Program Files\Oracle\Inventory\logs.

OBIEE Software Installation

You can find below:

the GUI installation
and the Silent installation

OBIEE Software Install With the GUI

C:\tmp\setup_bi_platform-12.2.1.3.0_win64.exe

Follow the screens (Oracle Home is the same than previously. It points to Weblogic (Fusion Middelware or fmw). Ie C:\Oracle\Middleware\Oracle_Home

Example:

OBIEE Software Install in Silent Mode

setup_bi_platform-12.2.1.3.0_win64.exe ^
   -silent ^
   -responseFile c:\tmp\obi.install.rsp.ini

output:

Launcher log file is C:\Users\adminsql\AppData\Local\Temp\2\OraInstall2018-02-05_12-31-20PM\launcher2018-02-05_12-31-20PM.log.
Extracting the installer . . . . . . . . . . . . . . . . . . Done
Checking if CPU speed is above 300 MHz.   Actual 2394    Passed
Checking swap space: must be greater than 512 MB    Passed
Preparing to launch the Oracle Universal Installer from C:\Users\adminsql\AppData\Local\Temp\2\OraInstall2018-02-05_12-31-20PM
Log: C:\Users\adminsql\AppData\Local\Temp\2\OraInstall2018-02-05_12-31-20PM\install2018-02-05_12-31-20PM.log
Copyright (c) 1999, 2017, Oracle and/or its affiliates. All rights reserved.
Reading response file..
Skipping Software Updates
Starting check : CertifiedVersions
Expected result: One of Windows Server 2012, Windows Server 2012 R2, Windows Server 2016
Actual Result: Windows Server 2016 Datacenter
Check complete. The overall result of this check is: Passed
CertifiedVersions Check: Success.


Starting check : TotalMemory
Expected result: 1024MB
Actual Result: 65535MB
Check complete. The overall result of this check is: Passed
TotalMemory Check: Success.


Starting check : CheckJDKVersion
Expected result: 1.8.0_131
Actual Result: 1.8.0_131
Check complete. The overall result of this check is: Passed
CheckJDKVersion Check: Success.


Validations are enabled for this session.
Verifying data
Copying Files
Percent Complete : 10
Percent Complete : 20
Percent Complete : 30
Percent Complete : 40
Dll to load is C:\Users\adminsql\AppData\Local\Temp\2\OraInstall2018-02-05_12-31-20PM\Win64RunProcesses.dll
Loading psapi.dll from C:\Users\adminsql\AppData\Local\Temp\2\OraInstall2018-02-05_12-31-20PM\psapi.dll
Percent Complete : 50
Percent Complete : 60
Percent Complete : 70
Percent Complete : 80
Percent Complete : 90
Percent Complete : 100

The installation of bi_platform 12.2.1.3.0 completed successfully.
Logs successfully copied to C:\Program Files\Oracle\Inventory\logs.

OBIEE Patch

List:

Bundle Patch: OBIEE 12c: Required and Recommended Bundle Patches and Patch Sets For Oracle Business Intelligence 12c (Doc ID 2070465.1), section OBIEE 12.2.1.3, apply the Patch 26796833
Installation patch: OBIEE 12.2.1.3.0 Installation fails at configuration with RCU schemas in SQL Server database (Doc ID 2328383.1) or OBIEE 12c: Installation Fails at Config Step: “Failed to build JDBC Connection object” (Doc ID 2319596.1), apply the Patch 26763904

Steps

Add the opatch directory in the path environment variable and the bin directory to get the zip executable

set PATH=C:\Oracle\Middleware\Oracle_Home\OPatch;%PATH%
set PATH=C:\Oracle\Middleware\Fmw\bin;%PATH%

Opatch version

opatch version

OPatch Version: 13.9.2.0.0

OPatch succeeded.

Check if there is not a new version in patch 6880880, Release OUI NextGen 13.3 (Doc → Using OUI NextGen OPatch 13 for Oracle Fusion Middleware 12c (12.1.2+) )
Download the files: p26763904_122130_Generic.zip and p26796833_122130_MSWIN-x86-64.zip
Unzip them in C:\PATCH_TOP

set ORACLE_HOME=C:\Oracle\Middleware\Fmw
cd %PATCH_TOP%/26763904
opatch apply

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '26763904' to OH 'C:\Oracle\Middleware\Fmw'

Patching component oracle.bi.configutils, 12.2.1.3.0...
Patch 26763904 successfully applied.
Log file location: C:\Oracle\Middleware\Fmw\cfgtoollogs\opatch\opatch2018-02-05_16-12-05PM_1.log

OPatch succeeded.

Install other patch

cd %PATCH_TOP%/26796833
opatch apply

..............................
..............................
Patching component oracle.bi.publisher, 12.2.1.3.0...

Patching component oracle.bi.fndn, 12.2.1.3.0...

Patching component oracle.bi.fndn, 12.2.1.3.0...

Patching component oracle.bi.publisher.clients, 12.2.1.3.0...

Patching component oracle.bi.publisher.clients, 12.2.1.3.0...
Patch 26796833 successfully applied.
Log file location: C:\Oracle\Middleware\Fmw\cfgtoollogs\opatch\opatch2018-02-05_16-14-04PM_1.log

OPatch succeeded.

Configure OBIEE

The metadata schema RCU utility is located here […/Oracle_Home/oracle_common/bin/rcu ] and has advanced features if needed. The below installation will create them.

Configure with the GUI

log:

Configure log: C:\Program Files\Oracle\Inventory\logs\
RCU: C:\Users\adminsql\AppData\Local\Temp\2\\RCUYYYY-MM-DD_HH-MI_662846414\logs\rcu.log

Start the installer and let the default value

%ORACLE_HOME%\bi\bin\config.cmd

Ensure that the weblogic password starts with alphabetic character

Database (SQLServer connection string localhost:1433:OBI)

Configure Silent Mode

REM See the help
REM %ORACLE_HOME%/bi/bin/config.cmd -help
%ORACLE_HOME%/bi/bin/config.cmd ^
   -silent ^
   -responseFile C:\tmp\obi.config.rsp.ini

Output (without the verification steps):

Launcher log file is C:\Users\adminsql\AppData\Local\Temp\2\OraInstall2018-02-08_01-14-09PM\launcher2018-02-08_01-14-09PM.log.
Checking swap space: must be greater than 500 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Log: C:\Program Files\Oracle\Inventory\logs\install2018-02-08_01-14-09PM.log
Copyright (c) 1999, 2017, Oracle and/or its affiliates. All rights reserved.
Reading response file..
Starting check : CertifiedVersions
Expected result: One of Windows Server 2012, Windows Server 2012 R2, Windows Server 2016
Actual Result: Windows Server 2016 Datacenter
Check complete. The overall result of this check is: Passed
CertifiedVersions Check: Success.


Starting check : TotalMemory
Expected result: 1024MB
Actual Result: 65535MB
Check complete. The overall result of this check is: Passed
TotalMemory Check: Success.


Starting check : CheckJDKVersion
Expected result: 1.8.0_131
Actual Result: 1.8.0_161
Check complete. The overall result of this check is: Passed
CheckJDKVersion Check: Success.


Verifying data
[CONFIG] Launching Config Actions
Started Configuration:BI Configuration
[CONFIG]:Create schemas using RCU
[CONFIG] [BI Configuration] [Create schemas using RCU]:2018-02-08T13:14:45.012+0100 Starting RCU
[CONFIG] [BI Configuration] [Create schemas using RCU]:2018-02-08T13:14:45.013+0100 See log file: C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM\RCUCreateSchema\RCUCreateSchema.out
[CONFIG] [BI Configuration] [Create schemas using RCU]:2018-02-08T13:14:45.013+0100 See log file: C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM\RCUCreateSchema\RCUCreateSchema.log
[CONFIG] SUCCESS:Create schemas using RCU
[CONFIG]:Create expanded domain
[CONFIG] [BI Configuration] [Create expanded domain]:2018-02-08T13:15:06.653+0100 See log file: C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM\createExpandedDomain.log
[CONFIG] SUCCESS:Create expanded domain
[CONFIG]:BIEE
[CONFIG] [BI Configuration] [BIEE]:2018-02-08T13:15:57.231+0100 See log file: C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM\biee.log
[CONFIG] SUCCESS:BIEE
[CONFIG]:BI Publisher (BIP)
[CONFIG] [BI Configuration] [BI Publisher (BIP)]:2018-02-08T13:18:01.609+0100 See log file: C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM\bip.log
[CONFIG] SUCCESS:BI Publisher (BIP)
[CONFIG]:Complete domain
[CONFIG] [BI Configuration] [Complete domain]:2018-02-08T13:18:52.043+0100 See log file: C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM\completeDomain.log
[CONFIG] SUCCESS:Complete domain
[CONFIG]:Store port range
[CONFIG] SUCCESS:Store port range
[CONFIG]:Create SSL certificates
[CONFIG] SUCCESS:Create SSL certificates
[CONFIG]:Create internal channels
[CONFIG] SUCCESS:Create internal channels
[CONFIG]:Sync mid tier database
[CONFIG] [BI Configuration] [Sync mid tier database]:2018-02-08T13:20:38.809+0100 See log file: C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM\SyncMidTierDB.out
[CONFIG] SUCCESS:Sync mid tier database
[CONFIG]:Create system components
[CONFIG] [BI Configuration] [Create system components]:2018-02-08T13:20:39.060+0100 See log file: C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM\bieecreatecomponents.log
[CONFIG] SUCCESS:Create system components
[CONFIG]:Enable single sign on
[CONFIG] [BI Configuration] [Enable single sign on]:2018-02-08T13:21:10.376+0100 See log file: C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM\bieesinglesignon.log
[CONFIG] SUCCESS:Enable single sign on
[CONFIG]:Add default service instance
[CONFIG] [BI Configuration] [Add default service instance]:2018-02-08T13:21:23.148+0100 Updating security config
[CONFIG] [BI Configuration] [Add default service instance]:2018-02-08T13:21:23.172+0100 Creating BI Service Instance
[CONFIG] SUCCESS:Add default service instance
[CONFIG]:SampleAppLite
[CONFIG] [BI Configuration] [SampleAppLite]:2018-02-08T13:22:56.054+0100 SampleAppLite data
[CONFIG] [BI Configuration] [SampleAppLite]:2018-02-08T13:22:56.272+0100 Unpacking SampleAppLiteData from: C:\Oracle\Middleware\Fmw\bi\bin\..\..\bi\modules\oracle.biee.application.sample\sample-datafiles.zip to: F:\Oracle\Middleware\Fmw\user_projects\domains\bi\bidata\service_instances\ssi\data
[CONFIG] [BI Configuration] [SampleAppLite]:2018-02-08T13:22:56.392+0100 SampleAppLite unpacked 2361774 bytes
[CONFIG] SUCCESS:SampleAppLite
[CONFIG]:Store JMS credential
[CONFIG] SUCCESS:Store JMS credential
Configuration:BI Configuration completed successfully
Started Configuration:BI Startup
[CONFIG]:Start all Servers
[CONFIG] [BI Startup] [Start all Servers]:2018-02-08T13:22:56.952+0100 Starting all Servers ...
[CONFIG] [BI Startup] [Start all Servers]:2018-02-08T13:22:56.952+0100 See log file: C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM\startallservers.log
[CONFIG] SUCCESS:Start all Servers
[CONFIG]:Create windows service
[CONFIG] [BI Startup] [Create windows service]:2018-02-08T13:22:57.043+0100 Creating windows wervice ...
[CONFIG] [BI Startup] [Create windows service]:2018-02-08T13:22:57.043+0100 See log file: C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM\createwindowsservice.log
[CONFIG] SUCCESS:Create windows service
Configuration:BI Startup completed successfully
Started Configuration:BI Epilogue
[CONFIG]:Collect logs
[CONFIG] [BI Epilogue] [Collect logs]:2018-02-08T13:22:57.788+0100 Zipping up config assistant log files to F:\Oracle\Middleware\Fmw\bi\bin\..\..\user_projects\domains\bi\bilogs\bieeconfiglogs_2018-02-08_01-14-09PM.zip
[CONFIG] [BI Epilogue] [Collect logs]:2018-02-08T13:22:57.805+0100 Zipping up the following log files and directories:
C:\Program Files\Oracle\Inventory\logs\install2018-02-08_01-14-09PM.log
C:\Program Files\Oracle\Inventory\logs\install2018-02-08_01-14-09PM.out
C:\Program Files\Oracle\Inventory\logs\config2018-02-08_01-14-09PM

[CONFIG] [BI Epilogue] [Collect logs]:2018-02-08T13:22:57.879+0100 Completed zipping up log files to F:\Oracle\Middleware\Fmw\bi\bin\..\..\user_projects\domains\bi\bilogs\bieeconfiglogs_2018-02-08_01-14-09PM.zip on host Sqlwdb0016
[CONFIG] [BI Epilogue] [Collect logs]:2018-02-08T13:22:57.880+0100 Run F:\Oracle\Middleware\Fmw\bi\bin\..\..\user_projects\domains\bi\bitools\bin\diagnostic_dump.cmd to get full diagnostics
[CONFIG] SUCCESS:Collect logs
Configuration:BI Epilogue completed successfully
The configuration of Oracle Fusion Middleware completed successfully.
Logs successfully copied to C:\Program Files\Oracle\Inventory\logs.

Windows Services

A Windows Service is created by default at installation time with the name Oracle Business Intelligence [bi].

The service has the manual startup type. You can change it to automatic.

OBIEE 12c: How To Control OBIEE Components Via A Windows Service

Test and Architecture

Environment

Change the windows environment variables of the system.

set ORACLE_BASE=/home/oracle
set ORACLE_HOME=%ORACLE_BASE%/product/fmw
set MW_HOME=$ORACLE_HOME
set DOMAIN_HOME=%ORACLE_HOME%/user_projects/domains
set BI_DOMAIN=bi
set BI_PRODUCT_HOME=%ORACLE_HOME%/%BI_DOMAIN%

The command utility tools are located at: %ORACLE_HOME%\user_projects\domains\bi\bitools\bin

Add it to the path to start them from the console:

set PATH=C:\Oracle\Middleware\Fmw\user_projects\domains\bi\bitools\bin;%PATH%

Start / Status / Stop

See OBIEE 12C - Services

Windows Services

A windows service is also created during the installation. You can set it on automatic.

Startup as windows services

The log is located at ORACLE_HOME\user_projects\domains\bi\bilogs\windowsService.log

URL

Admin Server (Http Port 9500, Https Port 9501, Internal 9504).
- Weblogic: http://hostname:9500/console
- Enterprise Manager: http://hostname:9500/em
Managed Server (Http Port 9502, Https Port 9503, Internal 9505).
- OBIEE Dashboard: http://hostname:9502/analytics
- BI Publisher: http://hostname:9502/xmlpserver

Ports

C:\Oracle\Middleware\Fmw\user_projects\domains\bi\bitools\bin\status.sh -v

The port to be able to connect to the repository is 9514

Accessing admin server using URL t3://obi0016:9500

Status of Domain: C:\Oracle\Middleware\Fmw\bi\bin\..\..\user_projects\domains\bi
NodeManager (obi0016:9506): RUNNING

Name            Type            Machine                   Status          Process Id Host:Port
----            ----            -------                   ------          ---------- ---------
AdminServer     Server          obi0016                RUNNING         Unknown
bi_server1      Server          obi0016                RUNNING         Unknown    obi0016.domain20.local:9505, obi0016.domain20.local:9502
obips1          OBIPS           obi0016                RUNNING         16176      obi0016.domain20.local:9507
obijh1          OBIJH           obi0016                RUNNING         592        obi0016.domain20.local:9510
obiccs1         OBICCS          obi0016                RUNNING         18904      obi0016.domain20.local:9509, obi0016.domain20.local:9508
obisch1         OBISCH          obi0016                RUNNING         21944      obi0016.domain20.local:9513, obi0016.domain20.local:9511, obi0016.domain20.local:9512
obis1           OBIS            obi0016                RUNNING         23952      obi0016.domain20.local:9514, obi0016.domain20.local:9515

Details:

Cluster Control (Main Port 9508, monitor 9509)
Scheduler (Main Port 9511, monitor 9512, script 9513)

Memory after installation

Client

Firewall

On the server, you need to open the port.

The below are a minimal if you want to work with the client:

the two weblogic servers (in our case 9500 and 9502).
the admintool port (9514)

Example:

ODBC DSN for OBIS

When creating an ODBC DSN on a client computer, you need to change the port to 9514

Deinstal Annexes

Deinstall fmw

Adapted from Steps to DeInstall Oracle Weblogic Server 12.1.2.0.0… By: Puneeth Prakash

Deinstall

# as oracle
# /home/oracle/product/fmw/oui/bin
cd %ORACLE_HOME%/oui/bin
deinstall.cmd -silent

Launcher log file is /tmp/OraInstall2018-01-10_08-29-06AM/launcher2018-01-10_08-29-06AM.log.
Checking if CPU speed is above 300 MHz.   Actual 2294.678 MHz    Passed
Checking swap space: must be greater than 512 MB.   Actual 2047 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Checking temp space: must be greater than 300 MB.   Actual 5661 MB    Passed
Log: /tmp/OraInstall2018-01-10_08-29-06AM/deinstall2018-01-10_08-29-06AM.log
Setting ORACLE_HOME to /home/oracle/product/Oracle_BI
Copyright (c) 1996, 2017, Oracle and/or its affiliates. All rights reserved.
Starting silent deinstallation...
Percent Complete : 10
Percent Complete : 20
Percent Complete : 30
Percent Complete : 40
Percent Complete : 50
Percent Complete : 60
Percent Complete : 70
Percent Complete : 80
Percent Complete : 90
100%

The uninstall of WebLogic Server for FMW 12.2.1.3.0 completed successfully.
Logs successfully copied to /home/oracle/oraInventory/logs.

Remove remaining files

cd C:\oracle\product
rmdir /S /Q fmw

Deinstall OBIEE

Adapted from Uninstalling or Reinstalling Oracle Business Intelligence

Drop the rcu schema

ORACLE_HOME=/home/oracle/product/fmw
$ORACLE_HOME/oracle_common/bin/rcu

Suppress the Weblogic Domain and Data

Suppress the domain

cd %ORACLE_HOME%\user_projects\domains\
rmdir  /S /Q bi

Suppress the application data

cd %ORACLE_HOME%\user_projects\applications\
rmdir /S /Q bi

Suppress the domain node from the registry file

cp %ORACLE_HOME%\domain-registry.xml %ORACLE_HOME%/domain-registry.xml.backup
notepad %ORACLE_HOME%\domain-registry.xml

<?xml version="1.0" encoding="UTF-8"?>
<domain-registry xmlns="http://xmlns.oracle.com/weblogic/domain-registry">
  <domain location="C:\home\oracle\product\fmw\user_projects\domains\bi"/> <- Suppress that !
</domain-registry>

Uninstall obi

If you want just to suppress only the config step (domain and rcu), don't do this. This step suppress the whole bi software.

cd %ORACLE_HOME%/oui/bin
./deinstall.cmd

Suppress the rest

cd %ORACLE_HOME%
rmdir /S /Q bi

Support

Failed to build JDBC Connection object

During the configuration step of the OBIEE software, the process failed with the following console output:

Failed to build JDBC Connection object

Example and it can appears at any step that try to create a database connection:

Verifying data
[CONFIG] Launching Config Actions
Started Configuration:BI Configuration
[CONFIG]:Create default domains dir
[CONFIG] SUCCESS:Create default domains dir
[CONFIG]:Create schemas using RCU
[CONFIG] [BI Configuration] [Create schemas using RCU]:2018-01-10T10:47:33.055+0000 Starting RCU
[CONFIG] [BI Configuration] [Create schemas using RCU]:2018-01-10T10:47:33.057+0000 See log file: /home/oracle/oraInventory/logs/config2018-01-10_10-47-03AM/RCUCreateSchema/RCUCreateSchema.out
[CONFIG] [BI Configuration] [Create schemas using RCU]:2018-01-10T10:47:33.057+0000 See log file: /home/oracle/oraInventory/logs/config2018-01-10_10-47-03AM/RCUCreateSchema/RCUCreateSchema.log
[CONFIG] SUCCESS:Create schemas using RCU
[CONFIG]:Create expanded domain
[CONFIG] [BI Configuration] [Create expanded domain]:2018-01-10T10:48:56.405+0000 See log file: /home/oracle/oraInventory/logs/config2018-01-10_10-47-03AM/createExpandedDomain.log
[CONFIG] SUCCESS:Create expanded domain
[CONFIG]:Essbase
[CONFIG] [BI Configuration] [Essbase]:2018-01-10T11:00:14.295+0000 See log file: /home/oracle/oraInventory/logs/config2018-01-10_10-47-03AM/essbase.log
[CONFIG] SUCCESS:Essbase
[CONFIG]:Generate CSS Keys
[CONFIG] [BI Configuration] [Generate CSS Keys]:2018-01-10T11:08:49.002+0000 See log file: /home/oracle/oraInventory/logs/config2018-01-10_10-47-03AM/CSSKeyGeneration.out
[CONFIG] SUCCESS:Generate CSS Keys
[CONFIG]:BIEE
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:08:51.015+0000 See log file: /home/oracle/oraInventory/logs/config2018-01-10_10-47-03AM/biee.log
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.927+0000 Failed single shot step: BIEE with: Execution of [/home/oracle/product/fmw/oracle_common/common/bin/wlst.sh, /home/oracle/product/fmw/bi/modules/oracle.bi.configassistant/biee.py, /home/oracle/product/fmw, /home/oracle/product/fmw/user_projects/domains/bi, weblogic, Expanded, hi-oracle-obi-01, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//hi-oracle-db-02:1521/orcl, OBI, jdbc:oracle:thin:@//hi-oracle-db-02:1521/orcl, ] failed with exit value 1
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.927+0000 Current log files for failed step BIEE
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.927+0000 --------------------
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.928+0000    Log file: /home/oracle/oraInventory/logs/config2018-01-10_10-47-03AM/biee.log
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.928+0000 --------------------
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.928+0000
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.929+0000 Initializing WebLogic Scripting Tool (WLST) ...
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.929+0000
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.929+0000 Welcome to WebLogic Server Administration Scripting Shell
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.929+0000
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.930+0000 Type help() for help on available commands
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.930+0000
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.930+0000 dbargs.py /home/oracle/product/fmw/bi/modules/oracle.bi.configassistant/biee.py /home/oracle/product/fmw /home/oracle/product/fmw/user_projects/domains/bi weblogic Expanded hi-oracle-obi-01 9502 9503 ORACLE oracle.jdbc.OracleDriver jdbc:oracle:thin:@//hi-oracle-db-02:1521/orcl OBI jdbc:oracle:thin:@//hi-oracle-db-02:1521/orcl
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.930+0000 Reading passwords from stdin...
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.931+0000 Enter admin password
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.931+0000 Enter DBSchema password
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.931+0000 Extending domain with BIEE Suite template
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.931+0000 Configuring datasources ...
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.931+0000 Setting JDBC url to jdbc:oracle:thin:@//hi-oracle-db-02:1521/orcl
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.932+0000 Deleting old user of type Property
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.932+0000 Creating user of type Property at /JDBCSystemResource/LocalSvcTblDataSource/JdbcResource/LocalSvcTblDataSource/JDBCDriverParams/NO_NAME_0/Properties/NO_NAME_0
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.932+0000 Master STB data source defined
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.943+0000 Error: getDatabaseDefaults() failed. Do dumpStack() to see details.
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.943+0000 Error: runCmd() failed. Do dumpStack() to see details.
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.944+0000
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.949+0000 Problem invoking WLST - Traceback (innermost last):
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.949+0000   File "/home/oracle/product/fmw/bi/modules/oracle.bi.configassistant/biee.py", line 20, in ?
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.949+0000   File "/home/oracle/product/fmw/bi/modules/oracle.bi.configassistant/pymodules/bieeimpl.py", line 40, in configureBIEE
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.949+0000   File "/home/oracle/product/fmw/bi/modules/oracle.bi.configassistant/pymodules/dbargs.py", line 137, in configureSimpleDefaultDataSources
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.950+0000   File "/tmp/WLSTOfflineIni209585216937842515.py", line 263, in getDatabaseDefaults
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.950+0000   File "/tmp/WLSTOfflineIni209585216937842515.py", line 19, in command
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.950+0000 Failed to build JDBC Connection object:
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.950+0000         at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:69)
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.951+0000         at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:2983)
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.951+0000         at com.oracle.cie.domain.script.jython.WLScriptContext.runCmd(WLScriptContext.java:735)
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.951+0000         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.951+0000         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.952+0000         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.952+0000         at java.lang.reflect.Method.invoke(Method.java:498)
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.952+0000
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.952+0000 com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: Got exception when auto configuring the schema component(s) with data obtained from shadow table:
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.953+0000 Failed to build JDBC Connection object:
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.953+0000
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.953+0000 --------------------
[CONFIG] [BI Configuration] [BIEE]:2018-01-10T11:14:27.965+0000
[CONFIG] [BI Configuration]:Zipping up config assistant log files to /home/oracle/product/fmw/user_projects/domains/bi/bilogs/bieeconfiglogs_2018-01-10_10-47-03AM.zip
[CONFIG] [BI Configuration]:Zipping up the following log files and directories:
/home/oracle/oraInventory/logs/install2018-01-10_10-47-03AM.log
/home/oracle/oraInventory/logs/install2018-01-10_10-47-03AM.out
/home/oracle/oraInventory/logs/config2018-01-10_10-47-03AM

[CONFIG] [BI Configuration]:Completed zipping up log files to /home/oracle/product/fmw/user_projects/domains/bi/bilogs/bieeconfiglogs_2018-01-10_10-47-03AM.zip on host hi-oracle-obi-01
[CONFIG] [BI Configuration]:Run /home/oracle/product/fmw/user_projects/domains/bi/bitools/bin/diagnostic_dump.sh to get full diagnostics
Configuration:BI Configuration failed
Error while running Configuration.
The configuration of Oracle Fusion Middleware failed.

The log(s) can be found here: /tmp/OraInstall2018-01-10_10-47-03AM.

See:

About

Articles Related

Software - Certification Matrix

Database RCU (SQL Server)

Hardware requirement

Via the Marketplace

Via the cli

Download

Jdk

Directory Structure

Via Wizard

Via the command line (silence)

OBIEE Software Install With the GUI

OBIEE Software Install in Silent Mode

OBIEE Patch

Configure with the GUI

Configure Silent Mode

Windows Services

Environment

Start / Status / Stop

Windows Services

URL

Ports

Memory after installation

Firewall

ODBC DSN for OBIS

Deinstall fmw

Drop the rcu schema

Suppress the Weblogic Domain and Data

Uninstall obi

Failed to build JDBC Connection object

Documentation / Reference