Thursday, March 30, 2017

OBIEE 12C INSTALLATION IN LINUX_6.4_x64

Hai, in this article I will demonstrate Complete Installation of Oracle Business Intelligence 12c

download following OBIEE Software form the oracle website 

Download following Database Software



Major Steps Performed
   ·         Copy of files
   ·         Prerequisite checks for Installation
   ·         Up gradation of JAVA VERSION
   ·         Installation of 12C  RDBMS
   ·         installation of Web Logic Server
   ·         Installation of OBIEE
   ·         Configuration of OBIEE


Checklist Information
Enterprise Version
[root@rac1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.4 (Santiago)

OS Bit Version
[root@rac1 ~]# arch
x86_64

Hostname
[root@rac1 ~]# hostname
rac1.dell.com

Host IP
[root@rac1 ~]# hostname -i
192.168.1.11

Hostfile
[root@rac1 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.11    rac1.dell.com   rac1
[root@rac1 ~]#

Directory Structure
[root@rac1 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2              29G  8.6G   19G  32% /
tmpfs                 4.0G  100K  4.0G   1% /dev/shm
/dev/sda3              29G  182M   28G   1% /tmp
/dev/sda5             898G  200M  852G   1% /u01
.host:/               466G  245G  221G  53% /mnt/hgfs
[root@rac1 ~]#

Java Version (Download from Oracle Website)
[root@rac1 JAVA]# java -version
java version "1.7.0_09-icedtea"
OpenJDK Runtime Environment (rhel-2.3.4.1.0.1.el6_3-x86_64)
OpenJDK 64-Bit Server VM (build 23.2-b09, mixed mode)
[root@rac1 ~]#



Copy the below files to u01 folder “Database, Web logic, BI” and unzip
1. JDK file
[root@rac1 JAVA]# ll
total 219495
-rwxrwxrwx. 1 root root 167733100 Mar 29 08:29 jdk-8u121-linux-x64.rpm
[root@rac1 JAVA]#

2. Database(2 files)
[root@rac1 12C_DATABASE]# ll
drwxr-xr-x. 7 oraerp dbaerp       4096 Jul 11  2014 database
-rwxrwxrwx. 1 root root 1673519571 Feb 28 15:39 p21419221_121020_Linux-x86-64_1of10.zip
-rwxrwxrwx. 1 root root 1014527110 Feb 28 15:51 p21419221_121020_Linux-x86-64_2of10.zip
[root@rac1 12C_DATABASE]#

3. Weblogic
[root@rac1 WLS]# ll
-rwxr-xr-x. 1 oraerp dbaerp 1563217124 Mar 30 07:42 fmw_12.2.1.2.0_infrastructure.jar
-rwxrwxrwx. 1 root root 1563100157 Mar 28 11:22 fmw_12.2.1.2.0_infrastructure_Disk1_1of1.zip
[root@rac1 WLS]#

4. BI(2files) (unzip this two files in a separate folder as shown in bi_folder)
[root@rac1 BI]# ll
drwxrwxrwx. 1 oraerp dbaerp       4096 Mar 29 16:51 bi_folder
-rwxrwxrwx. 1 root root       2018426804 Mar 29 12:18 fmw_12.2.1.2.0_bi_linux64_Disk1_1of2.zip
-rwxrwxrwx. 1 root root       1084049639 Mar 29 12:09 fmw_12.2.1.2.0_bi_linux64_Disk1_2of2.zip
[root@rac1 ~]#

[root@rac1 ~]# cd bi_folder
[root@rac1 bi_folder]# ll
-rwxrwxrwx. 1 oraerp dbaerp 1084049435 Oct 11 01:23 bi_platform-12.2.1.2.0_linux64-2.zip
-rwxrwxrwx. 1 oraerp dbaerp 2018419110 Oct 11 01:23 bi_platform-12.2.1.2.0_linux64.bin
drwxrwxrwx. 1 oraerp dbaerp          0 Oct 11 05:43 Disk2
[root@rac1 bi_folder]#



Prerequisite checks for Installation

Creation of Central Inventory
[root@rac1 ~]# cat /etc/oraInst.loc
inventory_loc=/u01/oraInventory
inst_group=dbaerp
[root@rac1 ~]#
[root@rac1 ~]# mkdir -p /u01/oraInventory
[root@rac1 ~]#

Creation of Group and user
[root@rac1 ~]# groupadd dbaerp
[root@rac1 ~]# useradd -g dbaerp oraerp
[root@rac1 ~]#
[root@rac1 ~]#  passwd oraerp
Changing password for user oraerp.
New password:
BAD PASSWORD: it is based on a dictionary word
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully.
[root@rac1 ~]#
[root@rac1 JAVA]# su - oraerp
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ id
uid=54323(oraerp) gid=54324(dbaerp) groups=54324(dbaerp) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oraerp@rac1 ~]$

Changing Permission of u01
[root@rac1 ~]#
[root@rac1 ~]# chown -R oraerp:dbaerp /u01
[root@rac1 ~]#

Install all the Required RPMS for OBIEE INSTALLTION
binutils-2.23.52.0.1
compat-libcap1-1.10
compat-libstdc++-33-3.2.3 for x86_64
compat-libstdc++-33-3.2.3 for i686
gcc-4.8.2
gcc-c++-4.8.2
glibc-2.17 for x86_64
glibc-2.17 for i686
glibc-devel-2.17 for x86_64
libaio-0.3.109 for x86_64
libaio-devel-0.3.109 for x86_64
libgcc-4.8.2 for x86_64
libgcc-4.8.2 for i686
libstdc++-4.8.2 for x86_64
libstdc++-4.8.2 for i686
libstdc++-devel-4.8.2 for x86_64
ksh
make-3.82
ocfs2-tools-1.8.0
sysstat-10.1.5
numactl-2.0.9 for x86_64 (required for OBIEE-Essbase)
numactl-devel-2.0.9 for x86_64 (required for OBIEE-Essbase)

 ================================================================================================================
Linux Packages Installation without dependencies:
[root@rac1 R122rpms]#
[root@rac1 R122rpms]# rpm -ivh openmotif21-2.1.30-11.EL5.i386.rpm --nodeps --force
Preparing...                ########################################### [100%]
   1:openmotif21            ########################################### [100%]
[root@rac1 R122rpms]#
================================================================================================================


Upgradation of JDK
[root@rac1 JAVA]#
[root@rac1 JAVA]# java -version
java version "1.7.0_09-icedtea"
OpenJDK Runtime Environment (rhel-2.3.4.1.0.1.el6_3-x86_64)
OpenJDK 64-Bit Server VM (build 23.2-b09, mixed mode)
[root@rac1 ~]#
[root@rac1 JAVA]# ll
total 219495
-rwxrwxrwx. 1 root root 167733100 Mar 29 08:29 jdk-8u121-linux-x64.rpm
[root@rac1 JAVA]#
[root@rac1 JAVA]# rpm -ivh jdk-8u121-linux-x64.rpm
Preparing...                ########################################### [100%]
   1:jdk1.8.0_121           ########################################### [100%]
Unpacking JAR files...
        tools.jar...
        plugin.jar...
        javaws.jar...
        deploy.jar...
        rt.jar...
        jsse.jar...
        charsets.jar...
        localedata.jar...
[root@rac1 JAVA]#
[root@rac1 JAVA]# java -version
java version "1.8.0_121"
Java(TM) SE Runtime Environment (build 1.8.0_121-b13)
Java HotSpot(TM) 64-Bit Server VM (build 25.121-b13, mixed mode)
[root@rac1 JAVA]#



Installation of RDBMS 12.1.0.2 :
[oraerp@rac1 database]$
[oraerp@rac1 database]$ ll
total 72
drwxr-xr-x.  4 oraerp dbaerp  4096 Mar 30 07:44 install
-rwxr-xr-x.  1 oraerp dbaerp 33934 Aug  7  2015 readme.html
drwxrwxr-x.  2 oraerp dbaerp  4096 Jul  7  2014 response
drwxr-xr-x.  2 oraerp dbaerp  4096 Jul  7  2014 rpm
-rwxr-xr-x.  1 oraerp dbaerp  8533 Jul  7  2014 runInstaller
drwxrwxr-x.  2 oraerp dbaerp  4096 Jul  7  2014 sshsetup
drwxr-xr-x. 14 oraerp dbaerp  4096 Jul  7  2014 stage
-rwxr-xr-x.  1 oraerp dbaerp   500 Feb  6  2013 welcome.html
[oraerp@rac1 database]$ ./runInstaller


Installation option
(SELECT) Create and configure a database



System Class
(SELECT) Server Class




Global database name: orcl
Administrative password: oracle
Pluggable database name: pdborcl





Run root scripts when prompted
[root@rac1 ~]#
[root@rac1 ~]# /u01/app/oraerp/product/12.1.0/dbhome_1/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oraerp
    ORACLE_HOME=  /u01/app/oraerp/product/12.1.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
[root@rac1 ~]#
Creation of Database “orcl”




Installation of Web logic Server
[oraerp@rac1 WLS]$
[oraerp@rac1 WLS]$ ll
-rwxr-xr-x. 1 oraerp dbaerp 1563217124 Mar 30 07:42 fmw_12.2.1.2.0_infrastructure.jar
-rwxrwxrwx. 1 root root 1563100157 Mar 28 11:22 fmw_12.2.1.2.0_infrastructure_Disk1_1of1.zip
[oraerp@rac1 WLS]$
[oraerp@rac1 WLS]$ java -jar fmw_12.2.1.2.0_infrastructure.jar
Launcher log file is /tmp/OraInstall2017-03-30_08-46-07AM/launcher2017-03-30_08-46-07AM.log.
Extracting the installer . . . . . . . . . . . . . . . . . . . . Done
Checking if CPU speed is above 300 MHz.   Actual 3392.359 MHz    Passed
Checking monitor: must be configured to display at least 256 colors.   Actual 16777216    Passed
Checking swap space: must be greater than 512 MB.   Actual 29999 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 26327 MB    Passed


Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2017-03-30_08-46-07AM
Log: /tmp/OraInstall2017-03-30_08-46-07AM/install2017-03-30_08-46-07AM.log






Weblogic Home: /u01/oraerp/Oracle/Middleware/Oracle_Home







Installation of OBIEE
[oraerp@rac1 bi_folder]$
[oraerp@rac1 bi_folder]$ ll
-rwxrwxrwx. 1 oraerp dbaerp 1084049435 Oct 11 01:23 bi_platform-12.2.1.2.0_linux64-2.zip
-rwxrwxrwx. 1 oraerp dbaerp 2018419110 Oct 11 01:23 bi_platform-12.2.1.2.0_linux64.bin
drwxrwxrwx. 1 oraerp dbaerp          0 Oct 11 05:43 Disk2
[oraerp@rac1 bi_folder]$
[oraerp@rac1 bi_folder]$ /u01/software/bi_folder/bi_platform-12.2.1.2.0_linux64.bin
0%.................................................................100%
Launcher log file is /tmp/OraInstall2017-03-30_09-02-15AM/launcher2017-03-30_09-02-15AM.log.
Extracting the installer . . . . . . . . . . . . . . . . . . Done
Checking if CPU speed is above 300 MHz.   Actual 3392.359 MHz    Passed
Checking swap space: must be greater than 512 MB.   Actual 29999 MB    Passed


Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2017-03-30_09-02-15AM
Log: /tmp/OraInstall2017-03-30_09-02-15AM/install2017-03-30_09-02-15AM.log











Configuration of OBIEE
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ /u01/oraerp/Oracle/Middleware/Oracle_Home/bi/bin/config.sh
Starting Fusion Middleware Configuration Wizard for BIEE
ORACLE_HOME set as /u01/oraerp/Oracle/Middleware/Oracle_Home
BI_PRODUCT_HOME set as /u01/oraerp/Oracle/Middleware/Oracle_Home/bi
PATH set as /u01/oraerp/Oracle/Middleware/Oracle_Home/bi/bin:/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oraerp/bin
LD_LIBRARY_PATH set as /u01/oraerp/Oracle/Middleware/Oracle_Home/bi/lib
INSTALL_PROPERTIES /u01/oraerp/Oracle/Middleware/Oracle_Home/bi/../oui/mw/bi/metadata/config.properties
INSTALL_INVOCATION /u01/oraerp/Oracle/Middleware/Oracle_Home/bi/bin/../../oui/bin/launch.sh -clone ORACLE_HOME=/u01/oraerp/Oracle/Middleware/Oracle_Home -invPtrLoc /u01/oraerp/Oracle/Middleware/Oracle_Home/oraInst.loc -J-Doracle.as.install.engine.weblogic.config.mode=true -J-Doracle.config.mode=true -J-Doracle.as.install.engine.install.properties.location=/u01/oraerp/Oracle/Middleware/Oracle_Home/bi/../oui/mw/bi/metadata/config.properties -J-DSHIPHOME_STAGE_DIR=/u01/oraerp/Oracle/Middleware/Oracle_Home/bi/../oui/mw/bi
Launcher log file is /tmp/OraInstall2017-03-30_09-11-25AM/launcher2017-03-30_09-11-25AM.log.
Checking monitor: must be configured to display at least 256 colors.   Actual 16777216    Passed
Checking swap space: must be greater than 500 MB.   Actual 29999 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed


Log: /u01/oraInventory/logs/install2017-03-30_09-11-25AM.log







Usename weblogic
Password: weblogic1





Schema prefix: bi12c
Password: oracle
Usename sys
Password: oracle
Simple connect string: rac1.dell.com:1521:pdborcl







Save this page (bi_config)
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ cat /home/oraerp/bi_config
Configure
    Configuration
        Components
            Essbase
            BIEE
                OBIPS (Port 9507)
                Cluster controller (Main port 9508, monitor 9509)
                Java host (Port 9510)
                Scheduler (Main port 9511, monitor 9512, script 9513)
            BIP
        Domain
            BI Domain Name: bi
            Domains Directory: /u01/oraerp/Oracle/Middleware/Oracle_Home/user_projects/domains
            Admin server (HTTP port 9500, HTTPS 9501, internal 9504)
            Managed server (HTTP port 9502, HTTPS 9503, internal 9505)
        Database
            New schemas
                Database type: ORACLE
                Connect string: rac1.dell.com:1521:pdborcl
                New RCU prefix: bi12c
        Port Management
            Port range
                Port range start: 9500
                Port range end: 9999
        Application
            SampleAppLite
            Service Instance Key: ssi
            Service Instance Limit: 1
    Entry points
        WebLogic Console
            http://rac1.dell.com:9500/console
        Fusion Middleware Control
            http://rac1.dell.com:9500/em
        BI Publisher
            http://rac1.dell.com:9502/xmlpserver
        BI Analytics
            http://rac1.dell.com:9502/analytics






OBIEE 12C installation Complete

This article helps those who like to install OBIEE 12C in Linux Environment. 

Thanks for Reading

Regards,
Mohammed Areefuddin.
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)