一、前言
sap hana为一款列式存储的内存数据库，能快速的查询和处理事务；自sap第四代ERP系统SAP S/4 HANA就是完全基于hana数据库进行构建的，下面咱们简单来安装使用下。
二、环境配置
操作系统：SUSE 12.3
内存：32G，因为是内存数据库，对内存要求很高，至少需要24G内存
数据库版本：hana 2.0 sp3
三、操作系统配置
修改主机名
vi /etc/HOSTNAME
hana
配置IP地址
vi /etc/sysconfig/network/ifcfg-eth0
BOOTPROTO='static'
BROADCAST=''
ETHTOOL_OPTIONS=''
IPADDR='192.168.11.13'
MTU=''
NAME=''
NETMASK='255.255.255.0'
NETWORK='192.168.11.1'
REMOTE_IPADDR=''
STARTMODE='auto'
DHCLIENT_SET_DEFAULT_ROUTE='yes'
关闭防火墙
systemctl stop SuSEfirewall2
systemctl disable SuSEfirewall2
配置hosts
vi /etc/hosts
192.168.11.13 hana
配置ssh远程
vi /etc/ssh/sshd_config
PasswordAuthentication yes
systemctl restart sshd
systemctl enable sshd
系统分区建议
/usr/sap---------100g----管理路径
/hana/shared-----500g----安装路径
/hana/data-------500g----数据目录
/hana/log--------200g----日志目录
/hana/backup-----500g----备份目录
Note：根据实际情况自定义，建议文件系统使用xfs
四、数据库安装
软件清单
hana:~/hana2/SP03 # ll
total 12839592
-rw-r--r-- 1 root root 4000000000 Aug 24 23:08 51052481_part1.exe
-rw-r--r-- 1 root root 4000000000 Aug 24 23:08 51052481_part2.rar
-rw-r--r-- 1 root root 4000000000 Aug 24 23:10 51052481_part3.rar
-rw-r--r-- 1 root root 1147734170 Aug 24 23:09 51052481_part4.rar
解压
unrar x 51052481_part1.exe
交互安装
cd 51052481/DATA_UNITS/HDB_LCM_LINUX_X86_64
./hdblcm
hana:~/hana2/SP03/51052481/DATA_UNITS/HDB_LCM_LINUX_X86_64 # ./hdblcm
SAP HANA Lifecycle Management - SAP HANA Database 2.00.030.00.1522210459
************************************************************************
Scanning software locations...
Detected components:
SAP HANA Database (2.00.030.00.1522210459) in /root/hdb/51052481/DATA_UNITS/HDB_SERVER_LINUX_X86_64/server
SAP HANA AFL (incl.PAL,BFL,OFL) (2.00.030.0001.1522227910) in /root/hdb/51052481/DATA_UNITS/HDB_AFL_LINUX_X86_64/packages
SAP HANA EML AFL (2.00.030.0001.1522227910) in /root/hdb/51052481/DATA_UNITS/HDB_EML_AFL_10_LINUX_X86_64/packages
SAP HANA EPM-MDS (2.00.030.0001.1522227910) in /root/hdb/51052481/DATA_UNITS/SAP_HANA_EPM-MDS_10/packages
SAP HANA Database Client (2.3.78.1521836270) in /root/hdb/51052481/DATA_UNITS/HDB_CLIENT_LINUX_X86_64/client
SAP HANA Studio (2.3.35.000000) in /root/hdb/51052481/DATA_UNITS/HDB_STUDIO_LINUX_X86_64/studio
SAP HANA Smart Data Access (2.00.3.000.0) in /root/hdb/51052481/DATA_UNITS/SAP_HANA_SDA_20_LINUX_X86_64/packages
SAP HANA XS Advanced Runtime (1.0.82.303870) in /root/hdb/51052481/DATA_UNITS/XSA_RT_10_LINUX_X86_64/packages
GUI for HALM for XSA (including product installer) Version 1 (1.12.5) in /root/hdb/51052481/DATA_UNITS/XSA_CONTENT_10/XSACALMPIUI12_5.zip
XSAC FILEPROCESSOR 1.0 (1.000.22) in /root/hdb/51052481/DATA_UNITS/XSA_CONTENT_10/XSACFILEPROC00_22.zip
SAP Enterprise Architecture Designer 1.0 for SAP HANA (1.004.) in /root/hdb/51052481/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 /root/hdb/51052481/DATA_UNITS/XSAC_HRTT_20/XSACHRTT05_36.zip
XS Messaging Service 1 (1.003.2) in /root/hdb/51052481/DATA_UNITS/XSA_CONTENT_10/XSACMESSSRV03_2.zip
XS Monitoring 1 (1.006.3) in /root/hdb/51052481/DATA_UNITS/XSA_CONTENT_10/XSACMONITORING06_3.zip
Develop and run portal services for custome apps on XSA (1.002.2) in /root/hdb/51052481/DATA_UNITS/XSA_CONTENT_10/XSACPORTALSERV02_2.zip
SAP Web IDE Web Client (4.003.0) in /root/hdb/51052481/DATA_UNITS/XSAC_SAP_WEB_IDE_20/XSACSAPWEBIDE03_0.zip
XS Services 1 (1.006.5) in /root/hdb/51052481/DATA_UNITS/XSA_CONTENT_10/XSACSERVICES06_5.zip
SAPUI5 FESV4 XSA 1 - SAPUI5 1.52 (1.052.9) in /root/hdb/51052481/DATA_UNITS/XSA_CONTENT_10/XSACUI5FESV452_9.zip
SAPUI5 SERVICE BROKER XSA 1 - SAPUI5 Service Broker 1.0 (1.000.1) in /root/hdb/51052481/DATA_UNITS/XSA_CONTENT_10/XSACUI5SB00_1.zip
Xsa Cockpit 1 (1.001.7) in /root/hdb/51052481/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.1522210459' 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.1522227910
8 | eml | Install SAP HANA EML AFL version 2.00.030.0001.1522227910
9 | epmmds | Install SAP HANA EPM-MDS version 2.00.030.0001.1522227910
Enter comma-separated list of the selected indices [3]: 2,3,4
Enter Installation Path [/hana/shared]:
Enter Local Host Name [hana]:
Do you want to add hosts to the system? (y/n) [n]:
Enter SAP HANA System ID: TST
Enter Instance Number [00]:
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]: 2
Enter Location of Data Volumes [/hana/data/TST]:
Enter Location of Log Volumes [/hana/log/TST]:
Enter Certificate Host Name For Host 'hana' [hana]:
Enter SAP Host Agent User (sapadm) Password:
Confirm SAP Host Agent User (sapadm) Password:
Enter System Administrator (tstadm) Password:
Confirm System Administrator (tstadm) Password:
Enter System Administrator Home Directory [/usr/sap/TST/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]:
Summary before execution:
=========================
SAP HANA Database System Installation
Installation Parameters
Remote Execution: ssh
Database Isolation: low
Installation Path: /hana/shared
Local Host Name: hana
SAP HANA System ID: TST
Instance Number: 00
Local Host Worker Group: default
System Usage: test
Location of Data Volumes: /hana/data/TST
Location of Log Volumes: /hana/log/TST
Certificate Host Names: hana -> hana
System Administrator Home Directory: /usr/sap/TST/home
System Administrator Login Shell: /bin/sh
System Administrator User ID: 1000
ID of User Group (sapsys): 79
SAP HANA Database Client Installation Path: /hana/shared/TST/hdbclient
SAP HANA Studio Installation Path: /hana/shared/TST/hdbstudio
Software Components
SAP HANA Database
Install version 2.00.030.00.1522210459
Location: /root/hdb/51052481/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
Install version 2.3.78.1521836270
Location: /root/hdb/51052481/DATA_UNITS/HDB_CLIENT_LINUX_X86_64/client
SAP HANA Studio
Install version 2.3.35.000000
Location: /root/hdb/51052481/DATA_UNITS/HDB_STUDIO_LINUX_X86_64/studio
SAP HANA Smart Data Access
Do not install
SAP HANA XS Advanced Runtime
Do not install
Do you want to continue? (y/n): y
Installing components...
Installing SAP HANA Database...
Preparing package 'Saphostagent Setup'...
Preparing package 'Python Support'...
Preparing package 'Python Runtime'...
Preparing package 'Product Manifest'...
Preparing package 'Binaries'...
Preparing package 'Data Quality'...
Preparing package 'Krb5 Runtime'...
Preparing package 'Installer'...
Preparing package 'Ini Files'...
Preparing package 'HWCCT'...
Preparing package 'Documentation'...
Preparing package 'Delivery Units'...
Preparing package 'Offline Cockpit'...
Preparing package 'DAT Languages (EN, DE)'...
Preparing package 'DAT Languages (other)'...
Preparing package 'DAT Configfiles (EN, DE)'...
Preparing package 'DAT Configfiles (other)'...
Creating System...
Extracting software...
Installing package 'Saphostagent Setup'...
Installing package 'Python Support'...
Installing package 'Python Runtime'...
Installing package 'Product Manifest'...
Installing package 'Binaries'...
Installing package 'Data Quality'...
Installing package 'Krb5 Runtime'...
Installing package 'Installer'...
Installing package 'Ini Files'...
Installing package 'HWCCT'...
Installing package 'Documentation'...
Installing package 'Delivery Units'...
Installing package 'Offline Cockpit'...
Installing package 'DAT Languages (EN, DE)'...
Installing package 'DAT Languages (other)'...
Installing package 'DAT Configfiles (EN, DE)'...
Installing package 'DAT Configfiles (other)'...
Creating instance...
Installing SAP Host Agent version 7.21.33...
Starting SAP HANA Database system...
Starting 4 processes on host 'hana' (worker):
Starting on 'hana' (worker): hdbcompileserver, hdbdaemon, hdbnameserver, hdbpreprocessor
Starting 7 processes on host 'hana' (worker):
Starting on 'hana' (worker): hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine
Starting on 'hana' (worker): hdbdaemon, hdbindexserver, hdbwebdispatcher, hdbxsengine
Starting on 'hana' (worker): hdbdaemon, hdbwebdispatcher, hdbxsengine
Starting on 'hana' (worker): hdbdaemon, hdbwebdispatcher
All server processes started on host 'hana' (worker).
Importing delivery units...
Importing delivery unit HCO_INA_SERVICE
Importing delivery unit HANA_DT_BASE
Importing delivery unit HANA_IDE_CORE
Importing delivery unit HANA_TA_CONFIG
Importing delivery unit HANA_UI_INTEGRATION_SVC
Importing delivery unit HANA_UI_INTEGRATION_CONTENT
Importing delivery unit HANA_XS_BASE
Importing delivery unit HANA_XS_DBUTILS
Importing delivery unit HANA_XS_EDITOR
Importing delivery unit HANA_XS_IDE
Importing delivery unit HANA_XS_LM
Importing delivery unit HDC_ADMIN
Importing delivery unit HDC_BACKUP
Importing delivery unit HDC_IDE_CORE
Importing delivery unit HDC_SEC_CP
Importing delivery unit HDC_SYS_ADMIN
Importing delivery unit HDC_XS_BASE
Importing delivery unit HDC_XS_LM
Importing delivery unit SAPUI5_1
Importing delivery unit SAP_WATT
Importing delivery unit HANA_SEC_CP
Importing delivery unit HANA_BACKUP
Importing delivery unit HANA_HDBLCM
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...
Installing SAP HANA Database Client...
Preparing package 'Product Manifest'...
Preparing package 'SQLDBC'...
Preparing package 'REPOTOOLS'...
Preparing package 'Python DB API'...
Preparing package 'ODBC'...
Preparing package 'JDBC'...
Preparing package 'HALM Client'...
Preparing package 'DBCAPI'...
Preparing package 'node.js Client'...
Preparing package 'golang Client'...
Preparing package 'Ruby Client'...
Preparing package 'CommonCryptoLib'...
Preparing package 'Client Installer'...
Installing SAP HANA Database Client to /hana/shared/TST/hdbclient...
Installing package 'Product Manifest'...
Installing package 'SQLDBC'...
Installing package 'REPOTOOLS'...
Installing package 'Python DB API'...
Installing package 'ODBC'...
Installing package 'JDBC'...
Installing package 'HALM Client'...
Installing package 'DBCAPI'...
Installing package 'node.js Client'...
Installing package 'golang Client'...
Installing package 'Ruby Client'...
Installing package 'CommonCryptoLib'...
Installing package 'Client Installer'...
Installing SAP HANA Studio...
Preparing package 'Studio Director'...
Preparing package 'Client Installer'...
Installing SAP HANA Studio to /hana/shared/TST/hdbstudio...
Installing package 'Studio Director'...
Installing package 'Client Installer'...
Installing SAP HANA Studio Update repository...
hdbupdrep: Importing delivery units...
hdbupdrep: Importing delivery unit HANA_STUDIO_TST
Registering SAP HANA Database Components 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://hana:1129/lmsl/HDBLCM/TST/feedback/feedback.html
Log file written to '/var/tmp/hdb_TST_hdblcm_install_2023-08-24_01.08.53/hdblcm.log' on host 'hana'.
五、检查
进程查看
tstadm@hana:/usr/sap/TST/HDB00> HDB info
USER PID PPID %CPU VSZ RSS COMMAND
tstadm 3600 3599 0.2 15420 5368 -sh
tstadm 3658 3600 0.0 13392 3408 \_ /bin/sh /usr/sap/TST/HDB00/HDB info
tstadm 3689 3658 0.0 36880 2932 \_ ps fx -U tstadm -o user,pid,ppid,pcpu,vsz,rss,args
tstadm 2999 1 0.0 21728 3044 sapstart pf=/usr/sap/TST/SYS/profile/TST_HDB00_hana
tstadm 3007 2999 1.2 228856 48692 \_ /usr/sap/TST/HDB00/hana/trace/hdb.sapTST_HDB00 -d -nw -f /usr/sap/TST/HDB00/hana/daemon.ini pf=/usr/sap/TST/SYS/profile/TST_HDB00_hana
tstadm 3023 3007 81.0 3368632 2327760 \_ hdbnameserver
tstadm 3192 3007 3.2 1202736 342068 \_ hdbcompileserver
tstadm 3194 3007 3.1 1355064 386624 \_ hdbpreprocessor
tstadm 3233 3007 24.4 2778464 1754672 \_ hdbindexserver -port 30003
tstadm 3235 3007 10.8 2214784 1086400 \_ hdbxsengine -port 30007
tstadm 3551 3007 10.8 1448552 555684 \_ hdbwebdispatcher
tstadm 2095 1 0.0 428924 33096 /usr/sap/TST/HDB00/exe/sapstartsrv pf=/usr/sap/TST/SYS/profile/TST_HDB00_hana -D -u tstadm
tstadm 1953 1 0.0 36716 4376 /usr/lib/systemd/systemd --user
tstadm 1957 1953 0.0 88516 2104 \_ (sd-pam)
版本查看
tstadm@hana:/usr/sap/TST/HDB00> HDB -version
HDB version info:
version: 2.00.030.00.1522210459
branch: hanaws
machine config: linuxx86_64
git hash: bb2ff6b25b8eab5ab382c170a43dc95ae6ce298f
git merge time: 2018-03-28 06:14:19
weekstone: 2018.13.0
cloud edition: 0000.00.00
compile date: 2018-03-28 06:19:13
compile host: ld2221
compile type: rel
tstadm@hana:/usr/sap/TST/HDB00>
license查看
tstadm@hana:/usr/sap/TST/HDB00> hdbsql -i 00 -u system -p Hana#1234
Welcome to the SAP HANA Database interactive terminal.
Type: \h for help with commands
\q to quit
hdbsql TST=> select HARDWARE_KEY,START_DATE,EXPIRATION_DATE from SYS.M_LICENSE;
1 row selected (overall time 16.632784 sec; server time 56.117 msec)
hdbsql TST=>
HARDWARE_KEY,START_DATE,EXPIRATION_DATE
"B1069372825","2023-08-24 00:00:00.000000000","2023-11-22 23:59:59.999999000"
Note：可看到默认只有90天的试用，需要利用HARDWARE_KEY去sap support进行申请license key。
最后修改时间：2023-09-01 13:24:33
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
