基于Redhat Linux安装SAP BI4.2 SP5

  • 7
  • 871 views
  • A+
所属分类:Notes

网络环境及硬件准备

1.联系网络管理员将域名指向BI所在的IP;

2.联系网络管理员开放BI所在IP的下列端口:

80
8080
8443
8005
6400
6410
6405
2638
5801
5901
6001

3.硬件准备

建议内存最小32GB,CPU最少12核,硬盘1TB。

下载安装文件

1.Redhat enterprise 7.3;

2.SAP BI4.2 SP5 for Linux;

3.MySQL 5.7;

 

安装Linux操作系统

1.最小化安装;

2.安装分区分三个区,boot分区2GB,SWAP分区32GB,根分区使用其他所有空间;

3.安装过程中要设置主机名、网络(自动启动)、时区(必须为UTC+8)等;

4.安装完后卸载默认的yum及rhn管理组件;

rpm -qa |grep yum

卸载所有列出的包;
rpm -qa|grep yum|xargs rpm -e --nodeps

rpm -qa |grep rhn

卸载所有列出的包;

rpm -qa|grep rhn|xargs rpm -e --nodeps

yum list all | grep subscription

卸载所有列出的包;

5.配置centos的更新yum源(略)

yum clean all

yum makecache

yum -y update

yum -y install epel-release
yum -y install htop

6.编辑/etc/hosts文件,设置主机名、域名绑定关系;

7.关闭防火墙(同时关闭selinux和iptables):

setenforce 0

编辑/etc/selinux/config,设置SELINUX=disabled

service iptables stop

chkconfig iptables off

8.修改ulimit值

vim /etc/security/limits.d/90-nproc.conf
* soft nproc 10240
* hard nproc 16384
* soft nofile 10240
* hard nofile 65536
* soft stack 10240

9.安装SAP BI4.2需要使用的包

yum install install libstdc++.i686
yum install install libstdc++.x86_64
yum install compat-libstdc++-33.i686
yum install compat-libstdc++-33.x86_64
yum install glibc.i686
yum install glibc.x86_64
yum install libX11.i686
yum install libX11.x86_64
yum install libXext.i686
yum install libXext.x86_64
yum install expat.i686
yum install expat.x86_64
yum install libgcc.i686
yum install libgcc.x86_64
yum install libXcursor.i686
yum install libXcursor.x86_64
yum install libXrender.i686
yum install libXrender.x86_64
yum install libXfixes.i686
yum install libXfixes.x86_64
yum install libxcb.i686
yum install libxcb.x86_64
yum install libXau.i686
yum install libXau.x86_64

10.重启系统

reboot

安装MySQL

注意MySQL编码必须是UTF8或者UTF8MB4.

创建两个数据库:BI_AUDIT和BI_CMS;

准备BI安装包

1.将下载的安装包解压后再压缩成zip文件,然后上传到linux。例如放在/sapteamn

cd /sapteamn

unzip abc.zip

cd /

chmod -R 777 /sapteam

2.配置ODBC

<BIP_INSTALL_DIR>/sap_bobj/enterprise_xi40/odbc.ini

例如:

[ODBC Data Sources]
BI4_CMS_DSN_1362069282=SQLAnywhere 16.0
[BI4_CMS_DSN_1362069282]
UID=dba
PWD=mypassword
DatabaseName=BI4_CMS
ServerName=BI4_1362069282
Host=192.0.2.0:2638
Driver=/opt/sqlanywhere16/lib64/libdbodbc16.so

安装BI

1.到解压文件目录下,执行安装: ./setup.sh

The installation log file is saved to <BIP_INSTALL_DIR>/InstallData/logs/<DATEandTIME>/
setupengine.log.

2.确认安装目录

The use of Unicode characters in the destination folder is not supported.
Ensure that the destination folder name does not contain spaces.
Ensure that the destination folder is not the same folder in which the installation program has been extracted (do not install to the current working directory when running the installation program from the current working directory)

3.语言包选择:English、Chinese和Traditional Chinese

4.安装方式选择

5.注意SVN一定要安装。

相关Notes

1771995 - Incorrect number of hierarchy levels in Design Time
1750788 - BICS metadata service enhancement
1767351 - Missing metadata of characteristics in the fix filter
1776999 - Incorrect hierarchy sorting
1777544 - Metadata missing for node type attributes
1778347 - Attributes for node types are not read
1770434 - Dynamic filter of compound char. is incorrect
1762156 - Nodes in fixed filter in Design Time are incorrect
1776688 - Too many hierarchy levels are read
1798297 - Correction for issue found on Samsung queries
1806813 - Text of characteristic values is not read
1809517 - Correction for invalid variable order when retrieving the list of variables through the design time services
1811124 - This note fixes the sorting of the of drill down characteristics returned by the design-time API so that it matches the runtime sorting
1812142 - This note fixes the sorting of the hierarchies returned by the design-time API so that it matches the runtime sorting
1817482 - This note adds the feature for the Design Time API to choose whether members should be read initially or not. By default, there are not read; this provides a performance enhancement for SL.

To configure the odbc.ini file for DataDirect connections

[pdfjs-viewer url="https%3A%2F%2Fwww.gavindong.com%2Fwp-content%2Fuploads%2F2017%2F12%2Fsbo42sp2_bip_inst_unix_en.pdf" viewer_width=100% viewer_height=500px fullscreen=true download=false print=true]

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

目前评论:7   其中:访客  7   博主  0

    • ag

      关闭防火墙:
      systemctl stop firewalld
      systemctl disable firewalld

      • ag

        如果安装的是英文本的操作系统,记得安装中文字体,否则BO某些地方会显示乱码:
        https://www.gavindong.com/computer/centos7-rhel7-windows-fonts.html

        • ag

          RHEL7.4的yum包:
          https://mirrors.aliyun.com/centos/7.4.1708/os/x86_64/Packages/

          • ag

            忘记管理员密码的解决办法:
            If the credentials for the BI platform administrator account are lost, consider whether another administrative account is available, and use it to change the password for the BI platform administrator account.
            If this is not possible, refer to SAP Knowledge Base Article 1679970 – How to reset the Administrator password in Business Intelligence Platform 4.X.

            • ag

              参考文档(谷歌搜索):
              sbo42sp2_bip_inst_unix_en.pdf
              sbo42sp2_bip_admin_en.pdf

              • ag

                You can create a report that uses a DataDirect DSN to define a connection to a data source. Before you upload this report to the BI platform, configure the BI platform odbc.ini file for the DataDirect connection used by the report

                • ag

                  Ensure that the installation destination folder is not the same folder in which the installation program
                  has been extracted (do not install to the current working directory when running the installation
                  program from the current working directory).