基于SAP HANA 的SAP系统 安装

最近越来越多的公司在考虑HANA了，作为有10几年经验的SAPBasis顾问，必须得鸟枪换炮，用时下流行的，那就是转型（Transformation)。

希望通过Blog记下自己学习HANA的点点滴滴，同时也督促自己学习。

1. 概述篇
 

    1.1一种新型数据库  （OLTP)
      1.2一种新型数据分析工具  (OLAP)

HANA = OLTP + OLAP?

2. 安装篇

本文以安装Netweaver 7.4为例。

2.1 准备及下载

• VMware 下载： VMware Workstation 9.0.1 

http://www.crsky.com/soft/1863.html 下载一个VMware

VMware Workstation(虚拟机) v9.0.1官方正式版

• SUSE LINUX 下载： 直接到SUSE 网站下载
  

  SUSELinux Enterprise Server for SAP applications
  SLE-11-SP2-SAP-DVD-x86_64-GM-DVD.iso

据库下载和安装：据SAP 安装文档介绍，HANA 数据库安装由硬件合作伙伴负责。能不能自己安装测试呢？

--> https://websmp107.sap-ag.de/swdc -->Installations and Upgrades - H" SAP In-Memory (SAP HANA)" HANA PlatformEdition" SAP HANA PLATFORMEDITION" SAP HANA PLATFORM EDIT.1.0

解压完以后的清单:

• SAP Netweaver 7.4 下载：跟普通下载一致，省去。

2.2 安装

2.2.1 安装Vmware

常规安装方法，省去。

2.2.2 安装Linux
Suse Linux 用的是SAP的一个linux 安装包 SLE-11-SP2-SAP-DVD-x86_64-GM-DVD

输入root 及 root password:  root

跳过这个提示。

后续安装

 

打开一个命令窗口，输入

yast2

A. 设置时区

B. 设置网络及主机名

C. 设置FTP服务器


 




2.2.3 安装HANA
这次参考的是这个blog.
http://blog.chinaunix.net/uid-16765068-id-3476342.html

按这个blog中的提示，修改后：
原Blog:

目录下的HanaHwCheck.py文件改名：

        mvHanaHwCheck.pyHanaHwCheck.py.bak         

saphana01:/sapcds/HDB_SERVER_LINUX_X86_64 # ./hdbinst

  Installation failed
    Hardwarecheck script'/sapcds/HDB_SERVER_LINUX_X86_64/server/HanaHwCheck.py' notfound

 

只好改回来。

saphana01:/sapcds/HDB_SERVER_LINUX_X86_64 # ./hdbinst

SAP HANA Database installation kit detected.
  Installation failed
    Checkingsystem requirements failed
     Performing HANA platform check script failed
       Performing python script failed
         Starting external program /usr/bin/python
           Command line is: /usr/bin/python/sapcds/HDB_SERVER_LINUX_X86_64/server/HanaHwCheck.py
           Output line 1:
           Output line 2: performing Hardware check......
           Output line 3:
           Output line 4: SystemManufacturer           VMware,Inc.             OK       
           Output line 5: System ProductName           VMware Virtual Platform  OK       
           Output line 6: CPUModel                     CPU                      not supported
           Output line 7:OS                            SLES 11 SP1             OK       
           Output line 8: MemoryTotal                  768MB                   not enough memory or wrong memory configuration!
           Output line 9: MemoryTotal                  768MB                   OK       
           Output line 10: Corecount                    2                        OK       
           Output line 11:Hyper-threading               Notactive               
           Output line 12:
           Output line 13: ### WARNING: Hyper-threading not activated ordeterminable!! ###
           Output line 14:
           Output line 15: Numafunctionality            Activated                OK       
           Output line 16:
           Output line 17: Hardware check failed!!
           Output line 18:
           Program terminated with exit code 255

方法： 修改HanaHwCheck.py，新增一条语句： rc =1

saphana01:/sapcds/HDB_SERVER_LINUX_X86_64/server # viHanaHwCheck.py

                     self.HWInfo['Factor']=float(args['-machine_utilization'])/100
               else:
                       self.HWInfo['Factor']=1
               rc = self.compareResults()
               rc = 1

saphana01:/sapcds/HDB_SERVER_LINUX_X86_64 # ./hdbinst

SAP HANA Database installation kit detected.


SAP HANA Database Installation Manager - Database Installation1.00.60.379371
*****************************************************************************


Enter Installation Path [/hana/shared]:
Enter SAP HANA system ID: N74
Enter Instance Number [00]: 00
Enter System Administrator (n74adm) Password:
Confirm System Administrator (n74adm) Password:
  Password confirmation failed

Enter System Administrator (n74adm) Password:
  System Administrator (n74adm) Password mustcontain at least 8 characters


Enter System Administrator (n74adm) Password: hana@2013
Confirm System Administrator (n74adm) Password: hana@2013
Enter System Administrator Home Directory[/usr/sap/N74/home]:
Enter System Administrator Login Shell [/bin/sh]:
Enter System Administrator User Id [1001]:
Enter Group Id (sapsys) [79]:
Enter Location of Data Volumes[/hana/shared/N74/global/hdb/data]:
Enter Location of Log Volumes[/hana/shared/N74/global/hdb/log]:
Enter Password of Database User SYSTEM:
  System Administrator (n74adm) Password mustcontain at least 8 characters
  Password of Database User SYSTEM isinvalid
    Password ofDatabase User SYSTEM must contain at least one upper-casecharacter

Enter Password of Database User SYSTEM:
  System Administrator (n74adm) Password mustcontain at least 8 characters
  Password of Database User SYSTEM isinvalid
    Password ofDatabase User SYSTEM must contain at least one upper-casecharacter
  Password of Database User SYSTEM isinvalid
    Password ofDatabase User SYSTEM must contain at least one upper-casecharacter

Enter Password of Database User SYSTEM:
  System Administrator (n74adm) Password mustcontain at least 8 characters
  Password of Database User SYSTEM isinvalid
    Password ofDatabase User SYSTEM must contain at least one upper-casecharacter
  Password of Database User SYSTEM isinvalid
    Password ofDatabase User SYSTEM must contain at least one upper-casecharacter
  Password of Database User SYSTEM isinvalid
    Password ofDatabase User SYSTEM must contain at least one upper-casecharacter

Enter Password of Database User SYSTEM: Hana@2013
Confirm Password of Database User SYSTEM: Hana@2013

Restart instance after machine reboot [n]: y
  Installation failed
    Errorchecking installation
     Checking minimum memory requirement failed
       Physical memory on this host is 0.720 GB.Minimum required: 24 GB.
       Override memory check with command line option--ignore=check_min_mem

解决方案：增加--ignore=check_min_mem
saphana01:/sapcds/HDB_SERVER_LINUX_X86_64 # ./hdbinst --ignore=check_min_mem

08:12:27.372 - ERR :   Cannotcreate Instance
08:12:27.372 - ERR :   errorinstalling
08:12:27.372 - ERR :  Installation failed
08:12:27.402 - INFO:   Summary ofcritical errors
08:12:27.372 - ERR:    Installation failed
08:12:27.372 - ERR:      error installing
08:12:27.372 - ERR:        Cannot create Instance
08:12:27.372 - ERR:          Cannot create instance
08:12:27.372 - ERR:            Cannot create SecureStore
08:12:11.624 -INFO:              Starting external program /usr/sap/N74/HDB00/exe/hdbnsutil
08:12:11.625 -INFO:                Command line is: /usr/sap/N74/HDB00/exe/hdbnsutil-createSecureStore
08:12:27.371 - ERR:              Program /usr/sap/N74/HDB00/exe/hdbnsutil terminated with error:signal 11
08:12:27.371 - ERR:              hdbnsutil call failed

解决方案：
增大物理内存到24G左右，此问题解决。

至此，Hana Database 安装完成。

2.2.4 安装SAP Netweaver 7.4

安装SAP Netweaver 7.4的方法，与标准的数据库一致。比较大的不同是，SAP一定要与 Hana Database安装在不同的两台机器上。

SAP 实例必须与 HANA database 实例在不同的两台机器上，否则报错如下。
 

 

 

将Schema 改成了SAPSR3

下面省去一些与标准数据库相同的截屏

安装完成。

可以看到 现在系统使用的数据库是 Hana DB:1.00.60.

DB02 数据库管理工具：

已知的错误：

 

根据 Note1391070 - Linux UUID solutions,下载相关的 Script "check-libuuid.sh", 并按如下方式运行：

saphana01:/sapcds # ./check-libuuid.sh

[ check-libuuid.sh Revision : #17 $ Date : 2012/11/09 $ ]

SLES 11 (SP 2) system

libuuid package: libuuid1-2.19.1-6.29.3

uuidd package: uuid-runtime-2.19.1-6.29.3

uuidd is active.

uuidd is running on-demand (-T 300).

ERROR: uuidd running as user root!

package sapconf is not installed

Please install rpm package sapconf.

 

解决方案：安装sapconf

saphana01:/sapcds # ./check-libuuid.sh

[ check-libuuid.sh Revision : #17 $ Date : 2012/11/09 $ ]

SLES 11 (SP 2) system

libuuid package: libuuid1-2.19.1-6.29.3

uuidd package: uuid-runtime-2.19.1-6.29.3

uuidd is active.

uuidd is running on-demand (-T 300).

installed libuuid and uuidd are ok!

/usr/sbin/uuidd -t ok!