安装hana

一.hana下载

hana的免费版本只有express版本,下载地址为http://help.sap.com/disclaimer?site=http://sap.com/sap-hana-express

我下载的是最新的2.0版本,首先下载express edition download manager,然后通过manager下载binary installer

二.hana安装需求

1.升级gcc版本

一般的操作系统自带的gcc的版本都是不够的.需要升级gcc版本,否则安装的时候会遇到报错:

                Output line 2: /usr/sap/HXE/HDB90/exe/hdbnsutil: /usr/lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /usr/sap/HXE/HDB90/exe/libhdbrskernel.so)
                Output line 3: /usr/sap/HXE/HDB90/exe/hdbnsutil: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.14' not found (required by /usr/sap/HXE/HDB90/exe/libhdbrskernel.so)
                Output line 4: /usr/sap/HXE/HDB90/exe/hdbnsutil: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.19' not found (required by /usr/sap/HXE/HDB90/exe/libhdbrskernel.so)
                Output line 5: /usr/sap/HXE/HDB90/exe/hdbnsutil: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /usr/sap/HXE/HDB90/exe/libhdbbasement.so)
                Output line 6: /usr/sap/HXE/HDB90/exe/hdbnsutil: /usr/lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /usr/sap/HXE/HDB90/exe/libhdbbasement.so)
                Output line 7: /usr/sap/HXE/HDB90/exe/hdbnsutil: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /usr/sap/HXE/HDB90/exe/libhdbun

报错的意思是/usr/lib64/libstdc++.so.6这个库文件版本过低,没有相应的GLIBCXX_3.4.XX模块.

升级gcc步骤如下:

源码下载gcc地址:

http://gcc.skazkaforyou.com/releases

需要联网才能执行download_prerequisites,这一步解决依赖性的问题

tar zxvf gcc-6.3.0.tar.gz
cd gcc-6.3.0
./contrib/download_prerequisites
mkdir gcc-build-4.8.2
cd gcc-build-4.8.2/
../configure -enable-checking=release -enable-languages=c,c++ -disable-multilib
make
make install

升级gcc的时间可能很长.

升级完成之后还需要修改libstdc++的文件位置:

[root@hana1 lib64]# cd /usr/lib64
[root@hana1 lib64]# ls -l libstdc++.so.6
lrwxrwxrwx. 1 root root 19 Apr 18 21:48 libstdc++.so.6 -> libstdc++.so.6.0.13
[root@hana1 lib64]# rm -rf libstdc++.so.6
[root@hana1 lib64]# ln -sv /usr/local/lib64/libstdc++.so.6 libstdc++.so.6
`libstdc++.so.6' -> `/usr/local/lib64/libstdc++.so.6'
[root@hana1 lib64]# ls -l libstdc++.so.6
lrwxrwxrwx. 1 root root 31 Apr 19 01:01 libstdc++.so.6 -> /usr/local/lib64/libstdc++.so.6

可以使用如下命令查看libstdc++中的模块:

strings libstdc++.so.6|grep CXX

2.空间需求

hana默认安装在/hana下,保证/hana空间大于15G

保证swap空间不小于8G

三.安装hana

上传下载的binary包,然后进行解压缩.hxe.tgz只包含hdb组建.hxexsa.tgz包含hdb和其它的例如xs组件

执行安装如下

[root@hana1 data]# ./setup_hxe.sh 
Enter HANA, express edition installer root directory:
    Hint: <extracted_path>/HANA_EXPRESS_20
HANA, express edition installer root directory [/data/HANA_EXPRESS_20]: 
Enter local host name [hana1]: 
Enter SAP HANA system ID [HXE]:          #这里输入sid
Enter HANA instance number [90]:         #instance number
Enter HDB master password:               #这个密码是操作系统用户[sid]adm的密码,也是HDB中SYSTEM的密码
Confirm "HDB master" password: 
##############################################################################
# Summary before execution                                                   #
##############################################################################
HANA, express edition installer : /data/HANA_EXPRESS_20
  Component(s) to install       : HANA server + Application Function Library
  Host name                     : hana1
  HANA system ID                : HXE
  HANA instance number          : 90
  Master password               : ********
