How to install Oracle Business Intelligence 12c (12.2.1.0) on Linux

OS: Oracle Linux 6.8.

Prerequisites: An existing Oracle database 12.1.0.2.0 to hold the repository.  The OBI will be installed on the same server as where the database resides.  If the repository database does not exist yet then create it before the installation of OBI.

Before starting: Oracle strongly recommends using the AL32UTF8 character set for databases that support Oracle Fusion Middelware.  Otherwise create a database with AL32UTF8 character set to install the repository.  See step D below.

All Oracle software should be installed as for example the Linux user oracle and not root, except the java software.

A.- Check java version:

$ java -version

Minimum version: JDK8 – 1.8.0_40

Downloaded and installed java version: 1.8.0_161.

As root install the jdk on folder /usr/java:

$ tar zxdf jdk-8u161-linux-x64.tar.gz

The file bash_profile looks like the following:

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=gabriel
export ORACLE_UNQNAME=ORCL
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export ORACLE_SID=ORCL
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export JAVA_HOME=/usr/java/jdk1.8.0_161
export PATH=$JAVA_HOME/bin:$PATH

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi

B.- Download and install Oracle Fusion Middleware Infrastructure 12c, which contains Oracle Weblogic:

fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip

$ unzip fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip

The following file gets extracted:

fmw_12.2.1.0.0_infrastructure.jar

check out if VNC is installed on the server:

$ vncserver

Start vnc:

$ $JAVA_HOME/bin/java -d64 -jar  fmw_12.2.1.0.0_infrastructure.jar

Next

Next

Choose Oracle_Home and press Next

Choose Fusion Middleware Infrastructure.  I chose with examples, but you don’t have to.

Run the Prerequisite Checks and if no error messages appear press Next.

Next

Take a look at the summary and press Install.

Wait for the installation to complete.

The installation of Oracle FMW 12c completed successfully.

C.- Download and install OBIEE:

fmw_12.2.1.0.0_bi_linux64_Disk1_1of2.zip

fmw_12.2.1.0.0_bi_linux64_Disk1_2of2.zip

$ unzip -q fmw_12.2.1.0.0_bi_linux64_Disk1_1of2.zip
$ unzip -q fmw_12.2.1.0.0_bi_linux64_Disk1_2of2.zip
$ ./bi_platform-12.2.1.0.0_linux64.bin

Next

Next

Choose the same Oracle_Home as shown in section B above

Next

If all system configuration checks are ok proceed:

Next

Install

The installation of Oracle BI 12c completed successfully.

D.- Creating a Repository

$ cd $ORACLE_MW_HOME/oracle_common/bin
where 

ORACLE_MW_HOME=/u01/app/oracle/product/12.2.1/Middleware/Oracle_Home

$ ./rcu

Next

If you know the DBA credentials on the database press Next

Test the access on the database as sys from for example Oracle SQL Developer or SQL*PLUS.

Next

First issue: the character set of the repository database.  Now I have no choice but using the other character set.  That’s why it’s important to install on test server before installing in production environments.

Choose the components as shown below.  The prefix DEV is ok by default, but one may call it TEST or PROD  in order to reflex the purpose of the environment, for example DEMO.

Choose the password of the database schemas.  Make sure to remember those.

Next

Next

Press Save Response File and then Create

Close

E.- Configure OBIEE 12c:

$ cd $ORACLE_MW_HOME/bi/bin

$ ./config.sh

Select only Business Intelligence Enterprise Edition.  Next

Next

Next

It looks like I cannot come any further.  I pressed on button Next, but nothing happens.

It seems the password has to contain both letters and numbers.

Note the Prefix: DEV is the same one chosen earlier during the repository creation.

Next

Next

Configure

Finish

That’s it.

Some useful commands can be found on folder:

ORACLE_MW_HOME/user_projects/domains/bi/bitools/bin

For example: start.sh, status.sh, stop.sh

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *