First we'll install HANA 2.0

Pre-requsite

SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ./hdbinst
SAP HANA Database installation kit detected.
Installation failed
  Checking system requirements failed
    rpm package 'libgcc_s1' needs at least version 6.2. (current version = 5.3.1+r233831)
    rpm package 'libstdc++6' needs at least version 6.2. (current version = 5.3.1+r233831)
    The operating system is not ready to perform gcc 6 assemblies
    For more information, see SAP Note 2455582.

SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # rpm -qa |grep libgcc
libgcc_s1-5.3.1+r233831-6.1.x86_64
SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ftp://rpmfind.net/linux/opensuse/update/leap/42.2/oss/x86_64/libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm^C
SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # wget ftp://rpmfind.net/linux/opensuse/update/leap/42.2/oss/x86_64/libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm
--2017-09-19 18:06:54--  ftp://rpmfind.net/linux/opensuse/update/leap/42.2/oss/x86_64/libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm
           => ‘libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm’
Resolving rpmfind.net (rpmfind.net)... 195.220.108.108
Connecting to rpmfind.net (rpmfind.net)|195.220.108.108|:21... connected.
Logging in as anonymous ... Logged in!
==> SYST ... done.    ==> PWD ... done.
==> TYPE I ... done.  ==> CWD (1) /linux/opensuse/update/leap/42.2/oss/x86_64 ... done.
==> SIZE libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm ... 44453
==> PASV ... done.    ==> RETR libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm ... done.
Length: 44453 (43K) (unauthoritative)

100%[==========================================================================================================================>] 44,453      --.-K/s   in 0.1s

2017-09-19 18:06:56 (309 KB/s) - ‘libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm’ saved [44453]

SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ls -ltr *.rpm
-rw-r--r-- 1 4294967294 4294967294 44453 Sep 19 18:06 libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm
SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # rpm -Uvh *r239768-5.5.2.x86_64.rpm
warning: libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID 3dbdc284: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:libgcc_s1-6.2.1+r239768-5.5.2    ################################# [ 50%]
Cleaning up / removing...
   2:libgcc_s1-5.3.1+r233831-6.1      ################################# [100%]
SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ./hdbinst
SAP HANA Database installation kit detected.
Installation failed
  Checking system requirements failed
    rpm package 'libstdc++6' needs at least version 6.2. (current version = 5.3.1+r233831)
    The operating system is not ready to perform gcc 6 assemblies
    For more information, see SAP Note 2455582.

SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # wget ftp://rpmfind.net/linux/opensuse/update/leap/42.2/oss/x86_64/libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm
--2017-09-19 18:08:13--  ftp://rpmfind.net/linux/opensuse/update/leap/42.2/oss/x86_64/libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm
           => ‘libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm’
Resolving rpmfind.net (rpmfind.net)... 195.220.108.108
Connecting to rpmfind.net (rpmfind.net)|195.220.108.108|:21... connected.
Logging in as anonymous ... Logged in!
==> SYST ... done.    ==> PWD ... done.
==> TYPE I ... done.  ==> CWD (1) /linux/opensuse/update/leap/42.2/oss/x86_64 ... done.
==> SIZE libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm ... 372982
==> PASV ... done.    ==> RETR libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm ... done.
Length: 372982 (364K) (unauthoritative)

100%[==========================================================================================================================>] 372,982      318KB/s   in 1.1s

2017-09-19 18:08:16 (318 KB/s) - ‘libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm’ saved [372982]

SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ls -l *.rpm
-rw-r--r-- 1 4294967294 4294967294  44453 Sep 19 18:06 libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm
-rw-r--r-- 1 4294967294 4294967294 372982 Sep 19 18:08 libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm
SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # rpm -Uvh libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm
warning: libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID 3dbdc284: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:libstdc++6-6.2.1+r239768-5.5.2   ################################# [ 50%]
Cleaning up / removing...
   2:libstdc++6-5.3.1+r233831-6.1     ################################# [100%]
