安裝SAP HANA 2.0 在RHEL7
SAP HANA
SAP HANA是一個完整的數據庫和應用程序開發平台。它結合符合ACID標準的數據庫，高速分析，應用服務和靈活的數據採集工具。 您可以使用高級數據處理功能（文本，空間，預測等）來構建智能應用程序，從而提供各種類型數據的洞察。 以下是用的SAP HANA開發人員版本安裝。
安裝前準備
下載
SAP HANA, express edition (free開發版本)
- 平台：Linux/x86_64
- 映像檔：Binary Installer
- 版號51053061_HANA2_30
硬體配置
| 硬體 | 規格 |
| CPU | 4 Cores |
| RAM | 24GB |
| HDD | 16G、110G |
作業系統配置
版本：Red Hat Enterprise Linux 7.2 for x86-64
套件選擇：minimal
檔案系統劃分：
配置主機名稱與解析
|
1 |
# hostnamectl set-hostname erpprddb01.skywebster.com |
確保/etc/hosts也有相對應的名稱解析
|
1 2 |
# cat /etc/hosts 192.168.1.101 erpprddb01.skywebster.com erpprddb01 |
主機檢查 -s 主機名稱(短); -f FQDB -d 網域名稱
|
1 2 3 |
# hostname -s # hostname -f # hostname -d |
配置內部名稱伺服器
|
1 2 3 4 5 |
# cat /etc/resolv.conf # Generated by NetworkManager search skywebster.com nameserver 192.168.1.1 nameserver 192.168.1.2 |
名稱解析檢查
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
# nslookup erpprddb01.skywebster.com Server: 192.168.1.1 Address: 192.168.1.1#53 Non-authoritative answer: Name: erpprddb01.skywebster.com Address: 192.168.1.101 # nslookup 192.168.1.101 Server: 192.168.1.1 Address: 192.168.1.1#53 Non-authoritative answer: 101.1.168.192.in-addr.arpa name = erpprddb01.skywebster.com. Authoritative answers can be found from: erpprddb01.skywebster.com internet address = 192.168.1.101 |
RHEL for SAP HANA訂閱
註冊帳號
可以利用公司的網域註冊紅帽的帳號去申請頻估版30天授權
註冊到Red Hat Customer Portal or to Red Hat Satellite server 6
|
1 |
# subscription-manager register [email protected] --password=XXXXXXXXXX |
顯示目前可用的註冊，30天評估版會如下
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 |
# subscription-manager list --available +-------------------------------------------+ Available Subscriptions +-------------------------------------------+ Subscription Name: 30 Day Evaluation of Red Hat Enterprise Linux for SAP Solutions, Self-Supported Provides: dotNET on RHEL Beta (for RHEL Server) Red Hat Enterprise Linux for SAP Red Hat Ansible Engine RHEL for SAP HANA - Update Services for SAP Solutions Red Hat Enterprise Linux Scalable File System (for RHEL Server) - Extended Update Support RHEL for SAP HANA - Extended Update Support Red Hat Enterprise Linux Atomic Host Beta Red Hat Enterprise Linux High Availability (for RHEL Server) - Extended Update Support Red Hat Beta Red Hat EUCJP Support (for RHEL Server) - Extended Update Support Red Hat Enterprise Linux Load Balancer (for RHEL Server) - Extended Update Support dotNET on RHEL (for RHEL Server) Red Hat Enterprise Linux High Availability - Update Services for SAP Solutions Oracle Java (for RHEL Server) Red Hat Enterprise Linux Server - Update Services for SAP Solutions Red Hat Software Collections (for RHEL Server) Red Hat Enterprise Linux High Availability (for RHEL Server) Red Hat Enterprise Linux High Performance Networking (for RHEL Server) - Extended Update Support RHEL for SAP - Update Services for SAP Solutions Oracle Java (for RHEL Server) - Extended Update Support Red Hat Enterprise Linux Atomic Host Red Hat Enterprise Linux Server - Extended Update Support Red Hat Software Collections Beta (for RHEL Server) Red Hat Enterprise Linux Server RHEL for SAP - Extended Update Support Red Hat Developer Toolset (for RHEL Server) Red Hat Enterprise Linux Resilient Storage (for RHEL Server) - Extended Update Support Red Hat Enterprise Linux for SAP Hana Red Hat S-JIS Support (for RHEL Server) - Extended Update Support SKU: SER0519 Contract: 11755477 Pool ID: 8a85f99a65c8c8a10165ece861232c89 Provides Management: No Available: 2 Suggested: 1 Service Level: Self-Support Service Type: L1-L3 Subscription Type: Instance Based Ends: 10/18/2018 System Type: Physical Subscription Name: 30 Day Self-Supported Red Hat Enterprise Linux for Power with Smart Management (Up to 15 LPARs) Evaluation Provides: Red Hat Enterprise Linux High Availability (for IBM Power LE) - Extended Update Support Red Hat Beta Red Hat Enterprise Linux High Availability (for IBM Power LE) Red Hat Enterprise Linux for Power, big endian Red Hat Enterprise Linux for Power, little endian Red Hat Ansible Engine Red Hat Enterprise Linux Resilient Storage (for IBM Power LE) Red Hat Enterprise Linux Resilient Storage (for IBM Power LE) - Extended Update Support Red Hat Enterprise Linux for Power 9 Red Hat Enterprise Linux for Power, little endian Beta Red Hat Developer Tools (for RHEL Server for IBM Power LE) Red Hat Developer Tools Beta (for RHEL Server for IBM Power LE) SKU: RH00396 Contract: 11752296 Pool ID: 8a85f99c65c8c91bXXXXcc48828f0c8b Provides Management: Yes Available: 15 Suggested: 1 Service Level: Self-Support Service Type: L1-L3 Subscription Type: Stackable Ends: 10/12/2018 System Type: Physical Subscription Name: 30 Day Evaluation of Red Hat Enterprise Linux for SAP Solutions, Self-Supported Provides: dotNET on RHEL Beta (for RHEL Server) Red Hat Enterprise Linux for SAP Red Hat Ansible Engine RHEL for SAP HANA - Update Services for SAP Solutions Red Hat Enterprise Linux Scalable File System (for RHEL Server) - Extended Update Support RHEL for SAP HANA - Extended Update Support Red Hat Enterprise Linux Atomic Host Beta Red Hat Enterprise Linux High Availability (for RHEL Server) - Extended Update Support Red Hat Beta Red Hat EUCJP Support (for RHEL Server) - Extended Update Support Red Hat Enterprise Linux Load Balancer (for RHEL Server) - Extended Update Support dotNET on RHEL (for RHEL Server) Red Hat Enterprise Linux High Availability - Update Services for SAP Solutions Oracle Java (for RHEL Server) Red Hat Enterprise Linux Server - Update Services for SAP Solutions Red Hat Software Collections (for RHEL Server) Red Hat Enterprise Linux High Availability (for RHEL Server) Red Hat Enterprise Linux High Performance Networking (for RHEL Server) - Extended Update Support RHEL for SAP - Update Services for SAP Solutions Oracle Java (for RHEL Server) - Extended Update Support Red Hat Enterprise Linux Atomic Host Red Hat Enterprise Linux Server - Extended Update Support Red Hat Software Collections Beta (for RHEL Server) Red Hat Enterprise Linux Server RHEL for SAP - Extended Update Support Red Hat Developer Toolset (for RHEL Server) Red Hat Enterprise Linux Resilient Storage (for RHEL Server) - Extended Update Support Red Hat Enterprise Linux for SAP Hana Red Hat S-JIS Support (for RHEL Server) - Extended Update Support SKU: SER0519 Contract: 11755477 Pool ID: 8a85f99a65c8c8aXXXX5ece861d32c8f Provides Management: No Available: Unlimited Suggested: 1 Service Level: Self-Support Service Type: L1-L3 Subscription Type: Instance Based Ends: 10/18/2018 System Type: Virtual |
依照主機的類型將此訂閱加入此系統中
|
1 |
# subscription-manager attach --pool=8a85f99a65c8c8aXXXX5ece861d32c8f |
啟用SAP HANA 所需的YUM源
設定OS的發行版本的YUM源
|
1 2 3 |
# subscription-manager release --set=7.2 # yum clean all # subscription-manager repos --disable="*" |
設定SAP HANA的YUM源(x86_64 平台)
|
1 |
# subscription-manager repos --enable="rhel-sap-hana-for-rhel-7-server-eus-rpms" --enable="rhel-7-server-eus-rpms" |
設定SAP HANA的YUM源(ppc64le 平台)
|
1 |
# subscription-manager repos --enable="rhel-sap-hana-for-rhel-7-for-power-le-eus-rpms" --enable="rhel-7-for-power-le-eus-rpms" |
設定高可用的YUM源(如果有計畫要做HA)
|
1 |
# subscription-manager repos --enable="rhel-ha-for-rhel-7-server-eus-rpms" |
檢視安裝來源
|
1 2 3 4 5 6 |
# yum repolist repo id repo name status rhel-7-server-eus-rpms/x86_64 Red Hat Enterprise Linux 7 Server - Extended Update Support (RPMs) 11,969 rhel-ha-for-rhel-7-server-eus-rpms/x86_64 Red Hat Enterprise Linux High Availability (for RHEL 7 Server) - Extended Update Support (RPMs) 234 rhel-sap-hana-for-rhel-7-server-eus-rpms/x86_64 RHEL for SAP HANA (for RHEL 7 Server) Extended Update Support (RPMs) 20 repolist: 12,223 |
將Minimal或Core轉成Base環境
mark: 標記過後的組，如果刪除該組，yum將刪除該組，並僅刪除因組安裝/升級命令而安裝的那些軟件包，不會刪除之前的相依套件。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
# yum groups summary Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager Available Environment Groups: 6 Installed Groups: 2 Available Groups: 8 Done # yum grouplist Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager Available Environment Groups: Minimal Install Infrastructure Server File and Print Server Basic Web Server Virtualization Host Server with GUI Installed Groups: Security Tools System Administration Tools Available Groups: Compatibility Libraries Console Internet Tools Development Tools Graphical Administration Tools Legacy UNIX Compatibility Scientific Support Smart Card Support System Management Done # yum group mark convert # yum -y groupinstall base |
安裝其他所需的套件
|
1 2 3 4 |
# yum install gtk2 libicu xulrunner sudo tcsh libssh2 expect cairo graphviz \ iptraf-ng krb5-workstation krb5-libs libpng12 nfs-utils lm_sensors rsyslog openssl \ PackageKit-gtk3-module libcanberra-gtk2 libtool-ltdl xorg-x11-xauth numactl \ xfsprogs net-tools bind-utils -y |
安裝GCC 6 C++ Runtime Compatibility Libraries
SAP HANA 2.0 SP02以上 需要compat-sap-c++-6
之前的版本是用compat-sap-c++-5
|
1 |
# yum install compat-sap-c++-6 -y |
更新套件
|
1 |
# yum update -y |
配置較時伺服器
|
1 |
# yum install chrony -y |
配置NTP服務器
|
1 2 3 4 5 |
# grep ^server /etc/chrony.conf server tock.stdtime.gov.tw iburst server watch.stdtime.gov.tw iburst server time.stdtime.gov.tw iburst server clock.stdtime.gov.tw iburst |
啟動服務，設開機時啟動，檢查服務
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
# systemctl restart chronyd.service # systemctl enable chronyd.service # systemctl restart systemd-timedated.service # chronyc sources 210 Number of sources = 4 MS Name/IP address Stratum Poll Reach LastRx Last sample =============================================================================== ^+ 211-22-103-157.hinet-ip.h 2 6 17 44 +1075us[+1125us] +/- 77ms ^* 118-163-81-63.hinet-ip.hi 2 6 17 44 +23us[ +62us] +/- 39ms ^+ 118-163-81-61.hinet-ip.hi 2 6 17 44 -622us[ -577us] +/- 47ms ^+ 211-22-103-158.hinet-ip.h 2 6 17 44 -38us[ +19us] +/- 26ms # chronyc tracking Reference ID : 211.22.103.158 (211-22-103-158.hinet-ip.hinet.net) Stratum : 3 Ref time (UTC) : Sat Sep 22 17:28:51 2018 System time : 0.000351050 seconds fast of NTP time Last offset : +0.000399611 seconds RMS offset : 0.000399611 seconds Frequency : 19.471 ppm slow Residual freq : +0.030 ppm Skew : 53.939 ppm Root delay : 0.003247 seconds Root dispersion : 0.026049 seconds Update interval : 63.6 seconds Leap status : Normal |
配置儲存
以下配置應該是依照顧問需求，這裡的大小只是做LAB用。
儲存規劃
參考： SAP HANA TDI Storage Requirements Guide
使用SAN儲存
參考：DM Multipath Configuration and Administration
檢視MPIO
SAN架構正常應該有4個路徑(有2個交換機，2個控制器)
|
1 |
# multipath -ll |
建一個VG，名為vghana之後再建四個LV，lvdata、lvlog、lvshared、lvusrsap
分別掛給對應的檔案系統(Lab略過)。
使用內部儲存
格式化硬碟
|
1 2 3 4 5 6 7 8 9 |
# lsblk NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sr0 11:0 1 3.8G 0 rom vda 252:0 0 16G 0 disk |-vda1 252:1 0 500M 0 part /boot `-vda2 252:2 0 15.5G 0 part |-rhel-root 253:0 0 10G 0 lvm / `-rhel-swap 253:1 0 5.5G 0 lvm [SWAP] vdb 252:16 0 110G 0 disk |
將vdb -> LVM(8E)
Legacy BIOS + MBR
|
1 |
# fdisk /dev/vdb |
UEFI +GPT(> 2TB)
|
1 |
# parted /dev/vdb |
創建PV
|
1 |
# pvcreate /dev/vdb1 |
創建VG
|
1 |
# vgcreate vg_hana /dev/vdb1 |
創建LV
|
1 2 3 4 5 |
# lvcreate -L 24G -n lv_hana_shared vg_hana # lvcreate -L 24G -n lv_hana_data vg_hana # lvcreate -L 12G -n lv_hana_log vg_hana # lvcreate -L 50G -n lv_usr_sap vg_hana <-如果畫到滿會差一個extent，正式環境會保留應該不會發生 # lvcreate -l 12799 -n lv_usr_sap vg_hana |
創建檔案系統
為了對XFS檔案系統的最佳話
參考：What are some of best practices for tuning XFS filesystems
經過紅帽的工具1(File System Layout Calculator) 工具2(LVM RAID Calculator)
做最佳化後創建檔案系統的指令可能會如下
|
1 |
# mkfs.xfs -b 4096 -d su=64k,sw=2 /dev/mydevice |
如果是軟體的RAID就用預設參數即可 -> 不過在X86設備應該都用硬體的RAID
創建掛載點
|
1 2 |
# mkdir -p /hana/{shared,data,log} # mkdir -p /usr/sap |
以下檔案系統創建時使用預設參數，因為是LAB環境
|
1 2 3 4 |
# mkfs -t xfs /dev/vg00/lv_hana_shared # mkfs -t xfs /dev/vg00/lv_hana_data # mkfs -t xfs /dev/vg00/lv_hana_log # mkfs -t xfs /dev/vg00/lv_usr_sap |
寫入到/etc/fstab
第六欄位的數字表示，當系統不正常關機時檔案系統的檢查順序，愈小愈優先
|
1 2 3 4 5 6 7 8 |
# echo "/dev/vg_hana/lv_hana_shared /hana/shared xfs defaults 1 3" \ >> /etc/fstab # echo "/dev/vg_hana/lv_hana_data /hana/data xfs defaults 1 4" \ >> /etc/fstab # echo "/dev/vg_hana/lv_hana_log /hana/log xfs defaults 1 5" \ >> /etc/fstab # echo "/dev/vg_hana/lv_usr_sap /usr/sap xfs defaults 1 6" \ >> /etc/fstab |
測試掛載
|
1 |
# mount -avt xfs |
利用tuned對OS效能最佳化
紅帽有開發一個專門為SAP HANA 做系統最佳化的tuned 設定檔
安裝套件
|
1 |
# yum -y install tuned-profiles-sap-hana |
啟動服務並設開機啟動
|
1 2 |
# systemctl restart tuned # systemctl enable tuned |
如果是裝在實體機、紅帽的虛擬化平台上使用
|
1 |
# tuned-adm profile sap-hana |
如果是裝在VMware的虛擬化平台上
|
1 |
# tuned-adm profile sap-hana-vmware |
檢視目前使用的profile
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
# tuned-adm list Available profiles: - balanced - desktop - latency-performance - network-latency - network-throughput - powersave - sap-hana - sap-hana-vmware - throughput-performance - virtual-guest - virtual-host Current active profile: sap-hana |
關閉SELinux
SELinux 關閉之後重開機會生效
|
1 2 3 4 5 6 7 |
# setenforce 0 # sed -i 's/\(SELINUX=enforcing\|SELINUX=permissive\)/SELINUX=disabled/g' \ /etc/selinux/config # sestatus SELinux status: disabled # getenforce Disabled |
關閉內核的自動平衡NUMA功能
由於SAP HANA是NUMA（non-uniform memory access），因此它不依賴於Linux內核功能來自動優化NUMA使用。因此，應禁用Linux內核的自動NUMA平衡功能。
調整內和參數
|
1 |
# echo "kernel.numa_balancing = 0" > /etc/sysctl.d/sap_hana.conf |
生效
|
1 |
# sysctl -p /etc/sysctl.d/sap_hana.conf |
檢視
|
1 |
# sysctl kernel.numa_balancing |
關閉RHEL7 提供的自動平衡numa的服務numad
|
1 2 3 |
# systemctl status numad # systemctl stop numad # systemctl disable numad |
增加軟連結
由於SAP HANA編譯建的函式庫版本可能跟紅帽的函式庫名稱不同，故做一個軟連結
|
1 2 |
# ln -s /usr/lib64/libssl.so.10 /usr/lib64/libssl.so.1.0.1 # ln -s /usr/lib64/libcrypto.so.10 /usr/lib64/libcrypto.so.1.0.1 |
關閉Transparent Huge Pages
透明大頁面（THP）是一種Linux內存管理系統，通過使用更大的內存頁面，可以減少具有大量內存的計算機上的Translation Lookaside Buffer（TLB）查找的開銷。
然而此功能會導致SAP HANA 偶爾崩毀。
|
1 |
# echo never > /sys/kernel/mm/transparent_hugepage/enabled |
sap-hana tuned profile也會停用Transparent Hugepages。要確保在激活調優配置文件之前，在啟動時停用THP，把關閉參數加入grub內。
|
1 2 |
# vi /etc/default/grub GRUB_CMDLINE_LINUX="transpart_hugepage=nerver crashkernel=auto rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet" |
調整grub參數必須重建grub.cfg
Legacy
|
1 |
# grub2-mkconfig -o /boot/grub2/grub.cfg |
UEFI
|
1 |
# grub2-mkconfig -o /boot/efi/EFI/redhat/grub.cfg |
確認配置生效
|
1 2 |
# cat /sys/kernel/mm/transparent_hugepage/enabled always madvise [never] |
設定CPU Governor(調控器)增進效能
Linux正在使用一種稱為CPU調控器的節能技術來控制CPU頻率和功耗。默認情況下，Linux使用調控器ondemand，它將根據CPU負載動態調整頻率和電壓上下。如果您希望以增加的能耗為代價來最大化CPU性能，SAP建議使用調控器性能。如果您使用如上所述的sap-hana調整配置文件，則可通過配置文件配置性能調控器，無需另外手動更改此設置。
|
1 |
# echo "cpupower frequency-set -g performance" >> /etc/rc.d/rc.local |
設置開機執行
|
1 |
# chmod +x /etc/rc.d/rc.local |
設定CPU的C state
為了在CPU空閒時節省能量，可以命令CPU進入低功耗模式。每個CPU都有幾種電源模式，它們統稱為“C狀態”或“C模式”。
RHEL 7.2附帶的Linux內核包含用於最新Intel CPU的cpuidle驅動程序：intel_idle。該驅動器導致C狀態切換中的不同行為。正常操作狀態為C0，當處理器處於空閒時為較高的C狀態，這節省了電力。但對於低延遲應用程序，停止和再次開始執行代碼所需的額外時間將導致性能下降。因此，建議通過設置以下參數將C狀態限制為C0和C1
|
1 2 |
vi /etc/default/grub GRUB_CMDLINE_LINUX="processor.max_cstate=1 intel_idle.max_cstate=1 transpart_hugepage=nerver crashkernel=auto rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet" |
調整grub參數必須重建grub.cfg
Legacy
|
1 |
# grub2-mkconfig -o /boot/grub2/grub.cfg |
UEFI
|
1 |
# grub2-mkconfig -o /boot/efi/EFI/redhat/grub.cfg |
增加允許用戶運行的最大程序數
根據工作負載和硬體，SAP HANA可能需要啟動大量程序。因此，在大多數情況下，sapsys預設的最大程序數是不夠的。
調整為無限制
|
1 2 3 4 |
# cat > /etc/security/limits.d/99-sapsys.conf << EOF @sapsys soft nproc unlimited @sapsys hard nproc unlimited EOF |
用屬於sapsys的使用者登入後檢查生效
|
1 2 |
$ ulimit -u unlimited |
關閉ABRT, Core Dumps and kdump
所有有關SAP HANA 系統故障，均交由SAP 技術支援，不需要作業系統產生的系統錯誤報告
關閉ABRT服務
|
1 2 3 4 |
# systemctl disable abrtd # systemctl disable abrt-ccpp # systemctl stop abrtd # systemctl stop abrt-ccpp |
關閉core dumps
|
1 2 3 |
# vi /etc/security/limits.conf * soft core 0 * hard core 0 |
關閉kdump
|
1 2 |
# systemctl stop kdump.service # systemctl disable kdump.service |
關閉防火牆
簡化設定，關閉防火牆
|
1 2 |
# systemctl stop firewalld # systemctl disable firewalld |
SAP HANA 安裝
安裝前準備
重啟系統讓上一節的設定生效
|
1 |
# reboot |
準備安裝目錄(檔案下載到這，需要128G)
安裝可以用hdblcmgui. 以下是用 hdblcm
這邊是用NFS(NFS伺服器要設rw,no_root_squash)
|
1 2 |
# mkdir -p /install # mount -t nfs 192.168.1.9:/volume1/NAS01NFS/sap_hana /install |
將下載檔案移到/install
|
1 2 3 |
# cd /install # ls 51053061_part1.exe 51053061_part2.rar 51053061_part3.rar 51053061_part4.rar |
下載與安裝加解壓rar格式需要的軟體
這邊選RAR 5.60 for Linux x64 下載
|
1 2 |
# cd /tmp # wget https://www.rarlab.com/rar/rarlinux-x64-5.6.0.tar.gz |
解開
|
1 2 3 |
# tar zxvf rarlinux-x64-5.6.0.tar.gz # cd rar # cp -v rar unrar /usr/local/bin/ |
解壓縮安裝包
|
1 2 |
# cd /install # unrar x 51053061_part1.exe |
改為好辨識的版本並進入Linux安裝目錄
|
1 2 |
# mv 51053061 51053061_HANA2_30 # cd 51053061_HANA2_30/DATA_UNITS/HDB_LCM_LINUX_X86_64/ |
安裝SAP HANA
互動安裝
開始安裝
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
# ./hdblcm SAP HANA Lifecycle Management - SAP HANA Database 2.00.030.00.1522209842 ************************************************************************ Scanning software locations... Detected components: SAP HANA Database (2.00.030.00.1522209842) in /install/51053061_HANA2_30/DATA_UNITS/HDB_SERVER_LINUX_X86_64/server SAP HANA AFL (incl.PAL,BFL,OFL) (2.00.030.0001.1522223444) in /install/51053061_HANA2_30/DATA_UNITS/HDB_AFL_LINUX_X86_64/packages SAP HANA EML AFL (2.00.030.0001.1522223444) in /install/51053061_HANA2_30/DATA_UNITS/HDB_EML_AFL_10_LINUX_X86_64/packages SAP HANA EPM-MDS (2.00.030.0001.1522223444) in /install/51053061_HANA2_30/DATA_UNITS/SAP_HANA_EPM-MDS_10/packages SAP HANA Database Client (2.3.78.1521836270) in /install/51053061_HANA2_30/DATA_UNITS/HDB_CLIENT_LINUX_X86_64/client SAP HANA Studio (2.3.35.000000) in /install/51053061_HANA2_30/DATA_UNITS/HDB_STUDIO_LINUX_X86_64/studio SAP HANA Smart Data Access (2.00.3.000.0) in /install/51053061_HANA2_30/DATA_UNITS/SAP_HANA_SDA_20_LINUX_X86_64/packages SAP HANA XS Advanced Runtime (1.0.82.303870) in /install/51053061_HANA2_30/DATA_UNITS/XSA_RT_10_LINUX_X86_64/packages GUI for HALM for XSA (including product installer) Version 1 (1.12.5) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACALMPIUI12_5.zip XSAC FILEPROCESSOR 1.0 (1.000.22) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACFILEPROC00_22.zip SAP Enterprise Architecture Designer 1.0 for SAP HANA (1.004.) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSAC_HANA_EADESIGNER-1.4.0.zip SAP HANA tools for accessing catalog content, data preview, SQL console, etc. (2.005.36) in /install/51053061_HANA2_30/DATA_UNITS/XSAC_HRTT_20/XSACHRTT05_36.zip XS Messaging Service 1 (1.003.2) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACMESSSRV03_2.zip XS Monitoring 1 (1.006.3) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACMONITORING06_3.zip Develop and run portal services for custome apps on XSA (1.002.2) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACPORTALSERV02_2.zip SAP Web IDE Web Client (4.003.0) in /install/51053061_HANA2_30/DATA_UNITS/XSAC_SAP_WEB_IDE_20/XSACSAPWEBIDE03_0.zip XS Services 1 (1.006.5) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACSERVICES06_5.zip SAPUI5 FESV4 XSA 1 - SAPUI5 1.52 (1.052.9) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACUI5FESV452_9.zip SAPUI5 SERVICE BROKER XSA 1 - SAPUI5 Service Broker 1.0 (1.000.1) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACUI5SB00_1.zip Xsa Cockpit 1 (1.001.7) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACXSACOCKPIT01_7.zip Choose an action Index | Action | Description ----------------------------------------------- 1 | install | Install new system 2 | extract_components | Extract components 3 | Exit (do nothing) | Enter selected action index [3]:1 CPU is not supported. Instruction set 'sse4.2' is missing. Checking system requirements failed |
CPU不支援，這是測試環境，嘗試使用以下參數
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 |
# ./hdblcm --ignore=check_platform SAP HANA Lifecycle Management - SAP HANA Database 2.00.030.00.1522209842 ************************************************************************ Scanning software locations... Detected components: SAP HANA Database (2.00.030.00.1522209842) in /install/51053061_HANA2_30/DATA_UNITS/HDB_SERVER_LINUX_X86_64/server SAP HANA AFL (incl.PAL,BFL,OFL) (2.00.030.0001.1522223444) in /install/51053061_HANA2_30/DATA_UNITS/HDB_AFL_LINUX_X86_64/packages SAP HANA EML AFL (2.00.030.0001.1522223444) in /install/51053061_HANA2_30/DATA_UNITS/HDB_EML_AFL_10_LINUX_X86_64/packages SAP HANA EPM-MDS (2.00.030.0001.1522223444) in /install/51053061_HANA2_30/DATA_UNITS/SAP_HANA_EPM-MDS_10/packages SAP HANA Database Client (2.3.78.1521836270) in /install/51053061_HANA2_30/DATA_UNITS/HDB_CLIENT_LINUX_X86_64/client SAP HANA Studio (2.3.35.000000) in /install/51053061_HANA2_30/DATA_UNITS/HDB_STUDIO_LINUX_X86_64/studio SAP HANA Smart Data Access (2.00.3.000.0) in /install/51053061_HANA2_30/DATA_UNITS/SAP_HANA_SDA_20_LINUX_X86_64/packages SAP HANA XS Advanced Runtime (1.0.82.303870) in /install/51053061_HANA2_30/DATA_UNITS/XSA_RT_10_LINUX_X86_64/packages GUI for HALM for XSA (including product installer) Version 1 (1.12.5) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACALMPIUI12_5.zip XSAC FILEPROCESSOR 1.0 (1.000.22) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACFILEPROC00_22.zip SAP Enterprise Architecture Designer 1.0 for SAP HANA (1.004.) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSAC_HANA_EADESIGNER-1.4.0.zip SAP HANA tools for accessing catalog content, data preview, SQL console, etc. (2.005.36) in /install/51053061_HANA2_30/DATA_UNITS/XSAC_HRTT_20/XSACHRTT05_36.zip XS Messaging Service 1 (1.003.2) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACMESSSRV03_2.zip XS Monitoring 1 (1.006.3) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACMONITORING06_3.zip Develop and run portal services for custome apps on XSA (1.002.2) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACPORTALSERV02_2.zip SAP Web IDE Web Client (4.003.0) in /install/51053061_HANA2_30/DATA_UNITS/XSAC_SAP_WEB_IDE_20/XSACSAPWEBIDE03_0.zip XS Services 1 (1.006.5) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACSERVICES06_5.zip SAPUI5 FESV4 XSA 1 - SAPUI5 1.52 (1.052.9) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACUI5FESV452_9.zip SAPUI5 SERVICE BROKER XSA 1 - SAPUI5 Service Broker 1.0 (1.000.1) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACUI5SB00_1.zip Xsa Cockpit 1 (1.001.7) in /install/51053061_HANA2_30/DATA_UNITS/XSA_CONTENT_10/XSACXSACOCKPIT01_7.zip Choose an action Index | Action | Description ----------------------------------------------- 1 | install | Install new system 2 | extract_components | Extract components 3 | Exit (do nothing) | Enter selected action index [3]: 1 SAP HANA Database version '2.00.030.00.1522209842' will be installed. Select additional components for installation: Index | Components | Description --------------------------------------------------------------------------------------------- 1 | all | All components 2 | server | No additional components 3 | client | Install SAP HANA Database Client version 2.3.78.1521836270 4 | studio | Install SAP HANA Studio version 2.3.35.000000 5 | smartda | Install SAP HANA Smart Data Access version 2.00.3.000.0 6 | xs | Install SAP HANA XS Advanced Runtime version 1.0.82.303870 7 | afl | Install SAP HANA AFL (incl.PAL,BFL,OFL) version 2.00.030.0001.1522223444 8 | eml | Install SAP HANA EML AFL version 2.00.030.0001.1522223444 9 | epmmds | Install SAP HANA EPM-MDS version 2.00.030.0001.1522223444 Enter comma-separated list of the selected indices [3]: 3 client裡面含有一些需要的套件也包括hana Enter Installation Path [/hana/shared]: Enter Local Host Name [erpprddb01.skywebster.com]: Do you want to add hosts to the system? (y/n) [n]: Enter SAP HANA System ID: HDB Enter Instance Number [00]: 02 Enter Local Host Worker Group [default]: Index | System Usage | Description ------------------------------------------------------------------------------- 1 | production | System is used in a production environment 2 | test | System is used for testing, not production 3 | development | System is used for development, not production 4 | custom | System usage is neither production, test nor development Select System Usage / Enter Index [4]: 4 Enter Location of Data Volumes [/hana/data/HDB]: Enter Location of Log Volumes [/hana/log/HDB]: Restrict maximum memory allocation? [n]: Enter Certificate Host Name For Host 'erpprddb01.skywebster.com' [erpprddb01.skywebster.com]: Enter SAP Host Agent User (sapadm) Password: Confirm SAP Host Agent User (sapadm) Password: Enter System Administrator (hdbadm) Password: Confirm System Administrator (hdbadm) Password: Enter System Administrator Home Directory [/usr/sap/HDB/home]: Enter System Administrator Login Shell [/bin/sh]: Enter System Administrator User ID [1000]: Enter ID of User Group (sapsys) [79]: Enter System Database User (SYSTEM) Password: Confirm System Database User (SYSTEM) Password: Restart system after machine reboot? [n]:y Summary before execution: ========================= SAP HANA Database System Installation Installation Parameters Remote Execution: ssh Database Isolation: low Installation Path: /hana/shared Local Host Name: erpprddb01.skywebster.com SAP HANA System ID: HDB Instance Number: 02 Local Host Worker Group: default System Usage: test Location of Data Volumes: /hana/data/HDB Location of Log Volumes: /hana/log/HDB Certificate Host Names: erpprddb01.skywebster.com -> erpprddb01.skywebster.com System Administrator Home Directory: /usr/sap/HDB/home System Administrator Login Shell: /bin/sh System Administrator User ID: 1000 ID of User Group (sapsys): 79 Software Components SAP HANA Database Install version 2.00.030.00.1522209842 Location: /install/51053061_HANA2_30/DATA_UNITS/HDB_SERVER_LINUX_X86_64/server SAP HANA AFL (incl.PAL,BFL,OFL) Do not install SAP HANA EML AFL Do not install SAP HANA EPM-MDS Do not install SAP HANA Database Client Do not install SAP HANA Studio Do not install SAP HANA Smart Data Access Do not install SAP HANA XS Advanced Runtime Do not install Do you want to continue? (y/n):y ................................... Importing delivery unit HANA_SEC_BASE Importing delivery unit HANA_SYS_ADMIN Importing delivery unit HANA_ADMIN Importing delivery unit HANA_WKLD_ANLZ Installing Resident hdblcm... Updating SAP HANA Database Instance Integration on Local Host... Regenerating SSL certificates... Deploying SAP Host Agent configurations... Creating Component List... SAP HANA Database System installed You can send feedback to SAP with this form: https://erpprddb01.skywebster.com:1129/lmsl/HDBLCM/HDB/feedback/feedback.html Log file written to '/var/tmp/hdb_HDB_hdblcm_install_2018-09-24_08.06.59/hdblcm.log' on host 'erpprddb01.skywebster.com'. |
確認版本
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
# su - hdbadm Last login: Mon Sep 24 08:13:12 CST 2018 hdbadm@erpprddb01.skywebster:/usr/sap/HDB/HDB02> HDB info USER PID PPID %CPU VSZ RSS COMMAND hdbadm 17550 17549 0.2 116180 2716 -sh hdbadm 17616 17550 0.0 113260 1604 \_ /bin/sh /usr/sap/HDB/HDB02/HDB info hdbadm 17647 17616 0.0 139508 1572 \_ ps fx -U hdbadm -o user,pid,ppid,pcpu,vsz,rss,args hdbadm 2412 1 0.0 23876 1756 sapstart pf=/hana/shared/HDB/profile/HDB_HDB02_erpprddb01.skywebster.com <-執行中 hdbadm 2420 2412 0.0 252200 32220 \_ /usr/sap/HDB/HDB02/erpprddb01.skywebster.com/trace/hdb.sapHDB_HDB02 - hdbadm 2436 2420 6.8 9114516 7066432 \_ hdbnameserver hdbadm 2613 2420 0.2 1538080 280628 \_ hdbcompileserver hdbadm 2615 2420 23.4 3677756 2679736 \_ hdbpreprocessor hdbadm 2654 2420 6.7 9212796 7224472 \_ hdbindexserver -port 30203 hdbadm 2656 2420 0.5 2523440 977420 \_ hdbxsengine -port 30207 hdbadm 3042 2420 0.3 1782220 307248 \_ hdbwebdispatcher hdbadm 2227 1 0.0 500016 22848 /usr/sap/HDB/HDB02/exe/sapstartsrv pf=/hana/shared/HDB/profile/HDB_HDB02_ hdbadm@erpprddb01.skywebster:/usr/sap/HDB/HDB02> |
無人值守安裝
創建範本文件->為了做無人職守安裝
會產生兩個檔templateFile(設定參數格式檔)、templateFile.xml(密碼檔)
|
1 2 3 |
# cd /install/51053061_HANA2_30/DATA_UNITS/HDB_SERVER_LINUX_X86_64/ # ./hdblcm --dump_configfile_template=templateFile # cp templateFile.xml password.xml |
編輯密碼檔
注意：密碼複雜度要高，無人值守安裝不會檢查密碼複雜度，如果密碼過於簡單，安裝完會無法登入
|
1 2 3 4 5 6 7 8 |
<?xml version="1.0" encoding="UTF-8"?> <Passwords> <root_password>!QAZ2wsx3edc</root_password> <sapadm_password>!QAZ2wsx3edc></sapadm_password> <master_password>>!QAZ2wsx3edc</master_password> <password>!QAZ2wsx3edc</password> <system_user_password>!QAZ2wsx3edc</system_user_password> </Passwords> |
開始無人值守安裝
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
cat /install/51053061_HANA2_30/DATA_UNITS/HDB_SERVER_LINUX_X86_64/password.xml | \ /install/51053061_HANA2_30/DATA_UNITS/HDB_SERVER_LINUX_X86_64/hdblcm \ --ignore=check_platform \ --batch \ --sid=HDB \ --number=02 \ --action=install \ --hostname=erpprddb01.skywebster.com \ --install_hostagent \ --components=client \ --system_usage=test \ --sapmnt=/hana/shared/ \ --datapath=/hana/data/HDB \ --logpath=/hana/log/HDB \ --workergroup=default \ --home=/usr/sap/HDB/home \ --shell=/bin/bash \ --userid=1000 \ --groupid=1000 \ --read_password_from_stdin=xml \ --autostart=1 |
大概10幾分鐘就裝完了。
參考
How to subscribe RHEL 7 SAP HANA system to Extended Update Support (EUS) channel?
SAP_HANA_Server_Installation_Guide_en
SAP HANA TDI-Storage Requirements
Overview of Red Hat Enterprise Linux for SAP HANA Subscription
hana_20_Red_Hat_Enterprise_Linux_RHEL_7_x_Configuration_Guide_for_SAP_HANA_en