Install BO 4.1 on Linux with Oracle database and Weblogic

(1)

Install BO 4.1 on Linux with Oracle database and Weblogic

Author: Piotr Mudlaff

Introduction

I decided to document complete installation process of: - Oracle Linux (Red Hat based)

- Oracle 11g database - Weblogic 10.3.6 - Business Objects 4.1

I tried to cover installation process from the beginning to the end at high level of details.

Overview

Software

Test/evaluation environment is composed of 2 machines:

Passwods

Machine Application User Password

Linux system root oracle

Linux system oracle oracle

Weblogic weblogic Admin123

Oracle Database sys Admin123

Oracle Database bo_cms Admin123

Oracle Database bo_audit Admin123

BO Administrator Admin123

Location Variables

$ORACLE_HOME /u01/app/oracle/product/11.2.0/dbhome_1 $JAVA_HOME /usr/java/jdk1.7.0_51 $MW_HOME /u01/app/oracle/product/fmw11g $WLS_HOME /u01/app/oracle/product/fmw11g/wlserver_10.3 $WL_DOMAIN_HOME /u01/app/oracle/product/fmw11g/user_projects/domains/webi_domain BO folder /u01/app/sap/boxi41 Client Software

Windows 7 Enterprise 64bit SAP BO Client tools

Oracle db client 32bit PL/SQL Developer Firefox 28.0, IE 10.0 Putty, Xming, winSCP

BI Server Software

Oracle Linux 6.5 64bit

Oracle db 11g 64bit (for CMC and audit) Weblogic 10.3.6 64 bit

(2)

Plan installation

Refer to pdf file: SAP BusinessObjects BI Platform 4.1 Supported Platforms (PAM)

 SAP BusinessObjects BI server components only support 64-bit operating systems  Only Java Application Server utilizing 64-bit JDK’s are supported

 Only 64-bit database connector middleware is supported

 It is recommended that you install the BI platform and run the WDeploy tool (wdeploy.sh) with the same user account used to install your web application server.

NOTE: ‘oracle’ user is used to run weblogic and Business Objects.

Install files

Application File(s) Download from

Oracle Linux Release 6 Update 5 Media Pack for x86_64 (64 bit)

V41362-01.iso http://www.oracle-base.com/articles/linux/oracle-linux-6-installation.php

JDK 7u51 64bit jdk-7u51-linux-x64.rpm

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html

Weblogic 10.3.6 64 bit wls1036_generic.jar http://www.oracle.com/technetwork/middleware/ias/downloads/wl s-main-097127.html

Oracle db 11.2 64bit linux.x64_11gR2_da tabase_1of2.zip linux.x64_11gR2_da tabase_2of2.zip

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

SAP BO 4.1 SP3 Linux 51047840_part1.exe 51047840_part2.rar

https://websmp208.sap-ag.de/pam SAP BO 4.1 SP3 Client

tools for windows

51047838_1.ZIP 51047838_2.ZIP

https://websmp208.sap-ag.de/pam Oracle database client for

Windows

win64_11gR2_client .zip

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html Oracle SQL Developer for

Windows

sqldeveloper-4.0.1.14.48-x64.zip

http://www.oracle.com/technology/software/products/sql/index.ht ml

Xming for Windows Xming-6-9-0-31-setup.exe

Xming-fonts-7-5-0-34-setup.exe

http://sourceforge.net/projects/xming/files/latest/download

Putty for Windows putty.exe http://www.chiark.greenend.org.uk/~sgtatham/putty/download.ht ml

WinSCP for Windows winscp510setup.exe http://winscp.net/eng/download.php

Install Linux

Existing partitions & boot

Install new Oracle Linux 6.5 on partition: /dev/sda7 – 80 GB; ext4; mount point “/” On the same physical drive there are already:

(3)

 Oracle Linux 6.4 (OBIEE - /dev/sda5 )  Ubuntu 12.04 (/dev/sda10)

In my case I select ‘First sector of boot partition - /dev/sda7’ and then add new Oracle Linux manually to global GRUB (GRUB was previously installed in MBR with Ubuntu installation. Config file: /dev/sda10 -> /boot/grub/grub.conf).