First we'll install HANA 2.0 ============================ Pre-requsite ------------------ ```` SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ./hdbinst SAP HANA Database installation kit detected. Installation failed Checking system requirements failed rpm package 'libgcc_s1' needs at least version 6.2. (current version = 5.3.1+r233831) rpm package 'libstdc++6' needs at least version 6.2. (current version = 5.3.1+r233831) The operating system is not ready to perform gcc 6 assemblies For more information, see SAP Note 2455582. SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # rpm -qa |grep libgcc libgcc_s1-5.3.1+r233831-6.1.x86_64 SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ftp://rpmfind.net/linux/opensuse/update/leap/42.2/oss/x86_64/libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm^C SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # wget ftp://rpmfind.net/linux/opensuse/update/leap/42.2/oss/x86_64/libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm --2017-09-19 18:06:54-- ftp://rpmfind.net/linux/opensuse/update/leap/42.2/oss/x86_64/libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm => ‘libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm’ Resolving rpmfind.net (rpmfind.net)... 195.220.108.108 Connecting to rpmfind.net (rpmfind.net)|195.220.108.108|:21... connected. Logging in as anonymous ... Logged in! ==> SYST ... done. ==> PWD ... done. ==> TYPE I ... done. ==> CWD (1) /linux/opensuse/update/leap/42.2/oss/x86_64 ... done. ==> SIZE libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm ... 44453 ==> PASV ... done. ==> RETR libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm ... done. Length: 44453 (43K) (unauthoritative) 100%[==========================================================================================================================>] 44,453 --.-K/s in 0.1s 2017-09-19 18:06:56 (309 KB/s) - ‘libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm’ saved [44453] SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ls -ltr *.rpm -rw-r--r-- 1 4294967294 4294967294 44453 Sep 19 18:06 libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # rpm -Uvh *r239768-5.5.2.x86_64.rpm warning: libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID 3dbdc284: NOKEY Preparing... ################################# [100%] Updating / installing... 1:libgcc_s1-6.2.1+r239768-5.5.2 ################################# [ 50%] Cleaning up / removing... 2:libgcc_s1-5.3.1+r233831-6.1 ################################# [100%] SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ./hdbinst SAP HANA Database installation kit detected. Installation failed Checking system requirements failed rpm package 'libstdc++6' needs at least version 6.2. (current version = 5.3.1+r233831) The operating system is not ready to perform gcc 6 assemblies For more information, see SAP Note 2455582. SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # wget ftp://rpmfind.net/linux/opensuse/update/leap/42.2/oss/x86_64/libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm --2017-09-19 18:08:13-- ftp://rpmfind.net/linux/opensuse/update/leap/42.2/oss/x86_64/libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm => ‘libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm’ Resolving rpmfind.net (rpmfind.net)... 195.220.108.108 Connecting to rpmfind.net (rpmfind.net)|195.220.108.108|:21... connected. Logging in as anonymous ... Logged in! ==> SYST ... done. ==> PWD ... done. ==> TYPE I ... done. ==> CWD (1) /linux/opensuse/update/leap/42.2/oss/x86_64 ... done. ==> SIZE libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm ... 372982 ==> PASV ... done. ==> RETR libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm ... done. Length: 372982 (364K) (unauthoritative) 100%[==========================================================================================================================>] 372,982 318KB/s in 1.1s 2017-09-19 18:08:16 (318 KB/s) - ‘libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm’ saved [372982] SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ls -l *.rpm -rw-r--r-- 1 4294967294 4294967294 44453 Sep 19 18:06 libgcc_s1-6.2.1+r239768-5.5.2.x86_64.rpm -rw-r--r-- 1 4294967294 4294967294 372982 Sep 19 18:08 libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # rpm -Uvh libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm warning: libstdc++6-6.2.1+r239768-5.5.2.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID 3dbdc284: NOKEY Preparing... ################################# [100%] Updating / installing... 1:libstdc++6-6.2.1+r239768-5.5.2 ################################# [ 50%] Cleaning up / removing... 2:libstdc++6-5.3.1+r233831-6.1 ################################# [100%] ````

