SAP BI 4.2笔记(基于linux)

SAP BI安装过程中会创建两个标准数据库:
BO_AUDIT、BO_CMS.
BO_AUDIT数据库是记录用户操作日志的库;
BO_CMS数据库是记录报表用户、服务器配置、文档信息的库,这个库是最重要的库;
The Central Management Server (CMS) collects audit information from the other BI platform servers and writes the details to the Auditing Data Store (ADS), known as the Auditing database. This information lets System Administrators manage their BI platform environment, and content usage, through reporting and analysis of ADS data.
The CMS system database is used to store BI platform information, such as user, server, folder, document, configuration, and authentication details. It is maintained by the Central Management Server (CMS), and in other documentation may be referred to as the system database or repository.
The databases that are used to store reporting data are referred to as reporting databases.
根据需要,我们还可以专门建立一个Reporting Database,用于存放比如人工导入的数据、其他地方抽过来的数据等。


SAP BI4.2自带的数据库是Sybase,在SqlAnywhere(sybase)下面是创建BO_AUDIT、BO_CMS,可能名字是BI4_Audit和BI4_CMS


默认安装完的时候BI4_Audit和BI4_CMS的容量都非常小:
BI4_Audit大约有6M,BI4_CMS大约有30M。
BI4_Audit可以在后台设置自动清理的时间,例如100天;
BI4_CMS主要用来记录一些用户权限、报表信息(属性、设置啥的),一般增长也不会太大。
因为BI报表的数据应该存放在BW数据仓库中,而不是BO的数据库!


BO标准数据库的迁移大概三小时内就能做完,其他数据库可以慢慢迁移。
一般来说,BI4_Audit大约有有2GB左右,BI4_CMS大约100M以内。
迁移的时候注意编码,MySQL端应该是utf8或者utf8mb4,防止后面打开BOE后乱码。


兼容的操作系统:RHEL6.8,SLES12兼容的数据库:
SAP BI 4.2笔记(基于linux)

http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-5.6.34-1.el6.x86_64.rpm-bundle.tar


安装完BI,整体大约占用40GB硬盘(4GB的boot分区,‘10GB’的SWAP分区,15GB的BI数据,4GB的临时文件,其他为操作系统和常用应用)。
核心一点就是根分区和BI分区一定要预留够,否则后面很麻烦。


重要的路径:
/BIROOT/modifyOrRemoveProducts.sh   作用:卸载、更新、更改BI程序(组件)的安装。
/home/biconst/sqlanywhere   作用:数据库根目录(如果你的数据库不在此,那就在你定义的目录)
/home/biconst/sqlanywhere/database   作用:数据库数据,安装完约400MB
/home/biconst/sap_bobj   作用:BI核心程序的安装目录,安装完约15GB
/home/biconst/sap_bobj/enterprise_xi40   作用:BI核心应用中的核心,大约10GB
/home/biconst/sap_bobj/tomcat  作用:web容器根目录
/home/biconst/sap_bobj/tomcat/webapps   作用:java web应用,安装完约2GB
/home/biconst/sap_bobj/tomcat/work/Catalina/localhost  作用:tomcat的临时文件夹,安装完约2GB
/home/biconst/sap_bobj/logging  作用:BI系统的日志文件,报错了来这里查日志
SQLANYWHERE_CONFIGSCRIPT=/home/biconst/sqlanywhere/bin64/sa_config.sh
SQLANYWHERE_CMS_DBFILE=/home/biconst/sqlanywhere/database/BI4_CMS.db
SQLANYWHERE_AUDIT_DBFILE=/home/biconst/sqlanywhere/database/BI4_Audit.db
/home/biconst/sap_bobj/Data/PlatformSearchData  该目录不一定会有,但是如果有的话会占用非常大的空间,通常用100多GB。
4.2版的BI路径应该在这下面,和4.1有点不同。
WEB容器配置管理工具集:
注意:如果安装BI的过程中已经选择部署,则此处就不需要操作了。
/home/biconst/sap_bobj/enterprise_xi40/wdeploy