Start CD installer

System: Oracle Linux Release 6 Update 5 Media Pack for x86_64 (64 bit) Installation type ‘Oracle linux with basic graphical driver’

Hostname: lenovo.localdomain

Select components

Basic server

(4)

Add : Servers – System Administration tools

Add : Desktops – 3xDesktop, Fonts, Graphical administration tools, X Windows System

Add : Applications – Internet browser

Create user

(5)

Configure network

Log in to Oracle Linux 6.5 graphical interface as root. -> System -> Preferences -> Network connections

wlan0 – guest internet connection to local wifi (mainly for yum)  mark ‘connect automatically’

eth0 – local connection just for terminal from other desktop pc  mark ‘connect automatically’

 IPv4 Settings - Manual

To be able to use in parallel wireless connection for internet, and cable connection for console -> make wlan0 default gateway.

As root edit:

nano /etc/sysconfig/network GATEWAYDEV=wlan0

Modify /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.1.5 lenovo lenovo.localdomain

Then restart network:

/etc/init.d/network restart

IPTABLES security

nano /etc/rc.d/rc.local

iptables -I INPUT -p tcp --dport 1521 --syn -j ACCEPT iptables -I INPUT -p tcp --dport 7001 --syn -j ACCEPT iptables -I INPUT -p tcp --dport 8080 --syn -j ACCEPT iptables -I INPUT -p tcp --dport 6400 --syn -j ACCEPT iptables -I INPUT -p tcp --dport 6401 --syn -j ACCEPT iptables -I INPUT -p tcp --dport 6402 --syn -j ACCEPT iptables -I INPUT -p tcp --dport 6403 --syn -j ACCEPT iptables -I INPUT -p tcp --dport 6404 --syn -j ACCEPT iptables -I INPUT -p tcp --dport 6405 --syn -j ACCEPT iptables -I INPUT -p tcp --dport 6410 --syn -j ACCEPT

(6)

iptables -I INPUT -p tcp --dport 1158 --syn -j ACCEPT

REBOOT

Install yum packages

Command Reason

yum update Full system update

REBOOT

Command Reason

yum install gnome-utils.x86_64 Enable ‘PrintScreen’ button when logged in to gui interface yum install xterm.x86_64 To test windows applications.

yum install oracle-rdbms-server-11gR2-preinstall.x86_64 Oracle db prerequisites yum install compat-libstdc++-33.i686 BO Prerequisites yum install compat-libstdc++-33.x86_64 BO Prerequisites yum install libstdc++.i686 BO Prerequisites yum install libX11.i686 BO Prerequisites yum install glibc.i686 BO Prerequisites yum install libXext-devel.x86_64 BO Prerequisites

yum install libaio.x86_64 Oracle db prerequisites yum install libaio.i686 Oracle db prerequisites yum install compat-libstdc++-33.i686 Oracle db prerequisites yum install compat-libstdc++-33.x86_64 Oracle db prerequisites yum install elfutils-libelf-devel.i686 Oracle db prerequisites yum install elfutils-libelf-devel.x86_64 Oracle db prerequisites yum install libaio-devel.i686 Oracle db prerequisites yum install libaio-devel.x86_64 Oracle db prerequisites yum install libgcc.i686 Oracle db prerequisites yum install libgcc.x86_64 Oracle db prerequisites yum install libstdc++.i686 Oracle db prerequisites yum install libstdc++.x86_64 Oracle db prerequisites yum install unixODBC.i686 Oracle db prerequisites yum install unixODBC.x86_64 Oracle db prerequisites yum install unixODBC-devel.i686 Oracle db prerequisites yum install unixODBC-devel.x86_64 Oracle db prerequisites

(7)

yum install mksh.x86_64

Oracle db prerequisites (pdksh) In fact should do this:

wget ftp://rpmfind.net/linux/redhat- archive/6.2/en/os/i386/RedHat/RPMS/pdksh-5.2.14-2.i386.rpm rpm -e ksh-20100621-19.el6_4.4.i686 --nodeps rpm -ivh pdksh-5.2.14-2.i386.rpm Completed! Nothing to do REBOOT