Project 'Clam' founder

edited Sep 26 '17 at 12:25 am

Install HANA 2.0 procedure

SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ./hdbinst
SAP HANA Database installation kit detected.

######################################################################
Warning: Direct usage of hdbinst is not supported. Use hdblcm instead.
######################################################################



SAP HANA Lifecycle Management - Database Installation 2.00.020.00.1500920972
****************************************************************************



Enter Local Host Name [sharks4hdb]:
Enter Installation Path [/hana/shared]: /hana_1710/shared
Installation directory '/hana_1710/shared' does not exist

Enter Installation Path [/hana/shared]: /hana_1710/shared
Enter SAP HANA System ID: S4H
The defined user 's4hadm' already exists on the system. Neither the password, nor any other attribute of the user will be changed.
Verify that the user is correct.
Enter Instance Number [01]:
Enter Worker Group [default]: sapsys

  Index | System Usage | Description
  -------------------------------------------------------------------------------
  1     | production   | System is used in a production environment
  2     | test         | System is used for testing, not production
  3     | development  | System is used for development, not production
  4     | custom       | System usage is neither production, test nor development

Select System Usage / Enter Index [4]:
Enter Location of Data Volumes [/hana_1710/shared/S4H/global/hdb/data]:
Enter Location of Log Volumes [/hana_1710/shared/S4H/global/hdb/log]:
Restrict maximum memory allocation? [n]:
Enter System Database User (SYSTEM) Password:
System Database User (SYSTEM) Password is invalid
  System Database User (SYSTEM) Password must contain at least 8 characters

Enter System Database User (SYSTEM) Password:
Confirm System Database User (SYSTEM) Password:
Password confirmation failed

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

Enter System Database User (SYSTEM) Password:
Confirm System Database User (SYSTEM) Password:
Restart system after machine reboot? [n]:

Summary before execution:
   Installation Path: /hana_1710/shared
   SAP HANA System ID: S4H
   Instance Number: 01
   Database Isolation: low
   System Usage: custom
   System Administrator Home Directory: /usr/sap/S4H/home
   System Administrator Login Shell: /bin/sh
   System Administrator User ID: 1000
   ID of User Group (sapsys): 1001
   Location of Data Volumes: /hana_1710/shared/S4H/global/hdb/data
   Location of Log Volumes: /hana_1710/shared/S4H/global/hdb/log
   Local Host Name: sharks4hdb
   Worker Group: sapsys


Note: The defined user 's4hadm' already exists on the system. Neither the password, nor any other attribute of the user will be changed.
Verify that the user is correct.
Do you want to continue? (y/n): y
Checking installation...
Preparing package 'Saphostagent Setup'...
Preparing package 'Python Support'...
Preparing package 'Python Runtime'...
Preparing package 'Product Manifest'...
Preparing package 'Binaries'...
Preparing package 'Data Quality'...
Preparing package 'Krb5 Runtime'...
Preparing package 'Installer'...
Preparing package 'Ini Files'...
Preparing package 'HWCCT'...
Preparing package 'Documentation'...
Preparing package 'Delivery Units'...
Preparing package 'Offline Cockpit'...
Preparing package 'DAT Languages (EN, DE)'...
Preparing package 'DAT Languages (other)'...
Preparing package 'DAT Configfiles (EN, DE)'...
Preparing package 'DAT Configfiles (other)'...
Creating System...
Extracting software...
Installing package 'Saphostagent Setup'...
Installing package 'Python Support'...
Installing package 'Python Runtime'...
Installing package 'Product Manifest'...
Installing package 'Binaries'...
Installing package 'Data Quality'...
Installing package 'Krb5 Runtime'...
Installing package 'Installer'...
Installing package 'Ini Files'...
Installing package 'HWCCT'...
Installing package 'Documentation'...
Installing package 'Delivery Units'...
Installing package 'Offline Cockpit'...
Installing package 'DAT Languages (EN, DE)'...
Installing package 'DAT Languages (other)'...
Installing package 'DAT Configfiles (EN, DE)'...
Installing package 'DAT Configfiles (other)'...
Creating instance...
  hdbnsutil: creating persistence ...
  hdbnsutil: writing initial topology...
  hdbnsutil: writing initial license: status check = 2
Starting SAP HANA Database system...
Starting 4 processes on host 'sharks4hdb' (worker):
    Starting on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbnameserver, hdbpreprocessor
Starting 7 processes on host 'sharks4hdb' (worker):
    Starting on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine
    Starting on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine
    Starting on 'SharkS4HDB': hdbdaemon, hdbindexserver, hdbwebdispatcher, hdbxsengine
    Starting on 'SharkS4HDB': hdbdaemon, hdbwebdispatcher, hdbxsengine
    Starting on 'SharkS4HDB': hdbdaemon, hdbwebdispatcher
  All server processes started on host 'sharks4hdb' (worker).
Importing delivery units...
Importing delivery unit HCO_INA_SERVICE
Importing delivery unit HANA_DT_BASE
Importing delivery unit HANA_IDE_CORE
Importing delivery unit HANA_TA_CONFIG
Importing delivery unit HANA_UI_INTEGRATION_SVC
Importing delivery unit HANA_UI_INTEGRATION_CONTENT
Importing delivery unit HANA_XS_BASE
Importing delivery unit HANA_XS_DBUTILS
Importing delivery unit HANA_XS_EDITOR
Importing delivery unit HANA_XS_IDE
Importing delivery unit HANA_XS_LM
Importing delivery unit HDC_ADMIN
Importing delivery unit HDC_BACKUP
Importing delivery unit HDC_IDE_CORE
Importing delivery unit HDC_SEC_CP
Importing delivery unit HDC_SYS_ADMIN
Importing delivery unit HDC_XS_BASE
Importing delivery unit HDC_XS_LM
Importing delivery unit SAPUI5_1
Importing delivery unit SAP_WATT
Importing delivery unit HANA_SEC_CP
Importing delivery unit HANA_BACKUP
Importing delivery unit HANA_HDBLCM
Importing delivery unit HANA_SEC_BASE
Importing delivery unit HANA_SYS_ADMIN
Importing delivery unit HANA_ADMIN
Importing delivery unit HANA_WKLD_ANLZ
Installation done
Log file written to '/var/tmp/hdb_S4H_install_2017-09-19_18.10.42/hdbinst.log' on host 'SharkS4HDB'.
SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 #
Install HANA 2.0 procedure ------------------ ```` SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ./hdbinst SAP HANA Database installation kit detected. ###################################################################### Warning: Direct usage of hdbinst is not supported. Use hdblcm instead. ###################################################################### SAP HANA Lifecycle Management - Database Installation 2.00.020.00.1500920972 **************************************************************************** Enter Local Host Name [sharks4hdb]: Enter Installation Path [/hana/shared]: /hana_1710/shared Installation directory '/hana_1710/shared' does not exist Enter Installation Path [/hana/shared]: /hana_1710/shared Enter SAP HANA System ID: S4H The defined user 's4hadm' already exists on the system. Neither the password, nor any other attribute of the user will be changed. Verify that the user is correct. Enter Instance Number [01]: Enter Worker Group [default]: sapsys Index | System Usage | Description ------------------------------------------------------------------------------- 1 | production | System is used in a production environment 2 | test | System is used for testing, not production 3 | development | System is used for development, not production 4 | custom | System usage is neither production, test nor development Select System Usage / Enter Index [4]: Enter Location of Data Volumes [/hana_1710/shared/S4H/global/hdb/data]: Enter Location of Log Volumes [/hana_1710/shared/S4H/global/hdb/log]: Restrict maximum memory allocation? [n]: Enter System Database User (SYSTEM) Password: System Database User (SYSTEM) Password is invalid System Database User (SYSTEM) Password must contain at least 8 characters Enter System Database User (SYSTEM) Password: Confirm System Database User (SYSTEM) Password: Password confirmation failed Enter System Database User (SYSTEM) Password: System Database User (SYSTEM) Password is invalid System Database User (SYSTEM) Password must contain at least one upper-case character Enter System Database User (SYSTEM) Password: Confirm System Database User (SYSTEM) Password: Restart system after machine reboot? [n]: Summary before execution: Installation Path: /hana_1710/shared SAP HANA System ID: S4H Instance Number: 01 Database Isolation: low System Usage: custom System Administrator Home Directory: /usr/sap/S4H/home System Administrator Login Shell: /bin/sh System Administrator User ID: 1000 ID of User Group (sapsys): 1001 Location of Data Volumes: /hana_1710/shared/S4H/global/hdb/data Location of Log Volumes: /hana_1710/shared/S4H/global/hdb/log Local Host Name: sharks4hdb Worker Group: sapsys Note: The defined user 's4hadm' already exists on the system. Neither the password, nor any other attribute of the user will be changed. Verify that the user is correct. Do you want to continue? (y/n): y Checking installation... Preparing package 'Saphostagent Setup'... Preparing package 'Python Support'... Preparing package 'Python Runtime'... Preparing package 'Product Manifest'... Preparing package 'Binaries'... Preparing package 'Data Quality'... Preparing package 'Krb5 Runtime'... Preparing package 'Installer'... Preparing package 'Ini Files'... Preparing package 'HWCCT'... Preparing package 'Documentation'... Preparing package 'Delivery Units'... Preparing package 'Offline Cockpit'... Preparing package 'DAT Languages (EN, DE)'... Preparing package 'DAT Languages (other)'... Preparing package 'DAT Configfiles (EN, DE)'... Preparing package 'DAT Configfiles (other)'... Creating System... Extracting software... Installing package 'Saphostagent Setup'... Installing package 'Python Support'... Installing package 'Python Runtime'... Installing package 'Product Manifest'... Installing package 'Binaries'... Installing package 'Data Quality'... Installing package 'Krb5 Runtime'... Installing package 'Installer'... Installing package 'Ini Files'... Installing package 'HWCCT'... Installing package 'Documentation'... Installing package 'Delivery Units'... Installing package 'Offline Cockpit'... Installing package 'DAT Languages (EN, DE)'... Installing package 'DAT Languages (other)'... Installing package 'DAT Configfiles (EN, DE)'... Installing package 'DAT Configfiles (other)'... Creating instance... hdbnsutil: creating persistence ... hdbnsutil: writing initial topology... hdbnsutil: writing initial license: status check = 2 Starting SAP HANA Database system... Starting 4 processes on host 'sharks4hdb' (worker): Starting on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbnameserver, hdbpreprocessor Starting 7 processes on host 'sharks4hdb' (worker): Starting on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine Starting on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine Starting on 'SharkS4HDB': hdbdaemon, hdbindexserver, hdbwebdispatcher, hdbxsengine Starting on 'SharkS4HDB': hdbdaemon, hdbwebdispatcher, hdbxsengine Starting on 'SharkS4HDB': hdbdaemon, hdbwebdispatcher All server processes started on host 'sharks4hdb' (worker). Importing delivery units... Importing delivery unit HCO_INA_SERVICE Importing delivery unit HANA_DT_BASE Importing delivery unit HANA_IDE_CORE Importing delivery unit HANA_TA_CONFIG Importing delivery unit HANA_UI_INTEGRATION_SVC Importing delivery unit HANA_UI_INTEGRATION_CONTENT Importing delivery unit HANA_XS_BASE Importing delivery unit HANA_XS_DBUTILS Importing delivery unit HANA_XS_EDITOR Importing delivery unit HANA_XS_IDE Importing delivery unit HANA_XS_LM Importing delivery unit HDC_ADMIN Importing delivery unit HDC_BACKUP Importing delivery unit HDC_IDE_CORE Importing delivery unit HDC_SEC_CP Importing delivery unit HDC_SYS_ADMIN Importing delivery unit HDC_XS_BASE Importing delivery unit HDC_XS_LM Importing delivery unit SAPUI5_1 Importing delivery unit SAP_WATT Importing delivery unit HANA_SEC_CP Importing delivery unit HANA_BACKUP Importing delivery unit HANA_HDBLCM Importing delivery unit HANA_SEC_BASE Importing delivery unit HANA_SYS_ADMIN Importing delivery unit HANA_ADMIN Importing delivery unit HANA_WKLD_ANLZ Installation done Log file written to '/var/tmp/hdb_S4H_install_2017-09-19_18.10.42/hdbinst.log' on host 'SharkS4HDB'. SharkS4HDB:/mnt/share/SAP_INSTALL/S4_1709/51052325/DATA_UNITS/HDB_SERVER_LINUX_X86_64 # ````