部署日志文件:
The WDeploy tool creates two log files with detailed information that may be useful for diagnosing problems or
monitoring activity.
wdeploy/logs/WDeploy_summary.log   概括性的日志
wdeploy/logs/WDeploy.log                          详细的日志
When a WDeploy command is issued, WDeploy_summary.log.01 is overwritten with the current command, and
WDeploy.log is appended.
As the WDeploy.log file grows to more than 512 KB, the file is renamed with a unique numbered suffix. For
example, WDeploy.log will be renamed to WDeploy.log.01. If a file named WDeploy.log.01 already exists,
WDeploy.log.02 will be created.

WAR文件集合:
/home/biconst/sap_bobj/enterprise_xi40/warfiles

workdir目录:
/home/biconst/sap_bobj/enterprise_xi40/wdeploy/workdir


start/stop
cd  /home/biconst/sap_bobj
./sqlanywhere_startup.sh
./sqlanywhere_shutdown.sh
./startservers
./stopservers
./tomcatstartup.sh
./tomcatshutdown.sh

访问:
http://domain/BOE/BI
http://domain/BOE/CMC


注意:由于各种原因,BI应用可能会发生内存溢出,发生时会在目录的logging下产生4GB左右的.hprof日志文件.
sap_bobj \logging\java_pid17204.hprof
这些文件会很快吞噬整块磁盘空间,导致最终没有可用空间,所以该目录需要每天监视!


配置iptables服务,将BI常用端口加入白名单

开启iptables,关闭selinux
配置iptables
以下配置的端口根据实际情况配置,注意数据库、SSH80tomcat的操作端口必须配置。
yum方式安装iptables
# yuminstall iptables-services
编辑防火墙配置文件
vi/etc/sysconfig/iptables
添加下面三句话到默认的22端口这条规则的下面
-A INPUT-p tcp -m state –state NEW -m tcp –dport 22 -j ACCEPT
-A INPUT-p tcp -m state –state NEW -m tcp –dport 80 -j ACCEPT
-A INPUT-p tcp -m state –state NEW -m tcp –dport 3306 -j ACCEPT
-A INPUT-p tcp -m state –state NEW -m tcp –dport 8080 -j ACCEPT
-A INPUT-p tcp -m state –state NEW -m tcp –dport 8443 -j ACCEPT
-A INPUT -p tcp -m state –state NEW -m tcp –dport 8005 -j ACCEPT
-A INPUT-p tcp -m state –state NEW -m tcp –dport 6400 -j ACCEPT
-A INPUT-p tcp -m state –state NEW -m tcp –dport 6410 -j ACCEPT
-A INPUT-p tcp -m state –state NEW -m tcp –dport 6405 -j ACCEPT
-A INPUT-p tcp -m state –state NEW -m tcp –dport 2638 -j ACCEPT
-A INPUT-p tcp -m state –state NEW -m tcp –dport 5801 -j ACCEPT
-A INPUT-p tcp -m state –state NEW -m tcp –dport 5901 -j ACCEPT

-AINPUT -p tcp -m state –state NEW -m tcp –dport 6001 -j ACCEPT