Proceed with installation? (Y/N) : y
Installing HDB server...
SAP HANA Lifecycle Management - SAP HANA Express Edition 2.00.001.00.1486472000
*******************************************************************************
Start reading from input channel...
... Done.
Summary before execution:
=========================
SAP HANA Express Edition System Installation
   Installation Parameters
      Remote Execution: ssh
      Installation Path: /hana/shared
      Local Host Name: hana1
      SAP HANA System ID: HXE
      Instance Number: 90
      Local Host Worker Group: default
      Database Mode: multiple_containers
      Database Isolation: low
      System Usage: development
      Location of Data Volumes: /hana/shared/data/HXE                   #这里是hana的数据目录
      Location of Log Volumes: /hana/shared/log/HXE                     #这里是hana的日志目录
      Directory containing custom configurations: /data/HANA_EXPRESS_20/DATA_UNITS/HDB_SERVER_LINUX_X86_64/configurations/custom
      Certificate Host Names: hana1 -> hana1
      System Administrator Home Directory: /usr/sap/HXE/home            #这个是hxeadm的家目录
      System Administrator Login Shell: /bin/bash
      System Administrator User ID: 1000
      ID of User Group (sapsys): 79
   Software Components
      SAP HANA Database
         Install version 2.00.001.00.1486472000
         Location: /data/HANA_EXPRESS_20/DATA_UNITS/HDB_SERVER_LINUX_X86_64/server
      SAP HANA AFL (incl.PAL,BFL,OFL,HIE)
         Install version 2.00.001.0000.1486494027
         Location: /data/HANA_EXPRESS_20/DATA_UNITS/HDB_AFL_LINUX_X86_64/packages
Installing components...
Installing SAP HANA Database...
  Resuming broken installation at step 'Creating System'.
  Preparing package 'Saphostagent Setup'...
  Preparing package 'Python Support'...
  Preparing package 'Python Runtime'...
  Preparing package 'Product Manifest'...
  Preparing package 'Binaries'...
  Preparing package 'Krb5 Runtime'...
  Preparing package 'Installer'...
  Preparing package 'Ini Files'...
  Preparing package 'Documentation'...
  Preparing package 'Delivery Units'...
  Preparing package 'Offline Cockpit'...
  Preparing package 'DAT Languages (EN, DE)'...
  Preparing package 'DAT Configfiles (EN, DE)'...
  Creating System...
  Creating instance...
  Starting SAP HANA Database system...
  Starting 5 processes on host 'hana1' (worker):
      Starting on 'hana1': hdbcompileserver, hdbdaemon, hdbnameserver, hdbpreprocessor, hdbwebdispatcher
  Starting 6 processes on host 'hana1' (worker):
      Starting on 'hana1': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher
      Starting on 'hana1': hdbcompileserver, hdbdaemon, hdbindexserver, hdbpreprocessor, hdbwebdispatcher
      Starting on 'hana1': hdbdaemon, hdbindexserver, hdbwebdispatcher
      Starting on 'hana1': hdbdaemon, hdbwebdispatcher
    All server processes started on host 'hana1' (worker).
Installing Resident hdblcm...
Installing SAP HANA AFL (incl.PAL,BFL,OFL,HIE)...
  Preparing package 'AFL'...
  Installing SAP Application Function Libraries to /hana/shared/HXE/exe/linuxx86_64/plugins/afl_2.00.001.0000.1486494027_cbc2870b9f71dbd787522090ef82c6f5b7b8095a...
  Installing package 'AFL'...
  Stopping system...
    Stopping 6 processes on host 'hana1' (worker):
      Stopping on 'hana1': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher
    All server processes stopped on host 'hana1' (worker).
  Activating plugin...
  Starting system...
  Starting 6 processes on host 'hana1' (worker):
      Starting on 'hana1': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher
      Starting on 'hana1': hdbcompileserver, hdbdaemon, hdbindexserver, hdbpreprocessor, hdbwebdispatcher
      Starting on 'hana1': hdbdaemon, hdbindexserver, hdbpreprocessor, hdbwebdispatcher
      Starting on 'hana1': hdbdaemon, hdbindexserver, hdbwebdispatcher
      Starting on 'hana1': hdbdaemon, hdbwebdispatcher
    All server processes started on host 'hana1' (worker).
Updating SAP HANA Express Edition Instance Integration on Local Host...
  Deploying SAP Host Agent configurations...
Creating Component List...
SAP HANA Express Edition System installed
You can send feedback to SAP with this form: https://hana1:1129/lmsl/HDBLCM/HXE/feedback/feedback.html
Log file written to '/var/tmp/hdb_HXE_hdblcm_install_2017-04-19_01.02.23/hdblcm.log' on host 'hana1'.
Enable AFL...
0 rows affected (overall time 70.014 msec; server time 36.961 msec)
Start "HXE" tenant database...
Unset 'unload_upper_bound' configuration...
Unset 'plan_cache_statistics_enabled' configuration...
Turning off statistics server...
Reclaiming log space...
Reclaiming disk space...
Restarting HDB...
Impromptu CCC initialization by 'rscpCInit'.
  See SAP note 1266393.
Do garbage collection...
Collect garbage on "hdbnameserver"...
Collect garbage on "hdbindexserver"...
Collect garbage on "hdbcompileserver"...
Collect garbage on "hdbpreprocessor"...
Reclaim data volume...
Release free log segments...
Stop "HXE" tenant database...
HDB is successfully optimized.

安装完成后,系统会自动添加一个用户,用户名为hxeadm,其中xx为上面配置的instance number.

四.hana的启停与连接

hana的启动,在hxeadm下:

hxeadm@hana1:/usr/sap/HXE/HDB90> HDB start
StartService
Impromptu CCC initialization by 'rscpCInit'.
  See SAP note 1266393.
OK
OK
Starting instance using: /usr/sap/HXE/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr 90 -function StartWait 2700 2
03.05.2017 11:35:02
Start
OK
03.05.2017 11:36:45
StartWait
OK

停止为:

HDB stop

查看HDB 状态:

hxeadm@hana1:/usr/sap/HXE/HDB90> HDB info
USER       PID  PPID %CPU    VSZ   RSS COMMAND
hxeadm    3279  3278  0.6 108488  1948 -bash
hxeadm    2879  2878  0.0 108488  1944 -bash
hxeadm    3574  2879  0.0 106252  1436  \_ /bin/sh /usr/sap/HXE/HDB90/HDB info
hxeadm    3605  3574  1.0 110228  1036      \_ ps fx -U hxeadm -o user,pid,ppid,pcpu,vsz,rss,args
hxeadm    3141     1  0.0  22876  1640 sapstart pf=/usr/sap/HXE/SYS/profile/HXE_HDB90_hana1
hxeadm    3153  3141  1.3 250888 36828  \_ /usr/sap/HXE/HDB90/hana1/trace/hdb.sapHXE_HDB90 -d -nw -f /usr/sap/HXE/HDB90/hana1/daemon.ini pf=/usr/sap/HXE/SYS/p
hxeadm    3169  3153 46.5 3164704 1306100      \_ hdbnameserver
hxeadm    3407  3153 20.1 1238412 266900      \_ hdbcompileserver
hxeadm    3409  3153 19.7 1442532 307360      \_ hdbpreprocessor
hxeadm    3456  3153 42.4 1287672 477740      \_ hdbwebdispatcher
hxeadm    3074     1  0.9 498116 26884 /usr/sap/HXE/HDB90/exe/sapstartsrv pf=/usr/sap/HXE/SYS/profile/HXE_HDB90_hana1 -D -u hxeadm

主要有hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher等进程.

连接hana,使用hdbsql来连接,类似于oracle中的sqlplus:

hxeadm@hana1:/usr/sap/HXE/HDB90> hdbsql -n 127.0.0.1:39013 -u SYSTEM -p Password123
Welcome to the SAP HANA Database interactive terminal.
                                           
Type:  \h for help with commands          
       \q to quit                         
hdbsql SYSTEMDB=> \q

其中需要注意的是hdb的端口号:

Note

The HANA JDBC port number for SAP HANA, express edition is different than the default port number 

30015 mentioned in the SHINE guide. You need to update the port parameter for the resources 

CrossSchemaSysand CrossSchemaSysBiin the mtaext file to 3<instance-number>13

express版本的的默认端口好为3[instance-nunber]13,而如果你安装的正式版,默认端口号为3[instance-number]15

五.安装hana client

hana client包含了hana的一些库文件,例如python的驱动,odbc,jdbc驱动等.安装也很简单.上传hdb clinet安装包:

cd HDB_CLIENT_LINUX_X86_64
./hdbinst

安装产生的文件在/usr/sap/hdbclient/中

[root@hana1 config]# cd  /usr/sap/hdbclient/
[root@hana1 hdbclient]# ls
hdbalm     hdbcli         hdbodbc_cons  hdbsqldbc_cons  install          libodbcHDB.a   libSQLDBCHDB.so  ngdbc.jar  pyhdbcli.so  regi  rtt.sh  sdk
hdbalm.py  hdbclient.lst  hdbsql        hdbuserstore    libdbcapiHDB.so  libodbcHDB.so  manifest         odbcreg    Python       rtt   SAPCAR