Project 'Clam' founder

Install DB instance using SWPM

SharkS4HDB:/tmp/SWPM # ./sapinst
[==============================] / extracting...  done!

SAPinst build information:
--------------------------
Version:         749.0.37
Build:           1787123
Compile time:    Sep 08 2017 - 13:22:10
Make type:       optU
Codeline:        749_REL
Platform:        linuxx86_64
Kernel build:    749, patch 315, changelist 1785839
SAP JRE build:   SAP Java Server VM (build 8.1.032 25.51-b02, Jul 27 2017 16:40:00 - 81_REL - optU - linux amd64 - 6 - bas2:292506 (mixed mode))
SAP JCo build:   3.0.17
SL-UI version:   2.6.10
SAP UI5 version: 1.48.1
Exe directory: /tmp/sapinst_exe.15994.1505846631

INFO       2017-09-19 18:43:58.868 (shark/sapinst) (SLPCommunicator) [/bas/749_REL/bc_749_REL/src/ins/SAPINST/impl/src/guiengine/SLPMonitoringStatemachine.cpp:1377]
********************************************************************************
Open your browser and paste the following URL address to access the GUI
https://SharkS4HDB.fandezhi.com:4237/sapinst/docs/index.html
Logon users: [root, shark]
********************************************************************************

load resource pool /tmp/SWPM/resourcepool.xml
Install DB instance using SWPM ------------------ ```` SharkS4HDB:/tmp/SWPM # ./sapinst [==============================] / extracting... done! SAPinst build information: -------------------------- Version: 749.0.37 Build: 1787123 Compile time: Sep 08 2017 - 13:22:10 Make type: optU Codeline: 749_REL Platform: linuxx86_64 Kernel build: 749, patch 315, changelist 1785839 SAP JRE build: SAP Java Server VM (build 8.1.032 25.51-b02, Jul 27 2017 16:40:00 - 81_REL - optU - linux amd64 - 6 - bas2:292506 (mixed mode)) SAP JCo build: 3.0.17 SL-UI version: 2.6.10 SAP UI5 version: 1.48.1 Exe directory: /tmp/sapinst_exe.15994.1505846631 INFO 2017-09-19 18:43:58.868 (shark/sapinst) (SLPCommunicator) [/bas/749_REL/bc_749_REL/src/ins/SAPINST/impl/src/guiengine/SLPMonitoringStatemachine.cpp:1377] ******************************************************************************** Open your browser and paste the following URL address to access the GUI https://SharkS4HDB.fandezhi.com:4237/sapinst/docs/index.html Logon users: [root, shark] ******************************************************************************** load resource pool /tmp/SWPM/resourcepool.xml ````