重启防火墙:
# /etc/init.d/iptables restart
必须要关闭系统自带的防火墙!!!(就因为这个问题,排查了一下午的错误,血与泪的教训啊,泥煤的MySQL报错不直接
简单的说,linux系统自带的SElinux是个垃圾,没法用,会导致MySQL等很多服务无缘无故启动不了,我们用iptables即可!!!
1. 永久关闭Selinux有效
  修改 /etc/selinux/config 文件中的 SELINUX=”” 为 disabled ,然后重启。
2. 即时生效(重启后无效)
  setenforce 0

校验是否安装成功
http://:/BOE/CMC
Substitute for the hostname of the web application server and for the web application
server\\\\\\’s listening port. If you are using a custom web application server root context or BOE.war web application
context, the URL will be different.
Log on as the Administrator user by typing Administrator into the User Name field and entering the
administrative password that you entered into the installation program.


安装必备的软件包:
注意:请不要自行安装JDK,BI安装过程中会自动安装,自行安装JDK会导致新的问题。
安装系统常用功能:
yum groupinstall “Compatibility libraries” “Base” “Development tools”
yum groupinstall “debugging Tools” “Dial-up Networking Support”

安装系统常用功能:
yum -y install tree nmap sysstat lrzsz dos2unix gcc* g tinyxml kernel wget net-tools psmisc screen vim links pcre pcre-devel zlib zlib-devel openssl openssl-devel cmake make zip unzip gzip bzip2* uuidd bc qt time ed perl ntp kernel-devel ntpdate libcurl libcurl-devel awk uname tar sty read which dirname id ulimit ping gcc-c glibc.i686

安装SAP BI要求的功能:
yum -y install libstdc .i686 install libstdc .x86_64 compat-libstdc -33.i686 compat-libstdc -33.x86_64 glibc.i686 glibc.x86_64 libX11.i686 libX11.x86_64 libXext.i686 libXext.x86_64 expat.i686 expat.x86_64 libgcc.i686 libgcc.x86_64 libXcursor.i686 libXcursor.x86_64 libXrender.i686 libXrender.x86_64 libXfixes.i686 libXfixes.x86_64 libxcb.i686 libxcb.x86_64 libXau.i686 libXau.x86_64 libXext-devel

然后执行一次yum更新:
yum –y update
yum –y upgrade


给RHEL6.8配置可用的yum源
注意:不要用最新版的RHEL,因为centos的更新发布比RHEL慢,如果用最新版的RHEL、则使用yum源的时候会找不到合适的版本。
操作步骤如下:
(关键点:卸载rhel自带的yum包的时候要注意忽略依赖关系、否则卸载不掉;安装yum的时候要注意全部一起安装,否则依赖关系没完没了)。

下载CENTOS6.8的yum安装包:
打开http://mirrors.163.com/centos/6.8/os/x86_64/Packages/,【CTRL F】搜索下面这些包,然后下载,然后上传到Linux。
yum
yum-metadata
yum-plugin-fastestmirror
yum-updateonboot
yum-utils

安装的时候如果提示有其他依赖再下载就是了。
然后执行下面的命令安装CENTOS的YUM工具:
rpm -qa |grep yum
rpm -qa|grep yum|xargs rpm -e –nodeps
rpm -ivh yum*

vi /etc/yum.repos.d/CentOS-Base.repo
粘贴下面的内容进去(然后wq保存,之后就能不注册redhat而使用centos的yum源了):
[base]
name=CentOS-$6.8 – Base – 163.com
#mirrorlist=http://mirrorlist.centos.org/?release=$6.8&arch=$basearch&repo=os
baseurl=http://mirrors.163.com/centos/6.8/os/$basearch/
gpgcheck=1
gpgkey=http://mirrors.163.com/centos/RPM-GPG-KEY-CentOS-6


#released updates
[updates]
name=CentOS-$6.8 – Updates – 163.com
#mirrorlist=http://mirrorlist.centos.org/?release=$6.8&arch=$basearch&repo=updates
baseurl=http://mirrors.163.com/centos/6.8/updates/$basearch/
gpgcheck=1
gpgkey=http://mirrors.163.com/centos/RPM-GPG-KEY-CentOS-6


#additional packages that may be useful
[extras]
name=CentOS-$6.8 – Extras – 163.com
#mirrorlist=http://mirrorlist.centos.org/?release=$6.8&arch=$basearch&repo=extras
baseurl=http://mirrors.163.com/centos/6.8/extras/$basearch/
gpgcheck=1
gpgkey=http://mirrors.163.com/centos/RPM-GPG-KEY-CentOS-6


#additional packages that extend functionality of existing packages
[centosplus]
name=CentOS-$6.8 – Plus – 163.com
baseurl=http://mirrors.163.com/centos/6.8/centosplus/$basearch/
gpgcheck=1
enabled=0
gpgkey=http://mirrors.163.com/centos/RPM-GPG-KEY-CentOS-6

参考:
http://sanwen8.cn/p/2a3DPxF.html
http://mirrors.163.com/centos/6.8/os/x86_64/Packages/
http://blog.sina.com.cn/s/blog_4ab15f5f0102w2y5.html


分区规划:
名称
作用
大小
/swap
剩余80%内容付费后可查看

本文作者: GavinDong

版权属于: GavinDong博客

文章链接: https://www.gavindong.com/1390.html

版权所有,转载时必须以链接形式注明作者和原始出处及本声明。

发表评论

登录后才能评论

评论列表(7条)

email