Install HANA Database
Install HANA Database
yum updateyum upgradeyum install libaio libtool-ltdl bzip2 unzip wget gcc gcc-c++ automakeInstall 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.xztar xf gcc-8.2.0.tar.xzcd gcc-8.2.0./contrib/download_prerequisites./configure --enable-languages=c,c++ --disable-multilibmake -j $(nproc) make installConfigure 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-releaseUnzip binary files and grant execution permission -
unzip HDB_SERVER_LINUX_X86_64.zipcd HDB_SERVER_LINUX_X86_64chmod -R u+x ./Run the following command to obtain the dump configfile.cfg file
./hdblcm --action=install --dump_configfile_template=./configfile.cfgModify dump configuration file as per as your requirements -
[General]# Location of SAP HANA Database Installation Mediumcomponent_medium=# Comma separated list of component directoriescomponent_dirs=# Directory root to search for componentscomponent_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 checksignore=# 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 Systemcheckmnt=# 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 Passwordroot_password=# Directory containing a storage configurationstorage_cfg=# Internal Network Addressinternal_network=# SAP HANA System IDsid=HTS# Instance Numbernumber=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 configurationscustom_cfg=# Restrict maximum memory allocation?restrict_max_mem=n# Maximum Memory Allocation in MBmax_mem=# Certificate Host Namescertificates_hostmap=# Master Passwordmaster_password=# SAP Host Agent User (sapadm) Passwordsapadm_password=D+yKgKxv2yD$ecn# System Administrator Passwordpassword=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 IDuserid=1000# ID of User Group (sapsys)groupid=79# Database User (SYSTEM) Passwordsystem_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 Hostsaddhosts=# 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 copiedcopy_repository=# Java Runtime ( Default: )vm=[Reference_Data]# Installation Path for Address Directories and Reference Datareference_data_path=[streaming]# Streaming Cluster Manager Passwordstreaming_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 Passwordase_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 Pathxs_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 Passwordorg_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 IDxs_sap_space_user_id=# XS Advanced Customer Space OS User IDxs_customer_space_user_id=# XS Advanced Componentsxs_components=# Do not start the selected XS Advanced components after installation ( Default: none )xs_components_nostart=none# XS Advanced Components Configurationsxs_components_cfg=# XS Advanced Certificatexs_cert_pem=# XS Advanced Certificate Keyxs_cert_key=# XS Advanced Trust Certificatexs_trust_pem=Create directories according to the value of your configruation file
sid=HTSmkdir -p /hana/sharedmkdir -p /hana/data/$sidmkdir -p /hana/log/$sidInstall HANA databae by executing following command -
./hdblcm --action=install --configfile=./configfile.cfgDo 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/serverDo you want to continue? (y/n): yInstalling components......[output omitted]...Installing SAP HANA Database...SAP HANA Database System installedYou can send feedback to SAP with this form: https://bpblhts:1129/lmsl/HDBLCM/HTS/feedback/feedback.htmlLog 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 --permanentReload firewall rules by executing "firewall-cmd --reload"