Install Windows client tools

OS: Windows 7 64 bit

Turn on telnet

Telnet will be useful to test if services are listening on specific ports like:

Empty screen means that connection was established (expected result):

Network configuration

It’s needed to manually configure Ethernet interface. In our case we have dedicated Ethernet interface in windows client machine. It is additional USB Ethernet card.

(8)

Install and test Xming

Install:

 Xming-6-9-0-31-setup.exe  Xming-fonts-7-5-0-34-setup.exe

(9)

(10)

Connect to 192.168.1.5 with putty and test if it works. I use xterm to test:

Oracle DB Client Tools

Install Oracle Database Client Tools and separately SQL Developer (with embedded JDK).  win64_11gR2_client.zip

 sqldeveloper-4.0.1.14.48-x64.zip

G:\app\Pio\product\11.2.0\client_1\network\admin\tnsnames.ora

lenovo_orcl = (DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) (CONNECT_DATA =

(SERVER = DEDICATED) (SERVICE_NAME = orcl) )

)

For now we don’t have Oracle running yet so we can’t test.

Install BO Client tools

 51047838_1.ZIP

Client tools:

(11)

(12)

In start menu we get:

Install SDK

 51047838_2.ZIP

DK:

C:\Users\mudlapio\Desktop\51047838_2\SBOP_BI_PLAT_4.1_SP3_CLNT_WIN_32_64B_\DATA_UNITS\BusinessobjectsRuntime\64bit\setup.exe

Edit windows hosts

(13)

Edit: C:\Windows\System32\drivers\etc\hosts Add: 192.168.1.5 lenovo.localdomain

Test it:

Install Oracle Database

http://www.tecmint.com/oracle-database-11g-release-2-installation-in-linux/ !!!

http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r1/prod/install/dbinst/dbinst.htm

http://docs.oracle.com/cd/E11882_01/install.112/e47689.pdf

Change password for oracle user

passwd oracle oracle

90-nproc.conf

touch /etc/security/limits.d/90-nproc.conf nano /etc/security/limits.d/90-nproc.conf # Change this * soft nproc 1024 # To this * - nproc 16384

Set SELinux to “

permissive

” mode

nano /etc/selinux/config

(14)

Installation folder

[root@oracle]# mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1

Install user security

[root@oracle]# chown -R oracle:oinstall /u01 [root@oracle]# chmod -R 775 /u01

REBOOT

DB variables

Log in as ‘oracle’ nano /home/oracle/.bash_profile # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=lenovo.localdomain export ORACLE_UNQNAME=ORCL export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.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

XHOST

Make sure that XMing is running [root@oracle]# xhost +

RESTART

NOW LOG IN AS ‘oracle’

Copy install files to /usr/install/

 linux.x64_11gR2_database_1of2.zip  linux.x64_11gR2_database_2of2.zip As root:

mkdir /usr/install/

(15)

unzip -d /usr/install/oracle11/ /usr/install/linux.x64_11gR2_database_1of2.zip unzip -d /usr/install/oracle11/ /usr/install/linux.x64_11gR2_database_2of2.zip

Run installer

Run XMing and log in to database machine with putty on oracle user

Make sure that variables are set:

Run installer

cd

/usr/install/oracle11/database

./runInstaller

(16)

(17)

Before clicking ‘OK’ run as root: /u01/app/oraInventory/orainstRoot.sh /u01/app/oracle/product/11.2.0/dbhome_1/root.sh Response file:

TnsNames location

/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

(18)

Verify client connectivity from windows

Use with SQL Developer that was previously installed on windows client machine.  Click ‘Test’ at the bottom

Make database start automatically

http://matthiashoys.wordpress.com/2012/04/20/automatically-start-oracle-11g-on-oracle-linux-6-2-after-server-reboot/

[oracle@lenovo ~]$ nano /etc/oratab

[oracle@lenovo ~]$ mkdir /home/oracle/scripts

[oracle@lenovo ~]$ touch /home/oracle/scripts/ora_start.sh [oracle@lenovo ~]$ nano /home/oracle/scripts/ora_start.sh

(19)

#!/bin/bash

