基于SAP-HANA的SAP系統(tǒng)安裝

基于SAPHANA的SAP系統(tǒng)安裝最近越來(lái)越多的公司在考慮HANA了，作為有10幾年經(jīng)驗(yàn)的SAPBasis參謀，必須得鳥槍換炮，用時(shí)下流行的，那就是轉(zhuǎn)型〔Transformation)。希望通過(guò)Blog記下自己學(xué)習(xí)HANA的點(diǎn)點(diǎn)滴滴，同時(shí)也催促自己學(xué)習(xí)。1.概述篇1.1一種新型數(shù)據(jù)庫(kù)〔OLTP)1.2一種新型數(shù)據(jù)分析工具(OLAP)HANA=OLTP+OLAP?2.安裝篇本文以安裝Netweaver7.4為例。2.1準(zhǔn)備及下載VMware下載：VMwareWorkstation9.0.1://crsky/soft/1863.html下載一個(gè)VMwareVMwareWorkstation(虛擬機(jī))v9.0.1官方正式版SUSELINUX下載：直接到SUSE網(wǎng)站下載

SUSELinuxEnterpriseServerforSAPapplicationsSLE-11-SP2-SAP-DVD-x86_64-GM-DVD.iso

據(jù)庫(kù)下載和安裝：據(jù)SAP安裝文檔介紹，HANA數(shù)據(jù)庫(kù)安裝由硬件合作伙伴負(fù)責(zé)。能不能自己安裝測(cè)試呢？-->s://websmp107.sap-ag.de/swdc-->InstallationsandUpgrades-H"SAPIn-Memory(SAPHANA)"HANAPlatformEdition"SAPHANAPLATFORMEDITION"SAPHANAPLATFORMEDIT.1.0

解壓完以后的清單:SAPNetweaver7.4下載：跟普通下載一致，省去。

2.2安裝

2.2.1安裝Vmware常規(guī)安裝方法，省去。

2.2.2安裝Linux

SuseLinux用的是SAP的一個(gè)linux安裝包SLE-11-SP2-SAP-DVD-x86_64-GM-DVD

輸入root及rootpassword:root

跳過(guò)這個(gè)提示。

后續(xù)安裝

A.設(shè)置時(shí)區(qū)

B.設(shè)置網(wǎng)絡(luò)及主機(jī)名

C.設(shè)置FTP效勞器

2.2.3安裝HANA

這次參考的是這個(gè)blog.

按這個(gè)blog中的提示，修改后：

原Blog:目錄下的HanaHwCheck.py文件改名：mvHanaHwCheck.pyHanaHwCheck.py.bak

saphana01:/sapcds/HDB_SERVER_LINUX_X86_64#./hdbinst

Installationfailed

Hardwarecheckscript'/sapcds/HDB_SERVER_LINUX_X86_64/server/HanaHwCheck.py'notfound

只好改回來(lái)。saphana01:/sapcds/HDB_SERVER_LINUX_X86_64#./hdbinst

SAPHANADatabaseinstallationkitdetected.

Installationfailed

Checkingsystemrequirementsfailed

PerformingHANAplatformcheckscriptfailed

Performingpythonscriptfailed

Startingexternalprogram/usr/bin/python

Commandlineis:/usr/bin/python/sapcds/HDB_SERVER_LINUX_X86_64/server/HanaHwCheck.py

Outputline1:

Outputline2:performingHardwarecheck......

Outputline3:

Outputline4:SystemManufacturerVMware,Inc.OK

Outputline5:SystemProductNameVMwareVirtualPlatformOK

Outputline6:CPUModelCPUnotsupported

Outputline7:OSSLES11SP1OK

Outputline8:MemoryTotal768MBnotenoughmemoryorwrongmemoryconfiguration!

Outputline9:MemoryTotal768MBOK

Outputline10:Corecount2OK

Outputline11:Hyper-threadingNotactive

Outputline12:

Outputline13:###WARNING:Hyper-threadingnotactivatedordeterminable!!###

Outputline14:

Outputline15:NumafunctionalityActivatedOK

Outputline16:

Outputline17:Hardwarecheckfailed!!

Outputline18:

Programterminatedwithexitcode255