Project 'Clam' founder

59c165e60ae9f.jpg

59c170dc5c046.jpg
59c170d5672b9.jpg

![59c165e60ae9f.jpg](serve/attachment&path=59c165e60ae9f.jpg) ![59c170dc5c046.jpg](serve/attachment&path=59c170dc5c046.jpg) ![59c170d5672b9.jpg](serve/attachment&path=59c170d5672b9.jpg)

Project 'Clam' founder

We've done a test, using the hdbuserstore to tweak around

Before change it was

SharkS4HDB:s4aadm 56> hdbuserstore LIST
DATA FILE       : /home/s4aadm/.hdb/SharkS4HDB/SSFS_HDB.DAT
KEY FILE        : /home/s4aadm/.hdb/SharkS4HDB/SSFS_HDB.KEY

59c19f819874a.jpg

After above step, it becomes

SharkS4HDB:s4aadm 56> hdbuserstore LIST
DATA FILE       : /home/s4aadm/.hdb/SharkS4HDB/SSFS_HDB.DAT
KEY FILE        : /home/s4aadm/.hdb/SharkS4HDB/SSFS_HDB.KEY

KEY DEFAULT
  ENV : SharkS4HDB.fandezhi.com:30115
  USER: SAPABAP1

Before the import starts, we hack the connection string

