基于SAP HANA 的SAP系统 安装

最近越来越多的公司在考虑HANA了，作为有10几年经验的SAP Basis顾问，必须得鸟枪换炮，用时下流行的，那就是转型（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 网站下载
  SUSE Linux Enterprise Server for SAP applicationsSLE-11-SP2-SAP-DVD-x86_64-GM-DVD.iso
  

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

[url=]--> https://websmp107.sap-ag.de/swdc --> Installations and Upgrades - H[/url]" [url=]SAP In-Memory (SAP HANA )[/url]" [url=]HANA Platform Edition[/url]" [url=]SAP HANA PLATFORM EDITION[/url]" [url=]SAP HANA PLATFORM EDIT. 1.0[/url]

解压完以后的清单:

• 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

跳过这个提示。

后续安装

A. 设置时区

B. 设置网络及主机名

C. 设置FTP服务器


  




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

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

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

        mv HanaHwCheck.py HanaHwCheck.py.bak         

saphana01:/sapcds/HDB_SERVER_LINUX_X86_64 # ./hdbinst

  Installation failed
    Hardware check script '/sapcds/HDB_SERVER_LINUX_X86_64/server/HanaHwCheck.py' not found

只好改回来。

saphana01:/sapcds/HDB_SERVER_LINUX_X86_64 # ./hdbinst

SAP HANA Database installation kit detected.
  Installation failed
    Checking system 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: System Manufacturer            VMware, Inc.              OK      
            Output line 5: System Product Name            VMware Virtual Platform   OK      
            Output line 6: CPU Model                      CPU                       not supported
            Output line 7: OS                             SLES 11 SP 1              OK      
            Output line 8: Memory Total                   768 MB                    not enough memory or wrong memory configuration!
            Output line 9: Memory Total                   768 MB                    OK      
            Output line 10: Core count                     2                         OK      
            Output line 11: Hyper-threading                Not active               
            Output line 12:
            Output line 13: ### WARNING: Hyper-threading not activated or determinable!! ###
            Output line 14:
            Output line 15: Numa functionality             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 # vi HanaHwCheck.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 Installation 1.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 must contain 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 must contain at least 8 characters
  Password of Database User SYSTEM is invalid
    Password of Database User SYSTEM must contain at least one upper-case character

Enter Password of Database User SYSTEM:
  System Administrator (n74adm) Password must contain at least 8 characters
  Password of Database User SYSTEM is invalid
    Password of Database User SYSTEM must contain at least one upper-case character
  Password of Database User SYSTEM is invalid
    Password of Database User SYSTEM must contain at least one upper-case character

Enter Password of Database User SYSTEM:
  System Administrator (n74adm) Password must contain at least 8 characters
  Password of Database User SYSTEM is invalid
    Password of Database User SYSTEM must contain at least one upper-case character
  Password of Database User SYSTEM is invalid
    Password of Database User SYSTEM must contain at least one upper-case character
  Password of Database User SYSTEM is invalid
    Password of Database User SYSTEM must contain at least one upper-case character

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
    Error checking 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 :   Cannot create Instance
08:12:27.372 - ERR :   error installing
08:12:27.372 - ERR :   Installation failed
08:12:27.402 - INFO:   Summary of critical 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 数据库管理工具：

已知的错误：

根据 Note 1391070 - 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!

楼主，图片好像挂了，看不到图片啊。。。