OBIEE - 12.2.1.3 - Linux Installation 12C on Azure

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

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

Repository Creation Utility Requirements

• RCU Requirements for Oracle Databases
• Configuring a Microsoft SQL Server Database for the Metadata Services (MDS) Schema. OBIEE 12.2.1.3.0 Installation fails at configuration with RCU schemas in SQL Server database (Doc ID 2328383.1) - apply the Patch 26764904

To ensure that you have the correct privileges, login to RCU as a SYSDBA or as a DBA user who has EXECUTE privilege with GRANT OPTION on DBMS_OUTPUT and DBMS_LOB.

On Oracle databases, the MDS database user created by Repository Creation Utility (RCU) requires EXECUTE privilege on DBMS_OUTPUT, DBMS_STATS, and DBMS_LOB. When you create a metadata repository using RCU, if PUBLIC does not have EXECUTE privilege on DBMS_OUTPUT and DBMS_STATS, the RCU user must have the privilege to grant EXECUTE privilege on DBMS_OUTPUT and DBMS_STAT to the MDS user. The RCU user must have the privilege to grant EXECUTE privilege on DBMS_LOB to the MDS user.

Linux

Linux Operating System Requirements

• Processor: X86-64
• Oracle Linux 7 (UL4) - Doc

Package:

binutils-2.23.52.0.1
compat-libcap1-1.10
compat-libstdc++-33-3.2.3.x86_64
compat-libstdc++-33-3.2.3.i686
gcc-4.8.2
gcc-c++-4.8.2
glibc-2.17.x86_64
glibc-2.17.i686
glibc-devel-2.17.x86_64
libaio-0.3.109.x86_64
libaio-devel-0.3.109.x86_64
libgcc-4.8.2.x86_64
libgcc-4.8.2.i686
libstdc++-4.8.2.x86_64
libstdc++-4.8.2.i686
libstdc++-devel-4.8.2.x86_64
ksh
make-3.82
sysstat-10.1.5
numactl-2.0.9 for x86_641
numactl-devel-2.0.9 for x86_642
redhat-lsb-4.1-27.0.1.el7 for x86_64
redhat-lsb-core-4.1-27.0.1.el7 for x86_64

• locale settings to enable Unicode support

locale # To check your current locale settings, use the locale command on your system. 
setenv LANG en_US.UTF-8 # Sets the installation default locale. 
setenv LC_ALL en_US.UTF-8 # overrides the value of the LANG environment variable and the values of any other LC_* environment variables.

• open files

/usr/sbin/lsof | wc -l 
ulimit -n #To check your open file limits, use the commands below.

• Log in as root and add the following lines in the following file: /etc/security/limits.conf (The nofiles values represent the open file limit; the nproc values represent the number of processes limit.)

* soft  nofile  4096
* hard  nofile  65536
* soft  nproc   2047
* hard  nproc   16384

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

Download

Download all files and transfer them in the /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 linux x64. Example
  • File1: fmw_12.2.1.3.0_bi_linux64_Disk1_1of2.zip
  • File2: fmw_12.2.1.3.0_bi_linux64_Disk1_2of2.zip

On this Jdk Download page:

• The JDK - jdk1.8.0_131 and above . Example:
  • jdk-8u151-linux-x64.rpm

The patch 26763904: OBIEE 12.2.1.3 INSTALLATION FAILS AT CONFIG STEP: p26763904_122130_Generic.zip

Environment

Change the start script ~\.bash_profile to add the environment variables.

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

# Path
# Add the local bin for the obiee utility script
PATH=$PATH:$HOME/.local/bin:$HOME/bin
# Add opatch
PATH=$PATH:$ORACLE_HOME/OPatch
# Add the tools
PATH=$PATH:$ORACLE_HOME/user_projects/domains/bi/bitools/bin/
export PATH

# The install doc asks for this default permission settings
umask 027

Startup automation

With the init system

• Transfer the below file to /tmp

#!/bin/sh
# chkconfig: 345 99 10
# description: OBIEE auto start-stop script for the init system

OBI_OWNER=oracle

case "$1" in
    'start')
        # Start OBIEE
        su - $OBI_OWNER -c "/home/oracle/product/fmw/user_projects/domains/bi/bitools/bin/start.sh"
        ;;
    'stop')
        # Stop OBIEE
        su - $OBI_OWNER -c "/home/oracle/product/fmw/user_projects/domains/bi/bitools/bin/stop.sh"
        ;;
     'status')
        # Status of OBIEE
        su - $OBI_OWNER -c "/home/oracle/product/fmw/user_projects/domains/bi/bitools/bin/status.sh"
        ;;
esac
 
#
exit

• As root

sudo su -
mv /tmp/obieeinit /etc/init.d/obiee
chgrp oinstall /etc/init.d/obiee
chmod 750 /etc/init.d/obiee
chown oracle /etc/init.d/obiee

• Symlink that gives the level and when to start the script (K=shutdown and S=startup)

ln -s /etc/init.d/obiee /etc/rc.d/rc0.d/K01obiee
ln -s /etc/init.d/obiee /etc/rc.d/rc3.d/S99obiee
ln -s /etc/init.d/obiee /etc/rc.d/rc5.d/S99obiee

Then:

service obiee status
service obiee stop
service obiee start

Memory after installation

free -h

total        used        free      shared  buff/cache   available
Mem:            15G        5.3G        7.1G        8.4M        3.0G        9.8G
Swap:          2.0G          0B        2.0G

Deinstall fmw

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

• Deinstall

# as oracle
cd /home/oracle/product/fmw/oui/bin
./deinstall.sh -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 /home/oracle/product/
rm -rf fmw

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:

• OBIEE 12c: Installation Fails at Config Step: “Failed to build JDBC Connection object” (Doc ID 2319596.1)
• or OBIEE 12C: config.sh Fails with Error “MDS-00003: error connecting to the database java.sql.SQLRecoverableException: IO Error: Connection reset” (Doc ID 2095687.1)