OBIEE - 12.2.1.3 - Windows Installation 12C on Azure

Obi Edition

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).

12g Obiee Standard Topology

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

Example for the RCU database:

Obiee Certification Matrix 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

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

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 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

# 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)

Fmw 12c Installation Location

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:

Obi 12c Installation Type

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:

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.

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

Obiee 12c Installation New Domain Windows

  • Database (SQLServer connection string localhost:1433:OBI)

Obiee Windows Config 12c Sql Server Database Details

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 Windows Service

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

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

Obiee 12c 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:

Firewall Obiee Weblogic Server

ODBC DSN for OBIS

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

Obiee 12c Dsn Obis Port 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

Obi 12c Drop Rcu Schema

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

Obi 12c Uninstall Software

  • 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:

Documentation / Reference





Discover More
Obi Edition
OBIEE - Admin 12c

Linux 6 of 7, no more 5 ! You need Linux 6 of 7 in order to install OBIEE 12c. OBI 12c Major Release is Available...
Obi Edition
OBIEE - Installation / Configuration

This page includes all articles on the installation topic of OBIEE. Installing...
Card Puncher Data Processing
Python - Installation and configuration

Installation and configuration of a python environment. Download it and install it Example: Linux: Configuration: Path Third library installation: You can also install...



Share this page:
Follow us:
Task Runner