# script to start the Oracle database, listener and dbconsole . ~/.bash_profile

# start the listener and the database $ORACLE_HOME/bin/dbstart $ORACLE_HOME

# start the Enterprise Manager db console #$ORACLE_HOME/bin/emctl start dbconsole exit 0

[oracle@lenovo ~]$ touch /home/oracle/scripts/ora_stop.sh [oracle@lenovo ~]$ nano /home/oracle/scripts/ora_stop.sh

#!/bin/bash

# script to stop the Oracle database, listener and dbconsole . ~/.bash_profile

# stop the Enterprise Manager db console #$ORACLE_HOME/bin/emctl stop dbconsole

# stop the listener and the database $ORACLE_HOME/bin/dbshut $ORACLE_HOME

exit 0

chmod u+x /home/oracle/scripts/ora_start.sh chmod u+x /home/oracle/scripts/ora_stop.sh Test scripts:

Connect with telent from windows client:

[root@lenovo oracle]# touch /etc/init.d/oracle [root@lenovo oracle]# nano /etc/init.d/oracle #!/bin/bash

# chkconfig: 345 99 10

# description: Oracle auto start-stop script.

# Set ORA_OWNER to the user id of the owner of the # Oracle database in ORA_HOME.

ORA_OWNER=oracle RETVAL=0 case "$1" in 'start')

# Start the Oracle databases:

# The following command assumes that the oracle login # will not prompt the user for any values

su - $ORA_OWNER -c "/home/oracle/scripts/ora_start.sh" touch /var/lock/subsys/oracle

;; 'stop')

(20)

# The following command assumes that the oracle login # will not prompt the user for any values

su - $ORA_OWNER -c "/home/oracle/scripts/ora_stop.sh" rm -f /var/lock/subsys/oracle

;; *)

echo $"Usage: $0 {start|stop}" RETVAL=1

esac exit $RETVAL

[root@lenovo oracle]# chmod 750 /etc/init.d/oracle [root@lenovo oracle]# chkconfig --add oracle Check if service works ok

service oracle start service oracle stop

Verify if database starts automatically

REBOOT

Log in as ‘boxi’ user, connect to Oracle database remotely from windows client.

Install Weblogic

Install weblogic 64 bit as ‘oracle’ user.

http://www.oracle-base.com/articles/11g/oracle-weblogic-server-11gr1-1036-installation-on-oracle-linux-5-and-6-11gr1.php

Copy install files

 jdk-7u51-linux-x64.rpm  wls1036_generic.jar

(21)

Install java 1.7

rpm -Uvh /usr/install/jdk-7u51-linux-x64.rpm

Java is installed to ‘/usr/java/jdk1.7.0_51’

Prepare install folders

As ‘root’:

mkdir -p /u01/app/oracle/product/fmw11g mkdir -p /u01/app/oracle/config/domains mkdir -p /u01/app/oracle/config/applications

User security

chown -R oracle:oinstall /u01 chmod -R 775 /u01/

Configure variables

nano /home/oracle/.bash_profile # Weblogic settings export MW_HOME=/u01/app/oracle/product/fmw11g export WLS_HOME=$MW_HOME/wlserver_10.3 export WL_DOMAIN_HOME=$MW_HOME/user_projects/domains/webi_domain export WL_HOME=$WLS_HOME export JAVA_HOME=/usr/java/jdk1.7.0_51 export PATH=$JAVA_HOME/bin:$PATH REBOOT

Run Installer

Run installer as ‘oracle’ user !

(22)

(23)

->‘Getting started with WebLogic Server…’

(24)

Close window to finish.

(25)

nohup /u01/app/oracle/product/fmw11g/user_projects/domains/webi_domain/startWebLogic.sh

Test client connectivity from windows

http://192.168.1.5:7001/console/login/LoginForm.jsp

Memory settings

nano /u01/app/oracle/product/fmw11g/user_projects/domains/webi_domain/setDomainEnv.sh if [ "${JAVA_VENDOR}" = "Sun" ] ; then

WLS_MEM_ARGS_64BIT="-Xms512m -Xmx4096m" export WLS_MEM_ARGS_64BIT WLS_MEM_ARGS_32BIT="-Xms512m -Xmx4096m" export WLS_MEM_ARGS_32BIT else WLS_MEM_ARGS_64BIT="-Xms512m -Xmx4096m" export WLS_MEM_ARGS_64BIT WLS_MEM_ARGS_32BIT="-Xms512m -Xmx4096m" export WLS_MEM_ARGS_32BIT fi …. MEM_MAX_PERM_SIZE_64BIT="-XX:MaxPermSize=512m" export MEM_MAX_PERM_SIZE_64BIT MEM_MAX_PERM_SIZE_32BIT="-XX:MaxPermSize=512m" export MEM_MAX_PERM_SIZE_32BIT

Configure Weblogic

To configure weblogic in future:

/u01/app/oracle/product/fmw11g/wlserver_10.3/common/bin/config.sh

Make Weblogic start automatically

References:

Oracle support document (

Doc ID 877902.1, 980292.1)

http://wlsformsreports11g.blogspot.com/2011/09/automatic-startup-of-wls-servers-when.html

Set up security file

/u01/app/oracle/product/fmw11g/user_projects/domains/webi_domain/servers/AdminServer/security/boot.prope

rties

(26)

Create start up file touch /etc/init.d/wls nano /etc/init.d/wls #!/bin/bash

#

# oracle Init file for starting and stopping WLS #

# chkconfig: 35 99 30

# description: Oracle WLS startup script # Source function library

. /etc/rc.d/init.d/functions ORACLE_OWNER="oracle" DOMAIN_HOME="/u01/app/oracle/product/fmw11g/user_projects/domains/webi_domain" case "$1" in start) echo -n $"Starting WLS:"

su - $ORACLE_OWNER -c "$DOMAIN_HOME/bin/startWebLogic.sh > /dev/null 2>&1 &" echo "OK" ;; stop) echo -n $"Stopping WLS:" su - $ORACLE_OWNER -c "$DOMAIN_HOME/bin/stopWebLogic.sh" echo "OK" ;; *)

echo $"Usage: $0 {start|stop}" esac

Configure to run as service chmod 750

chkconfig --add wls --level 0356

Make sure that weblogic starts after database For database

# chkconfig: 345 98 31 For weblogic # chkconfig: 345 99 30

Install Business Objects

Ref: “Installing SAP BI 4.1 SP01 on Red Hat Enterpris.pdf” Ref: “sbo41sp3_bip_inst_unix_en.pdf”

(27)

http://www.clariba.com/blog/installing-sap-businessobjects-4-1-with-a-unix-like-architecture/ Run installation as ‘oracle’ user.

Prepare for BO installation

http://www.clariba.com/blog/installing-business-objects-on-linux-%E2%80%93-part-1-preparing-your-system/ Ref: "sbo41sp3_bip_wapd_unix_en.pdf”

Ref: “How to Set Up Oracle Weblogic Application Server for SAP BusinessObjects Business Intelligence Platform 4.pdf” Copy install files

Unpack files on windows and copy them to Linux machine:  51047840_part1.exe

 51047840_part2.rar

Prepare database

At this point I don’t care of rights at db level.

create user bo_cms identified by Admin123; grant dba to bo_cms;

create user bo_audit identified by Admin123; grant dba to bo_audit;

Set ulimit

[root@lenovo obi]# ulimit -s unlimited

Edit: nano /etc/security/limits.conf and modify existing entries to following:

oracle soft nproc 65535

oracle hard nproc 65535

oracle soft nofile 65535

oracle hard nofile 65535

By default for Oracle DB it was: # oracle-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024 oracle soft nofile 1024

# oracle-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536 oracle hard nofile 65536

# oracle-rdbms-server-11gR2-preinstall setting for nproc soft limit is 16384 # refer orabug15971421 for more info.

(28)

oracle soft nproc 16384

# oracle-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384 oracle hard nproc 16384

# oracle-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240KB oracle soft stack 10240

# oracle-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768KB oracle hard stack 32768

Verify Linux release nano /etc/redhat-release

We already have: Red Hat Enterprise Linux Server release 6.5 (Santiago) Prepare install folder

mkdir /u01/app/sap/boxi41 User security

chmod 777 -R /usr/install/boxi41_unp chown -R oracle:oinstall /u01/app/sap/boxi41 chmod -R 775 /u01/app/sap/boxi41

chmod -R 777 /u01/app/oracle/product/fmw11g/user_projects/domains/webi_domain/bin chmod -R 775 /usr/java/jdk1.7.0_51

chmod 755 -R /home/oracle

Not sure about it:

chmod 755 -R /u01/app/oracle/product/11.2.0/dbhome_1 chmod 755 -R /usr/lib/

Add variables

NOTE: ‘oracle’ user is used to run weblogic and Business Objects. nano /home/oracle/.bash_profile

Add:

# Business Objects settings export TZ="MET-1METDST" export LANG=en_US.utf8 export LC_ALL=en_US.utf8 #export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib:${LD_LIBRARY_PATH} export SQLPATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib:${SQLPATH} #export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export TNS_ADMIN=/u01/app/oracle/product/11.2.0/dbhome_1/network/admin export LIB_PATH=$ORACLE_HOME/lib #export PATH=$ORACLE_HOME/bin:$PATH export PERL_HOME="/u01/app/sap/boxi41/InstallData/setup.engine/perl" REBOOT

Verify prerequisites

Check if database is accessible

(29)

Check if weblogic is running http://192.168.1.5:7001/console/

Check basic system settings (only few variables are verified) cat /etc/redhat-release ulimit ulimit -u locale echo $TZ echo $LD_LIBRARY_PATH echo $ORACLE_HOME echo $JAVA_HOME echo $MW_HOME echo $WLS_HOME echo $WL_DOMAIN_HOME

(30)

Check if packages are installed rpm -qa compat-libstdc++* rpm -qa glibc rpm -qa libstdc++ rpm -qa libX11

Run Installer

Log in as ‘oracle’ user.

cd /usr/install/boxi41_unp/51047840/DATA_UNITS/BusinessObjectsServer_lnx ./setup.sh

(31)

(32)

Java web applications and web services are not deployed to a Web Application Server. Run the wDeploy tool to deploy Java web applications and web services. The WDeploy tool is located at: /u01/app/sap/boxi41//sap_bobj/enterprise_xi40/wdeploy/wdeployGUI.sh

To have your servers start and stop automatically when the host machine is started or stopped, run the following script as root user: /u01/app/sap/boxi41//sap_bobj/init/setupinit.sh To access the Monitoring tool for running diagnostic tests, log on to the Central Management Console (CMC), click the "Monitoring" button, and click the "Probes" tab.

Please launch /u01/app/sap/boxi41/sap_bobj/enterprise_xi40/wdeploy/wdeployGUI.sh after the installer exits.

Verify installation

Check if BO services are up: As ‘oracle’ user:

cd /u01/app/sap/boxi41/sap_bobj/

./ccm.sh -display -cms lenovo:6400 -username Administrator -password Admin123 -authentication secEnterprise

[oracle@lenovo sap_bobj]$ ./ccm.sh -display -cms lenovo:6400 -username Administrator -password Admin123 -authentication secEnterprise Creating session manager...

Logging onto CMS... Creating infostore...

Sending query to get all server objects on the local machine... Checking server status...

Server Name: lenovo_localdomain.CentralManagementServer State: Running

Enabled: Enabled

Host Name: lenovo.localdomain PID: 32601

Description: Central Management Server

Server Name: lenovo_localdomain.AdaptiveProcessingServer State: Running

Enabled: Enabled

(33)

Server Name: lenovo_localdomain.CrystalReportsCacheServer State: Running

Enabled: Enabled

Description: Crystal Reports Cache Server

Server Name: lenovo_localdomain.CrystalReports2013ProcessingServer State: Running

Enabled: Enabled

Description: Crystal Reports 2013 Processing Server Server Name: lenovo_localdomain.EventServer State: Running

Enabled: Enabled

Description: Event Server

Server Name: lenovo_localdomain.AdaptiveJobServer State: Running

Enabled: Enabled