hdbuserstore -i set DEFAULT SharkS4HDB:30115 system passwordxxx to see how the import goes

it ends up with importing all those thousands of tables into the SYSTEM CATALOG!

### We've done a test, using the hdbuserstore to tweak around Before change it was ```` SharkS4HDB:s4aadm 56> hdbuserstore LIST DATA FILE : /home/s4aadm/.hdb/SharkS4HDB/SSFS_HDB.DAT KEY FILE : /home/s4aadm/.hdb/SharkS4HDB/SSFS_HDB.KEY ```` ![59c19f819874a.jpg](serve/attachment&path=59c19f819874a.jpg) After above step, it becomes ```` SharkS4HDB:s4aadm 56> hdbuserstore LIST DATA FILE : /home/s4aadm/.hdb/SharkS4HDB/SSFS_HDB.DAT KEY FILE : /home/s4aadm/.hdb/SharkS4HDB/SSFS_HDB.KEY KEY DEFAULT ENV : SharkS4HDB.fandezhi.com:30115 USER: SAPABAP1 ```` Before the import starts, we hack the connection string ```` hdbuserstore -i set DEFAULT SharkS4HDB:30115 system passwordxxx to see how the import goes ```` ### it ends up with importing all those thousands of tables into the SYSTEM CATALOG!

Project 'Clam' founder

edited Sep 19 '17 at 11:55 pm

By default S/4 1709 installation recommend 24 R3load jobs running, to be able to avoid resource drying up, we reduced it to be 12. Even like this the server was fully loaded

59c1a22809d67.jpg
59c1a22813df8.jpg

By default S/4 1709 installation recommend 24 R3load jobs running, to be able to avoid resource drying up, we reduced it to be 12. Even like this the server was fully loaded ------------------ ![59c1a22809d67.jpg](serve/attachment&path=59c1a22809d67.jpg) ![59c1a22813df8.jpg](serve/attachment&path=59c1a22813df8.jpg)

Project 'Clam' founder

During PAS installation, the LiveCache is selected

59c1c8a889a45.jpg

Install LiveCache

SharkS4HDB:/tmp/LCAPPS/SAP_HANA_LCAPPS # ./hdbinst
SAP liveCache Applications installation kit detected.


SAP HANA Lifecycle Management - SAP LCAPPS Installation 2.00.020.0000.472678
****************************************************************************



Enter SAP HANA System ID: S4H
Checking installation...
Preparing package 'LCAPPS'...
Installing SAP liveCache Applications to /hana_1710/shared/S4H/exe/linuxx86_64/plugins/lcapps_2.00.020.0000.472678_7f63b0aa11dca2ea54d450aa302319302c2eeaca...
Installing package 'LCAPPS'...
Stopping system...
  Stopping 7 processes on host 'sharks4hdb' (worker):
    Stopping on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine
  All server processes stopped on host 'sharks4hdb' (worker).
Activating plugin...
Starting system...
Starting 1 process on host 'sharks4hdb' (worker):
    Starting on 'SharkS4HDB': hdbdaemon
Starting 7 processes on host 'sharks4hdb' (worker):
    Starting on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine
    Starting on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine
    Starting on 'SharkS4HDB': hdbdaemon, hdbindexserver, hdbwebdispatcher, hdbxsengine
    Starting on 'SharkS4HDB': hdbdaemon, hdbwebdispatcher, hdbxsengine
    Starting on 'SharkS4HDB': hdbdaemon, hdbwebdispatcher
  All server processes started on host 'sharks4hdb' (worker).
