Sunday 20 May 2018

Step by Step Installation of OBIEE 12c in Oracle Enterprise Linux 6

Step by Step Installation of OBIEE 12c in Oracle Enterprise Linux 6

Below are the required steps we need to follow to install OBIEE in OEL6

1. Install JDK 
2. Install required prerequisite packages
3. Install weblogic
4. Install OBIEE 12c software
5. Install required database tablespaces using RCU.
6. Configure OBIEE with Middleware

Step 1: Install JDK

Download JDK software from below url


Copy the software to server and install JDK

[root@silver software]# ls -ltr jdk-8u171-linux-x64.rpm
-rwxr-x---. 1 root root 175262413 May 19 20:09 jdk-8u171-linux-x64.rpm
[root@silver software]# rpm -Uvh jdk-8u171-linux-x64.rpm
Preparing...                ########################################### [100%]
   1:jdk1.8                 ########################################### [100%]
Unpacking JAR files...
tools.jar...
plugin.jar...
javaws.jar...
deploy.jar...
rt.jar...
jsse.jar...
charsets.jar...
localedata.jar...

[root@silver software]# java -version
java version "1.8.0_171"
Java(TM) SE Runtime Environment (build 1.8.0_171-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.171-b11, mixed mode)
[root@silver software]#

Step 2: Install prerequisite packages 

Below packages can be installed using yum repository or RPM download.

compat-libcap1-1.10-1.x86_64
compat-libstdc++-33-3.2.3-69.el6.x86_64
libgcc-4.4.7-18.0.7.el6_9.2.x86_64
libstdc++-4.4.7-18.0.7.el6_9.2.x86_64
libstdc++-devel-4.4.7-18.0.7.el6_9.2.x86_64
sysstat-9.0.4-33.el6_9.1.x86_64
gcc-c++-4.4.7-18.0.7.el6_9.2.x86_64
glibc-2.12-1.209.0.3.el6_9.2.x86_64
glibc-devel-2.12-1.209.0.3.el6_9.2.x86_64

libaio-0.3.107-10.el6.x86_64

Step 3: Install Weblogic

Download Weblogic software (Fusion Middleware Infrastructure Installer) from below url.


Install Weblogic:

[oracle@silver OBIEE]$ java -jar fmw_12.2.1.0.0_infrastructure.jar
Launcher log file is /tmp/OraInstall2018-05-19_09-13-36PM/launcher2018-05-19_09-13-36PM.log.
Extracting files........................................
Starting Oracle Universal Installer

Checking if CPU speed is above 300 MHz.   Actual 2903.996 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 6999 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 3967 MB    Passed


Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2018-05-19_09-13-36PM
Log: /tmp/OraInstall2018-05-19_09-13-36PM/install2018-05-19_09-13-36PM.log


Click "Next"


Select "Skip Auto Updates" and click "Next"


Select Middleware home location and click "Next"


Select "Fusion Middleware Infrastructure with Examples" and click "Next"


Click "Next"


Deselect security updates option and click "Next"


Click on "Yes"


Click on "Install"



Click on "Next"


Click "Finish".

Step 4: Install OBIEE 12c Software

[oracle@silver OBIEE]$ ./bi_platform-12.2.1.0.0_linux64.bin 
0%...................................................................................................100%
Launcher log file is /tmp/OraInstall2018-05-19_09-51-18PM/launcher2018-05-19_09-51-18PM.log.
Starting Oracle Universal Installer

Checking if CPU speed is above 300 MHz.   Actual 2903.996 MHz    Passed
Checking swap space: must be greater than 512 MB.   Actual 6999 MB    Passed


Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2018-05-19_09-51-18PM
Log: /tmp/OraInstall2018-05-19_09-51-18PM/install2018-05-19_09-51-18PM.log


Click "Next"


Select "Skip Auto Updates" and click "Next"


Select BI home location and click on "Next"


Select "BI Platform Distribution with Samples" and click "Next"


Click "Next"


Click on "Install"


Click "Next"


Click "Finish"


Step 5: Install required database tablespaces using RCU

We can run RCU tool from either windows or linux. 

Running RCU.......

[oracle@silver bin]$ pwd
/u01/software/OBIEE/RCU/rcuHome/bin
[oracle@silver bin]$ ./rcu


Click "Next"


Select "Create" and click "Next"


Provide server name where database running , port number, service_name of database and click on "Next"


Click "OK"


Select "Business Intelligence" related components and click "Next"


Click "OK"


Provide password for schemas. Make a note of this passwod.


Click "Next"


Click on "OK"


Click on "OK"


Click on "Create"


Click on "Close"

Step 6: Configure OBIEE with Middleware

Configure OBIEE by running config.sh which is under ORACLE_HOME/bi/bin

[oracle@silver bin]$ pwd
/u01/app/Middleware/Oracle_Home/bi/bin

[oracle@silver bin]$ ls
config.cmd  config.sh  vcredist_x64.exe

[oracle@silver bin]$ ./config.sh 
Starting Fusion Middleware Configuration Wizard for BIEE
ORACLE_HOME set as /u01/app/Middleware/Oracle_Home
BI_PRODUCT_HOME set as /u01/app/Middleware/Oracle_Home/bi
PATH set as /u01/app/Middleware/Oracle_Home/bi/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin
LD_LIBRARY_PATH set as /u01/app/Middleware/Oracle_Home/bi/lib
INSTALL_PROPERTIES /u01/app/Middleware/Oracle_Home/bi/../oui/mw/bi/metadata/config.properties
INSTALL_INVOCATION /u01/app/Middleware/Oracle_Home/bi/bin/../../oui/bin/launch.sh -clone ORACLE_HOME=/u01/app/Middleware/Oracle_Home -invPtrLoc /u01/app/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/app/Middleware/Oracle_Home/bi/../oui/mw/bi/metadata/config.properties -J-DSHIPHOME_STAGE_DIR=/u01/app/Middleware/Oracle_Home/bi/../oui/mw/bi
Launcher log file is /tmp/OraInstall2018-05-19_11-28-16PM/launcher2018-05-19_11-28-16PM.log.
Starting Oracle Universal Installer

Checking monitor: must be configured to display at least 256 colors.   Actual 16777216    Passed
Checking swap space: must be greater than 500 MB.   Actual 6999 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed


Log: /u01/app/oraInventory/logs/install2018-05-19_11-28-16PM.log


Click on "Next"


Click on "Next"


Provide password for weblogic and click on "Next"




Provide new schema name and username/password. Click on "Next"


Click on "Next"



Select "Oracle sample application" and click on "Next"



Click on "Configure"



Click "Next"


Click on "Finish"

Validation:

BI Analytics login:

http://silver.apps.com:9502/analytics





Provide weblogic and weblogic user password to login


Click on "Visual Analyzer Projects"





Admin console Login:

http://silver.apps.com:9500/console/console


EM console login:

http://silver.apps.com:9500/em





Visual Analyzer login:

http://silver.apps.com:9502/va



BI Publisher login:

http://silver.apps.com:9502/xmlpserver



Thanks for your patience to view my post........









4 comments:

  1. WHile installing Bi 12.2.1.2 i am getting this error lib/libclntsh.so.11.1.dbl file not found in Middleware/Oracle_home/lib.

    ReplyDelete
  2. I wish to show thanks to you just for bailing me out of this particular trouble. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle Fusion Product Hub.Actually I was looking for the same information on internet for Oracle PPM Cloud and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete