Install HANA Database
Install HANA Database
yum update
yum upgrade
yum install libaio libtool-ltdl bzip2 unzip wget gcc gcc-c++ automake
Install latest GCC from source -
curl -L -O http://ftp.tsukuba.wide.ad.jp/software/gcc/releases/gcc-8.2.0/gcc-8.2.0.tar.xz
tar xf gcc-8.2.0.tar.xz
cd gcc-8.2.0
./contrib/download_prerequisites
./configure --enable-languages=c,c++ --disable-multilib
make -j $(nproc)
make install
Configure ldconfig -
Add following file in /etc/ld.so.conf.d/gcc-x86_64.conf
/usr/local/lib64
Update ld config cache by executing "ldconfig -v
"
Add A record for your server in your DNS server.
Change CentOS release file by executing following command -
echo "Red Hat Enterprise Linux Server release 7.4 (Maipo)" > /etc/redhat-release
Unzip binary files and grant execution permission -
unzip HDB_SERVER_LINUX_X86_64.zip
cd HDB_SERVER_LINUX_X86_64
chmod -R u+x ./
Run the following command to obtain the dump configfile.cfg file
./hdblcm --action=install --dump_configfile_template=./configfile.cfg
Modify dump configuration file as per as your requirements -
[General]
# Location of SAP HANA Database Installation Medium
component_medium=
# Comma separated list of component directories
component_dirs=
# Directory root to search for components
component_root=
# Use single master password for all users, created during installation ( Default: n )
use_master_password=n
# Skip all SAP Host Agent calls ( Default: n )
skip_hostagent_calls=n
# Remote Execution ( Default: ssh; Valid values: ssh | saphostagent )
remote_execution=ssh
# Components ( Valid values: all | client | es | ets | lcapps | server | smartda | streaming | rdsync | xs | studio | afl | sca | sop | eml | rme | rtl | trp | vch )
components=
# Ignores failing prerequisite checks
ignore=
# Do not Modify '/etc/sudoers' File ( Default: n )
skip_modify_sudoers=n
[Action]
# Action ( Default: exit; Valid values: install | update | extract_components )
action=install
[Server]
# Enable the installation or upgrade of the SAP Host Agent ( Default: y )
install_hostagent=y
# Database Isolation ( Default: low; Valid values: low | high )
db_isolation=low
# Create initial tenant database ( Default: y )
create_initial_tenant=y
# Non-standard Shared File System
checkmnt=
# Installation Path ( Default: /hana/shared )
sapmnt=/hana/shared
# Local Host Name ( Default: bpblhts )
hostname=bpblhts
# Install SSH Key ( Default: y )
install_ssh_key=y
# Root User Name ( Default: root )
root_user=root
# Root User Password
root_password=
# Directory containing a storage configuration
storage_cfg=
# Internal Network Address
internal_network=
# SAP HANA System ID
sid=HTS
# Instance Number
number=00
# Local Host Worker Group ( Default: default )
workergroup=default
# System Usage ( Default: custom; Valid values: production | test | development | custom )
system_usage=test
# Location of Data Volumes ( Default: /hana/data/${sid} )
datapath=/hana/data/${sid}
# Location of Log Volumes ( Default: /hana/log/${sid} )
logpath=/hana/log/${sid}
# Directory containing custom configurations
custom_cfg=
# Restrict maximum memory allocation?
restrict_max_mem=n
# Maximum Memory Allocation in MB
max_mem=
# Certificate Host Names
certificates_hostmap=
# Master Password
master_password=
# SAP Host Agent User (sapadm) Password
sapadm_password=D+yKgKxv2yD$ecn
# System Administrator Password
password=uBV=MsPS^E4BGE7y
# System Administrator Home Directory ( Default: /usr/sap/${sid}/home )
home=/usr/sap/${sid}/home
# System Administrator Login Shell ( Default: /bin/sh )
shell=/bin/sh
# System Administrator User ID
userid=1000
# ID of User Group (sapsys)
groupid=79
# Database User (SYSTEM) Password
system_user_password=zUc8R9Vkd496Y%E
# Restart system after machine reboot? ( Default: n )
autostart=n
# Enable HANA repository ( Default: y )
repository=y
# Inter Service Communication Mode ( Valid values: standard | ssl )
isc_mode=
[AddHosts]
# Auto Initialize Services ( Default: y )
auto_initialize_services=y
# Additional Hosts
addhosts=
# Additional Local Host Roles ( Valid values: extended_storage_worker | extended_storage_standby | ets_worker | ets_standby | streaming | rdsync | xs_worker | xs_standby )
add_local_roles=
# Automatically assign XS Advanced Runtime roles to the hosts with database roles (y/n) ( Default: y )
autoadd_xs_roles=y
# Imports initial content of XS Advanced Runtime ( Default: y )
import_xs_content=y
[Client]
# SAP HANA Database Client Installation Path ( Default: ${sapmnt}/${sid}/hdbclient )
client_path=/hana/shared/${sid}/hdbclient
[Studio]
# SAP HANA Studio Installation Path ( Default: ${sapmnt}/${sid}/hdbstudio )
studio_path=/hana/shared/${sid}/hdbstudio
# Enables copying of SAP HANA Studio repository ( Default: y )
studio_repository=y
# Target path to which SAP HANA Studio repository should be copied
copy_repository=
# Java Runtime ( Default: )
vm=
[Reference_Data]
# Installation Path for Address Directories and Reference Data
reference_data_path=
[streaming]
# Streaming Cluster Manager Password
streaming_cluster_manager_password=
# Location of Streaming logstores and runtime information ( Default: /hana/data_streaming/${sid} )
basepath_streaming=/hana/data_streaming/${sid}
[es]
# Location of Dynamic Tiering Data Volumes ( Default: /hana/data_es/${sid} )
es_datapath=/hana/data_es/${sid}
# Location of Dynamic Tiering Log Volumes ( Default: /hana/log_es/${sid} )
es_logpath=/hana/log_es/${sid}
[ets]
# Location of Data Volumes of the Accelerator for SAP ASE ( Default: /hana/data_ase/${sid} )
ase_datapath=/hana/data_ase/${sid}
# Location of Log Volumes of the Accelerator for SAP ASE ( Default: /hana/log_ase/${sid} )
ase_logpath=/hana/log_ase/${sid}
# SAP ASE Administrator User ( Default: sa )
ase_user=sa
# SAP ASE Administrator Password
ase_user_password=
[rdsync]
# Location of SAP HANA Remote Data Sync file download directory ( Default: /hana/download_rdsync/${sid} )
rdsync_downloadpath=/hana/download_rdsync/${sid}
# Location of SAP HANA Remote Data Sync file upload directory ( Default: /hana/upload_rdsync/${sid} )
rdsync_uploadpath=/hana/upload_rdsync/${sid}
[XS_Advanced]
# XS Advanced App Working Path
xs_app_working_path=
# Organization Name For Space "SAP" ( Default: orgname )
org_name=orgname
# XS Advanced Admin User ( Default: XSA_ADMIN )
org_manager_user=XSA_ADMIN
# XS Advanced Admin User Password
org_manager_password=
# Customer Space Name ( Default: PROD )
prod_space_name=PROD
# Routing Mode ( Default: ports; Valid values: ports | hostnames )
xs_routing_mode=ports
# XS Advanced Domain Name (see SAP Note 2245631)
xs_domain_name=
# Run Applications in SAP Space with Separate OS User (y/n) ( Default: y )
xs_sap_space_isolation=y
# Run Applications in Customer Space with Separate OS User (y/n) ( Default: y )
xs_customer_space_isolation=y
# XS Advanced SAP Space OS User ID
xs_sap_space_user_id=
# XS Advanced Customer Space OS User ID
xs_customer_space_user_id=
# XS Advanced Components
xs_components=
# Do not start the selected XS Advanced components after installation ( Default: none )
xs_components_nostart=none
# XS Advanced Components Configurations
xs_components_cfg=
# XS Advanced Certificate
xs_cert_pem=
# XS Advanced Certificate Key
xs_cert_key=
# XS Advanced Trust Certificate
xs_trust_pem=
Create directories according to the value of your configruation file
sid=HTS
mkdir -p /hana/shared
mkdir -p /hana/data/$sid
mkdir -p /hana/log/$sid
Install HANA databae by executing following command -
./hdblcm --action=install --configfile=./configfile.cfg
Do you want to add hosts to the system? (y/n) [n]:
Enter Certificate Host Name For Host 'bpblhts' [bpblhts]:
Summary before execution:
=========================
SAP HANA Database System Installation
Installation Parameters
Remote Execution: ssh
Database Isolation: low
Installation Path: /hana/shared
Local Host Name: bpblhts
SAP HANA System ID: HTS
Instance Number: 00
Local Host Worker Group: default
System Usage: test
Location of Data Volumes: /hana/data/HTS
Location of Log Volumes: /hana/log/HTS
Maximum Memory Allocation in MB: 61440
Certificate Host Names: bpblhts -> bpblhts
System Administrator Home Directory: /usr/sap/HTS/home
System Administrator Login Shell: /bin/sh
System Administrator User ID: 1000
ID of User Group (sapsys): 79
Software Components
SAP HANA Database
Install version 2.00.020.00.1500920972
Location: /root/HDB_SERVER_LINUX_X86_64/server
Do you want to continue? (y/n): y
Installing components...
...[output omitted]...
Installing SAP HANA Database...
SAP HANA Database System installed
You can send feedback to SAP with this form: https://bpblhts:1129/lmsl/HDBLCM/HTS/feedback/feedback.html
Log file written to '/var/tmp/hdb_HTS_hdblcm_install_2018-11-27_14.50.56/hdblcm.log' on host 'BPBLHTS'.
Allow firewall port 30015/tcp to manage database from HANA studio
firewall-cmd --add-port=30015/tcp --permanent
Reload firewall rules by executing "firewall-cmd --reload
"