Description: Adaptive Job Server

Server Name: lenovo_localdomain.InputFileRepository State: Running

Enabled: Enabled

Description: Input File Repository Server

Server Name: lenovo_localdomain.WebIntelligenceProcessingServer State: Running

Enabled: Enabled

Description: Web Intelligence Processing Server Server Name: lenovo_localdomain.DashboardsCacheServer State: Running

Enabled: Enabled

Description: Dashboards Cache Server Server Name: lenovo_localdomain.ConnectionServer State: Running

Enabled: Enabled

Description: Connection Server

Server Name: lenovo_localdomain.CrystalReports2013ReportApplicationServer State: Stopped

Enabled: Enabled

Host Name: lenovo.localdomain PID: -

Description: Crystal Reports 2013 Report Application Server Server Name: lenovo_localdomain.WebApplicationContainerServer State: Running

Enabled: Enabled

Description: Web Application Container Server

Server Name: lenovo_localdomain.DashboardsProcessingServer State: Running

Enabled: Enabled

Description: Dashboards Processing Server Server Name: lenovo_localdomain.OutputFileRepository State: Running

Enabled: Enabled

(34)

Server Name: lenovo_localdomain.CrystalReportsProcessingServer State: Running

Enabled: Enabled

Description: Crystal Reports Processing Server

Check if pearl folder is in place and properly pointed by variable: echo $PERL_HOME

Deploy Web applications to weblogic

As ‘oracle’ user:

/u01/app/sap/boxi41/sap_bobj/enterprise_xi40/wdeploy/wdeployGUI.sh

Application Server Domain Root Directory:

/u01/app/oracle/product/fmw11g/user_projects/domains/webi_domain

Server Instance: AdminServer Admin port: 7001

Admin user: weblogic Admin password: Admin123

Verify web app deployment

(35)

http://192.168.1.5:7001/BOE/BI http://192.168.1.5:7001/BOE/CMC

(36)

(37)

Configure ports

To be able to connect from Client tools several ports need to be unblocked. We need to do that in CMC (http://192.168.1.5:7001/BOE/CMC).

For each of following services set port manually (DO NOT USE ALREADY USED PORTS 6400, 6405, 6410)  lenovo_localdomain.CentralManagementServer -> Request Port: 6401

 lenovo_localdomain.ConnectionServer -> Request Port: 6402  lenovo_localdomain.InputFileRepository -> Request Port: 6403  lenovo_localdomain.OutputFileRepository -> Request Port: 6404

(38)

Restart changed services one by one:

NOTE: All of mentioned ports are unblocked on Linux (IPTABLES)

Test Designer Access

Run ‘Universe Design Tool’ from Windows client:

lenovo.localdomain:6400 Administrator

Admin123

Automatically start services

As ‘root’ user:

/u01/app/sap/boxi41/sap_bobj/init/setupinit.sh

REBOOT

Verify if BO starts automatically cd /mnt/data/sap_bo41/sap_bobj/

(39)

Try to access:  http://192.168.1.5:7001/BOE/BI  http://192.168.1.5:7001/BOE/CMC

Uninstall BO

Stop services

cd /u01/app/sap/boxi41/sap_bobj/ ./stopservers

Undeploy from weblogic

Run: /u01/app/sap/boxi41//sap_bobj/enterprise_xi40/wdeploy/wdeployGUI.sh Follow given steps

Remove files

rm -rf /u01/app/sap/boxi41

Remove startup

rm /etc/init.d/SAPBOBJEnterpriseXI40 rm /etc/rc.d/rc4.d/K01SAPBOBJEnterpriseXI40 rm /etc/rc.d/rc3.d/S99SAPBOBJEnterpriseXI40 rm /etc/rc.d/rc0.d/K01SAPBOBJEnterpriseXI40 rm /etc/rc.d/rc6.d/K01SAPBOBJEnterpriseXI40 rm /etc/rc.d/rc2.d/K01SAPBOBJEnterpriseXI40 rm /etc/rc.d/rc5.d/S99SAPBOBJEnterpriseXI40 rm /etc/rc.d/rc1.d/K01SAPBOBJEnterpriseXI40