方法：修改HanaHwCheck.py，新增一條語(yǔ)句：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=selfpareResults()

rc=1

saphana01:/sapcds/HDB_SERVER_LINUX_X86_64#./hdbinst

SAPHANADatabaseinstallationkitdetected.

*****************************************************************************

EnterInstallationPath[/hana/shared]:

EnterSAPHANAsystemID:N74

EnterInstanceNumber[00]:00

EnterSystemAdministrator(n74adm)Password:

ConfirmSystemAdministrator(n74adm)Password:

Passwordconfirmationfailed

EnterSystemAdministrator(n74adm)Password:

SystemAdministrator(n74adm)Passwordmustcontainatleast8characters

EnterSystemAdministrator(n74adm)Password:hana@2023

ConfirmSystemAdministrator(n74adm)Password:hana@2023

EnterSystemAdministratorHomeDirectory[/usr/sap/N74/home]:

EnterSystemAdministratorLoginShell[/bin/sh]:

EnterSystemAdministratorUserId[1001]:

EnterGroupId(sapsys)[79]:

EnterLocationofDataVolumes[/hana/shared/N74/global/hdb/data]:

EnterLocationofLogVolumes[/hana/shared/N74/global/hdb/log]:

EnterPasswordofDatabaseUserSYSTEM:

SystemAdministrator(n74adm)Passwordmustcontainatleast8characters

PasswordofDatabaseUserSYSTEMisinvalid

PasswordofDatabaseUserSYSTEMmustcontainatleastoneupper-casecharacter

EnterPasswordofDatabaseUserSYSTEM:

SystemAdministrator(n74adm)Passwordmustcontainatleast8characters

PasswordofDatabaseUserSYSTEMisinvalid

PasswordofDatabaseUserSYSTEMmustcontainatleastoneupper-casecharacter

PasswordofDatabaseUserSYSTEMisinvalid

PasswordofDatabaseUserSYSTEMmustcontainatleastoneupper-casecharacter

EnterPasswordofDatabaseUserSYSTEM:

SystemAdministrator(n74adm)Passwordmustcontainatleast8characters

PasswordofDatabaseUserSYSTEMisinvalid

PasswordofDatabaseUserSYSTEMmustcontainatleastoneupper-casecharacter

PasswordofDatabaseUserSYSTEMisinvalid

PasswordofDatabaseUserSYSTEMmustcontainatleastoneupper-casecharacter

PasswordofDatabaseUserSYSTEMisinvalid

PasswordofDatabaseUserSYSTEMmustcontainatleastoneupper-casecharacter

EnterPasswordofDatabaseUserSYSTEM:Hana@2023

ConfirmPasswordofDatabaseUserSYSTEM:Hana@2023

Restartinstanceaftermachinereboot[n]:y

Installationfailed

Errorcheckinginstallation

Checkingminimummemoryrequirementfailed

Physicalmemoryonthishostis0.720GB.Minimumrequired:24GB.

Overridememorycheckwithcommandlineoption--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:CannotcreateInstance

08:12:27.372-ERR:errorinstalling

08:12:27.372-ERR:Installationfailed

08:12:27.402-INFO:Summaryofcriticalerrors

08:12:27.372-ERR:Installationfailed

08:12:27.372-ERR:errorinstalling

08:12:27.372-ERR:CannotcreateInstance

08:12:27.372-ERR:Cannotcreateinstance

08:12:27.372-ERR:CannotcreateSecureStore

08:12:11.624-INFO:Startingexternalprogram/usr/sap/N74/HDB00/exe/hdbnsutil

08:12:11.625-INFO:Commandlineis:/usr/sap/N74/HDB00/exe/hdbnsutil-createSecureStore

08:12:27.371-ERR:Program/usr/sap/N74/HDB00/exe/hdbnsutilterminatedwitherror:signal11

08:12:27.371-ERR:hdbnsutilcallfailed

解決方案：

增大物理內(nèi)存到24G左右，此問(wèn)題解決。

至此，HanaDatabase安裝完成。

2.2.4安裝SAPNetweaver7.4安裝SAPNetweaver7.4的方法，與標(biāo)準(zhǔn)的數(shù)據(jù)庫(kù)一致。比擬大的不同是，SAP一定要與HanaDat