Installation done
Log file written to '/var/tmp/hdb_lcapps_2017-09-20_01.45.10_29242/hdbinst_lcapps.log' on host 'SharkS4HDB'.
During PAS installation, the LiveCache is selected ------------------ ![59c1c8a889a45.jpg](serve/attachment&path=59c1c8a889a45.jpg) Install LiveCache ------------------ ```` SharkS4HDB:/tmp/LCAPPS/SAP_HANA_LCAPPS # ./hdbinst SAP liveCache Applications installation kit detected. SAP HANA Lifecycle Management - SAP LCAPPS Installation 2.00.020.0000.472678 **************************************************************************** Enter SAP HANA System ID: S4H Checking installation... Preparing package 'LCAPPS'... Installing SAP liveCache Applications to /hana_1710/shared/S4H/exe/linuxx86_64/plugins/lcapps_2.00.020.0000.472678_7f63b0aa11dca2ea54d450aa302319302c2eeaca... Installing package 'LCAPPS'... Stopping system... Stopping 7 processes on host 'sharks4hdb' (worker): Stopping on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine All server processes stopped on host 'sharks4hdb' (worker). Activating plugin... Starting system... Starting 1 process on host 'sharks4hdb' (worker): Starting on 'SharkS4HDB': hdbdaemon Starting 7 processes on host 'sharks4hdb' (worker): Starting on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine Starting on 'SharkS4HDB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine Starting on 'SharkS4HDB': hdbdaemon, hdbindexserver, hdbwebdispatcher, hdbxsengine Starting on 'SharkS4HDB': hdbdaemon, hdbwebdispatcher, hdbxsengine Starting on 'SharkS4HDB': hdbdaemon, hdbwebdispatcher All server processes started on host 'sharks4hdb' (worker). Installation done Log file written to '/var/tmp/hdb_lcapps_2017-09-20_01.45.10_29242/hdbinst_lcapps.log' on host 'SharkS4HDB'. ````

Project 'Clam' founder

During installation of PAS I'll have to kill the RUTDDLSCREATE job since it's running for a long time, and from the WP logs seems a table is missing

59c1d89344773.jpg

SQLERRTEXT : invalid table name:  Could not find table/view V_RFC_BL_SERVER in schema SAPABAP1: line 1 col 21 (at\
C                pos 20)
C  sc_p=7f2259023f28,no=319,idc_p=(nil),con=0,act=0,slen=93,smax=256,#vars=1,stmt=7f1f532cd0b0,table=V_RFC_BL_SERVER
C  SELECT TOP 1 * FROM "V_RFC_BL_SERVER" WHERE "RFM_NAME" = ?  WITH RANGE_RESTRICTION('CURRENT');
B  ***LOG BZA=> table V_RFC_BL_SERVER                does not exist on database R/3 [dbtran       7777]
During installation of PAS I'll have to kill the RUTDDLSCREATE job since it's running for a long time, and from the WP logs seems a table is missing ------------------ ![59c1d89344773.jpg](serve/attachment&path=59c1d89344773.jpg) ```` SQLERRTEXT : invalid table name: Could not find table/view V_RFC_BL_SERVER in schema SAPABAP1: line 1 col 21 (at\ C pos 20) C sc_p=7f2259023f28,no=319,idc_p=(nil),con=0,act=0,slen=93,smax=256,#vars=1,stmt=7f1f532cd0b0,table=V_RFC_BL_SERVER C SELECT TOP 1 * FROM "V_RFC_BL_SERVER" WHERE "RFM_NAME" = ? WITH RANGE_RESTRICTION('CURRENT'); B ***LOG BZA=> table V_RFC_BL_SERVER does not exist on database R/3 [dbtran 7777] ````

Project 'Clam' founder

All completed

59c1d8fd432a1.jpg

All completed ------------------ ![59c1d8fd432a1.jpg](serve/attachment&path=59c1d8fd432a1.jpg)

Project 'Clam' founder

After the installation we have run the RUTDDLSCREATE manually which eliminated those table missing errors

After the installation we have run the RUTDDLSCREATE manually which eliminated those table missing errors ------------------

Project 'Clam' founder

1.58k
views
9
replies
0
followers
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft