[root@HANADB PATCH_SPS12]# ls -ltr
total 3228656
-rwx------. 1 4294967294 4294967294      10908 Apr 18 14:32 hdblcm_prepare.sh
-rwx------. 1 4294967294 4294967294 3085053320 May 26 22:39 IMDB_SERVER100_120_0-10009569.SAR
-rwx------. 1 4294967294 4294967294   29210413 May 26 22:40 IMDB_TRDAFL100_120_0-80000414.SAR
-rwx------. 1 4294967294 4294967294  191864470 May 26 23:01 IMDB_AFL100_120_0-10012328.SAR
[root@HANADB PATCH_SPS12]# ./hdblcm_prepare.sh

SAP HANA Lifecycle Management
*****************************

Extracting archive /HANA/PATCH_SPS12/IMDB_AFL100_120_0-10012328.SAR...
Extracting archive /HANA/PATCH_SPS12/IMDB_SERVER100_120_0-10009569.SAR...
Extracting archive /HANA/PATCH_SPS12/IMDB_TRDAFL100_120_0-80000414.SAR...


To update the SAP HANA system using hdblcm(gui), use the following lines:
Command Line Interface: '/HANA/PATCH_SPS12/extracted/SAP_HANA_DATABASE/hdblcm' --component_root '/HANA/PATCH_SPS12/extracted'
Graphical User Interface: '/HANA/PATCH_SPS12/extracted/SAP_HANA_DATABASE/hdblcmgui' --component_root '/HANA/PATCH_SPS12/extracted'


Done
Log file: /HANA/PATCH_SPS12/extracted/extract1464430192.log
[root@HANADB PATCH_SPS12]# ls
extracted  hdblcm_prepare.sh  IMDB_AFL100_120_0-10012328.SAR  IMDB_SERVER100_120_0-10009569.SAR  IMDB_TRDAFL100_120_0-80000414.SAR
[root@HANADB PATCH_SPS12]# cd extracted
[root@HANADB extracted]# ls
extract1464430192.log  SAP_HANA_AFL  SAP_HANA_DATABASE  SAP_TRD_AFL_FOR_HANA
[root@HANADB extracted]# cd *SE
[root@HANADB SAP_HANA_DATABASE]# ls
adapters.d     filelist.hdbinst_remote_check  filelist.install   hdbinst  hdblcmgui  hdbsetup   hdbupd       operations.d  server
descriptors.d  filelist.hdblcm_remote_check   filelist.resident  hdblcm   hdblcmweb  hdbuninst  instruntime  resources     SIGNATURE.SMF
[root@HANADB SAP_HANA_DATABASE]# ./hdblcm


SAP HANA Lifecycle Management - SAP HANA 1.00.120.00.1462275491
***************************************************************


Scanning Software Locations...
Detected components:
    SAP HANA Database (1.00.120.00.1462275491) in /HANA/PATCH_SPS12/extracted/SAP_HANA_DATABASE/server
    SAP HANA AFL (incl.PAL,BFL,OFL,HIE) (1.00.120.00.1462291682) in /HANA/PATCH_SPS12/extracted/SAP_HANA_AFL/packages
    SAP TRD AFL FOR HANA (1.00.120.00.1462291682) in /HANA/PATCH_SPS12/extracted/SAP_TRD_AFL_FOR_HANA/packages



Choose system to update, or choose installation

  Index | System             | Database Properties
  --------------------------------------------------------------
  1     | HDB (update)       | 1.00.112.02.1459851171
        |                    | hanadb (Database Worker (worker))
        |                    |
  2     | Install new system |
        |                    |
  3     | Extract components |
  4     | Exit (do nothing)  |

Enter selected system index [4]: 1


Choose components to be installed or updated:

  Index | Components | Description
  -------------------------------------------------------------------------------------------------------------------
  1     | all        | All components
  2     | server     | Update SAP HANA Database from version 1.00.112.02.1459851171 to version 1.00.120.00.1462275491
  3     | afl        | Install SAP HANA AFL (incl.PAL,BFL,OFL,HIE) version 1.00.120.00.1462291682
  4     | trd        | Install SAP TRD AFL FOR HANA version 1.00.120.00.1462291682

Enter comma-separated list of the selected indices [2]: 2
Enter System Administrator (hdbadm) Password:
Enter Database User Name [SYSTEM]:
Enter Database User (SYSTEM) Password:

Summary before execution:
=========================

SAP HANA Components
   Update Parameters
      SAP HANA System ID: HDB
      Remote Execution: ssh
      Update Execution Mode: standard
      Database User Name: SYSTEM
   Software Components
      SAP HANA AFL (incl.PAL,BFL,OFL,HIE)
         Do not install
      SAP TRD AFL FOR HANA
         Do not install
      SAP HANA Database
         Update from version 1.00.112.02.1459851171 to 1.00.120.00.1462275491
         Location: /HANA/PATCH_SPS12/extracted/SAP_HANA_DATABASE/server

Note: Cannot verify database user (SYSTEM) password in advance: no connection available.
Note: Cannot perform license check: no connection available

Do you want to continue? (y/n): y

Updating components...
Updating SAP HANA Database...
  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 'Emergency Support Package'...
  Preparing package 'EPM'...
  Preparing package 'Documentation'...
  Preparing package 'Delivery Units'...
  Preparing package 'DAT Languages'...
  Preparing package 'DAT Configfiles'...
  Extracting software...
  Updating package 'Saphostagent Setup'...
  Updating package 'Python Support'...
  Updating package 'Python Runtime'...
  Updating package 'Product Manifest'...
  Updating package 'Binaries'...
  Installing package 'Data Quality'...
  Installing package 'Krb5 Runtime'...
  Updating package 'Installer'...
  Updating package 'Ini Files'...
  Updating package 'HWCCT'...
  Updating package 'Emergency Support Package'...
  Updating package 'EPM'...
  Updating package 'Documentation'...
  Updating package 'Delivery Units'...
  Updating package 'DAT Languages'...
  Updating package 'DAT Configfiles'...
  Starting service (sapstartsrv)...
  Starting system...
  Starting 1 process on host 'hanadb' (worker):
      Starting on 'HANADB': hdbdaemon
  Starting 7 processes on host 'hanadb' (worker):
      Starting on 'HANADB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine
      Starting on 'HANADB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine
      Starting on 'HANADB': hdbdaemon, hdbindexserver, hdbwebdispatcher, hdbxsengine
      Starting on 'HANADB': hdbdaemon, hdbwebdispatcher, hdbxsengine
      Starting on 'HANADB': hdbdaemon, hdbwebdispatcher
    All server processes started on host 'hanadb' (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_XS_BASE
  Importing delivery unit HANA_XS_DBUTILS
  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_XS_BASE
  Importing delivery unit HDC_XS_LM
  Importing delivery unit HANA_BACKUP
  Importing delivery unit HANA_HDBLCM
  Importing delivery unit HANA_SEC_BASE
  Importing delivery unit HANA_SEC_CP
  Importing delivery unit HANA_ADMIN
  Importing delivery unit HANA_WKLD_ANLZ
Updating Resident hdblcm...
  Cleaning up old installation of Resident hdblcm...
  Installing Resident hdblcm...
Updating SAP HANA Instance Integration on Local Host...
  Deploying SAP Host Agent configurations...
Updating Component List...
SAP HANA components updated
You can send feedback to SAP with this form: https://hanadb, OU=Dezhi_Systems, C=DE:1129/lmsl/HDBLCM/HDB/feedback/feedback.html
Log file written to '/var/tmp/hdb_HDB_hdblcm_update_2016-05-28_06.11.17/hdblcm.log' on host 'HANADB'.
[root@HANADB SAP_HANA_DATABASE]#
```` [root@HANADB PATCH_SPS12]# ls -ltr total 3228656 -rwx------. 1 4294967294 4294967294 10908 Apr 18 14:32 hdblcm_prepare.sh -rwx------. 1 4294967294 4294967294 3085053320 May 26 22:39 IMDB_SERVER100_120_0-10009569.SAR -rwx------. 1 4294967294 4294967294 29210413 May 26 22:40 IMDB_TRDAFL100_120_0-80000414.SAR -rwx------. 1 4294967294 4294967294 191864470 May 26 23:01 IMDB_AFL100_120_0-10012328.SAR [root@HANADB PATCH_SPS12]# ./hdblcm_prepare.sh SAP HANA Lifecycle Management ***************************** Extracting archive /HANA/PATCH_SPS12/IMDB_AFL100_120_0-10012328.SAR... Extracting archive /HANA/PATCH_SPS12/IMDB_SERVER100_120_0-10009569.SAR... Extracting archive /HANA/PATCH_SPS12/IMDB_TRDAFL100_120_0-80000414.SAR... To update the SAP HANA system using hdblcm(gui), use the following lines: Command Line Interface: '/HANA/PATCH_SPS12/extracted/SAP_HANA_DATABASE/hdblcm' --component_root '/HANA/PATCH_SPS12/extracted' Graphical User Interface: '/HANA/PATCH_SPS12/extracted/SAP_HANA_DATABASE/hdblcmgui' --component_root '/HANA/PATCH_SPS12/extracted' Done Log file: /HANA/PATCH_SPS12/extracted/extract1464430192.log [root@HANADB PATCH_SPS12]# ls extracted hdblcm_prepare.sh IMDB_AFL100_120_0-10012328.SAR IMDB_SERVER100_120_0-10009569.SAR IMDB_TRDAFL100_120_0-80000414.SAR [root@HANADB PATCH_SPS12]# cd extracted [root@HANADB extracted]# ls extract1464430192.log SAP_HANA_AFL SAP_HANA_DATABASE SAP_TRD_AFL_FOR_HANA [root@HANADB extracted]# cd *SE [root@HANADB SAP_HANA_DATABASE]# ls adapters.d filelist.hdbinst_remote_check filelist.install hdbinst hdblcmgui hdbsetup hdbupd operations.d server descriptors.d filelist.hdblcm_remote_check filelist.resident hdblcm hdblcmweb hdbuninst instruntime resources SIGNATURE.SMF [root@HANADB SAP_HANA_DATABASE]# ./hdblcm SAP HANA Lifecycle Management - SAP HANA 1.00.120.00.1462275491 *************************************************************** Scanning Software Locations... Detected components: SAP HANA Database (1.00.120.00.1462275491) in /HANA/PATCH_SPS12/extracted/SAP_HANA_DATABASE/server SAP HANA AFL (incl.PAL,BFL,OFL,HIE) (1.00.120.00.1462291682) in /HANA/PATCH_SPS12/extracted/SAP_HANA_AFL/packages SAP TRD AFL FOR HANA (1.00.120.00.1462291682) in /HANA/PATCH_SPS12/extracted/SAP_TRD_AFL_FOR_HANA/packages Choose system to update, or choose installation Index | System | Database Properties -------------------------------------------------------------- 1 | HDB (update) | 1.00.112.02.1459851171 | | hanadb (Database Worker (worker)) | | 2 | Install new system | | | 3 | Extract components | 4 | Exit (do nothing) | Enter selected system index [4]: 1 Choose components to be installed or updated: Index | Components | Description ------------------------------------------------------------------------------------------------------------------- 1 | all | All components 2 | server | Update SAP HANA Database from version 1.00.112.02.1459851171 to version 1.00.120.00.1462275491 3 | afl | Install SAP HANA AFL (incl.PAL,BFL,OFL,HIE) version 1.00.120.00.1462291682 4 | trd | Install SAP TRD AFL FOR HANA version 1.00.120.00.1462291682 Enter comma-separated list of the selected indices [2]: 2 Enter System Administrator (hdbadm) Password: Enter Database User Name [SYSTEM]: Enter Database User (SYSTEM) Password: Summary before execution: ========================= SAP HANA Components Update Parameters SAP HANA System ID: HDB Remote Execution: ssh Update Execution Mode: standard Database User Name: SYSTEM Software Components SAP HANA AFL (incl.PAL,BFL,OFL,HIE) Do not install SAP TRD AFL FOR HANA Do not install SAP HANA Database Update from version 1.00.112.02.1459851171 to 1.00.120.00.1462275491 Location: /HANA/PATCH_SPS12/extracted/SAP_HANA_DATABASE/server Note: Cannot verify database user (SYSTEM) password in advance: no connection available. Note: Cannot perform license check: no connection available Do you want to continue? (y/n): y Updating components... Updating SAP HANA Database... 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 'Emergency Support Package'... Preparing package 'EPM'... Preparing package 'Documentation'... Preparing package 'Delivery Units'... Preparing package 'DAT Languages'... Preparing package 'DAT Configfiles'... Extracting software... Updating package 'Saphostagent Setup'... Updating package 'Python Support'... Updating package 'Python Runtime'... Updating package 'Product Manifest'... Updating package 'Binaries'... Installing package 'Data Quality'... Installing package 'Krb5 Runtime'... Updating package 'Installer'... Updating package 'Ini Files'... Updating package 'HWCCT'... Updating package 'Emergency Support Package'... Updating package 'EPM'... Updating package 'Documentation'... Updating package 'Delivery Units'... Updating package 'DAT Languages'... Updating package 'DAT Configfiles'... Starting service (sapstartsrv)... Starting system... Starting 1 process on host 'hanadb' (worker): Starting on 'HANADB': hdbdaemon Starting 7 processes on host 'hanadb' (worker): Starting on 'HANADB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbnameserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine Starting on 'HANADB': hdbcompileserver, hdbdaemon, hdbindexserver, hdbpreprocessor, hdbwebdispatcher, hdbxsengine Starting on 'HANADB': hdbdaemon, hdbindexserver, hdbwebdispatcher, hdbxsengine Starting on 'HANADB': hdbdaemon, hdbwebdispatcher, hdbxsengine Starting on 'HANADB': hdbdaemon, hdbwebdispatcher All server processes started on host 'hanadb' (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_XS_BASE Importing delivery unit HANA_XS_DBUTILS 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_XS_BASE Importing delivery unit HDC_XS_LM Importing delivery unit HANA_BACKUP Importing delivery unit HANA_HDBLCM Importing delivery unit HANA_SEC_BASE Importing delivery unit HANA_SEC_CP Importing delivery unit HANA_ADMIN Importing delivery unit HANA_WKLD_ANLZ Updating Resident hdblcm... Cleaning up old installation of Resident hdblcm... Installing Resident hdblcm... Updating SAP HANA Instance Integration on Local Host... Deploying SAP Host Agent configurations... Updating Component List... SAP HANA components updated You can send feedback to SAP with this form: https://hanadb, OU=Dezhi_Systems, C=DE:1129/lmsl/HDBLCM/HDB/feedback/feedback.html Log file written to '/var/tmp/hdb_HDB_hdblcm_update_2016-05-28_06.11.17/hdblcm.log' on host 'HANADB'. [root@HANADB SAP_HANA_DATABASE]# ````

Project 'Clam' founder

notice when logged with hdbadm, it has warnings

ERROR: ld.so: object '/opt/rh/SAP/lib64/compat-sap-c++.so' from LD_PRELOAD cannot be preloaded: ignored.

So we'll have to download / install compat-sap-c++

[root@HANADB ~]# rpm -ivh *c++*.rpm
warning: compat-sap-c++-4.8.2-16.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY
error: Failed dependencies:
        glibc-devel >= 2.2.90-12 is needed by compat-sap-c++-4.8.2-16.el6.x86_64
[root@HANADB ~]# cd /cdrom/Packages
[root@HANADB Packages]# ls -l *glibc-devel*
-r--r--r--. 82 root root 1094276 Jan 26  2015 glibc-devel-2.17-78.el7.i686.rpm
-r--r--r--. 82 root root 1093412 Jan 26  2015 glibc-devel-2.17-78.el7.x86_64.rpm
[root@HANADB Packages]# rpm -ivh glibc-devel-2.17-78.el7.x86_64.rpm
warning: glibc-devel-2.17-78.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY
error: Failed dependencies:
        glibc-headers is needed by glibc-devel-2.17-78.el7.x86_64
        glibc-headers = 2.17-78.el7 is needed by glibc-devel-2.17-78.el7.x86_64
[root@HANADB Packages]# rpm -ivh glibc-headers*.rpm
warning: glibc-headers-2.17-78.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY
error: Failed dependencies:
        kernel-headers is needed by glibc-headers-2.17-78.el7.x86_64
        kernel-headers >= 2.2.1 is needed by glibc-headers-2.17-78.el7.x86_64
[root@HANADB Packages]# rpm -ivh kernel-headers*.rpm
warning: kernel-headers-3.10.0-229.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:kernel-headers-3.10.0-229.el7    ################################# [100%]
[root@HANADB Packages]# rpm -ivh glibc-headers*.rpm
warning: glibc-headers-2.17-78.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:glibc-headers-2.17-78.el7        ################################# [100%]
[root@HANADB Packages]# rpm -ivh glibc-devel-2.17-78.el7.x86_64.rpm
warning: glibc-devel-2.17-78.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:glibc-devel-2.17-78.el7          ################################# [100%]
[root@HANADB Packages]# rpm -ivh *c++*.rpm^C
[root@HANADB Packages]# cd
[root@HANADB ~]# rpm -ivh *c++*.rpm
warning: compat-sap-c++-4.8.2-16.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:compat-sap-c++-4.8.2-16.el6      ################################# [100%]
[root@HANADB ~]# su - hdbadm
Last login: Sat May 28 06:16:55 EDT 2016 from vcenter on pts/2
hdbadm@HANADB:/usr/sap/HDB/HDB00>
hdbadm@HANADB:/usr/sap/HDB/HDB00>
hdbadm@HANADB:/usr/sap/HDB/HDB00> exit
logout
[root@HANADB ~]#

No more warnings.

notice when logged with hdbadm, it has warnings ```` ERROR: ld.so: object '/opt/rh/SAP/lib64/compat-sap-c++.so' from LD_PRELOAD cannot be preloaded: ignored. ```` So we'll have to download / install compat-sap-c++ ```` [root@HANADB ~]# rpm -ivh *c++*.rpm warning: compat-sap-c++-4.8.2-16.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY error: Failed dependencies: glibc-devel >= 2.2.90-12 is needed by compat-sap-c++-4.8.2-16.el6.x86_64 [root@HANADB ~]# cd /cdrom/Packages [root@HANADB Packages]# ls -l *glibc-devel* -r--r--r--. 82 root root 1094276 Jan 26 2015 glibc-devel-2.17-78.el7.i686.rpm -r--r--r--. 82 root root 1093412 Jan 26 2015 glibc-devel-2.17-78.el7.x86_64.rpm [root@HANADB Packages]# rpm -ivh glibc-devel-2.17-78.el7.x86_64.rpm warning: glibc-devel-2.17-78.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY error: Failed dependencies: glibc-headers is needed by glibc-devel-2.17-78.el7.x86_64 glibc-headers = 2.17-78.el7 is needed by glibc-devel-2.17-78.el7.x86_64 [root@HANADB Packages]# rpm -ivh glibc-headers*.rpm warning: glibc-headers-2.17-78.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY error: Failed dependencies: kernel-headers is needed by glibc-headers-2.17-78.el7.x86_64 kernel-headers >= 2.2.1 is needed by glibc-headers-2.17-78.el7.x86_64 [root@HANADB Packages]# rpm -ivh kernel-headers*.rpm warning: kernel-headers-3.10.0-229.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY Preparing... ################################# [100%] Updating / installing... 1:kernel-headers-3.10.0-229.el7 ################################# [100%] [root@HANADB Packages]# rpm -ivh glibc-headers*.rpm warning: glibc-headers-2.17-78.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY Preparing... ################################# [100%] Updating / installing... 1:glibc-headers-2.17-78.el7 ################################# [100%] [root@HANADB Packages]# rpm -ivh glibc-devel-2.17-78.el7.x86_64.rpm warning: glibc-devel-2.17-78.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY Preparing... ################################# [100%] Updating / installing... 1:glibc-devel-2.17-78.el7 ################################# [100%] [root@HANADB Packages]# rpm -ivh *c++*.rpm^C [root@HANADB Packages]# cd [root@HANADB ~]# rpm -ivh *c++*.rpm warning: compat-sap-c++-4.8.2-16.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY Preparing... ################################# [100%] Updating / installing... 1:compat-sap-c++-4.8.2-16.el6 ################################# [100%] [root@HANADB ~]# su - hdbadm Last login: Sat May 28 06:16:55 EDT 2016 from vcenter on pts/2 hdbadm@HANADB:/usr/sap/HDB/HDB00> hdbadm@HANADB:/usr/sap/HDB/HDB00> hdbadm@HANADB:/usr/sap/HDB/HDB00> exit logout [root@HANADB ~]# ```` No more warnings.

Project 'Clam' founder

57497401abd3d.jpg

HANA is on SPS12 now

![57497401abd3d.jpg](serve/attachment&path=57497401abd3d.jpg) HANA is on SPS12 now

Project 'Clam' founder

1.28k
views
2
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 ?
Cancel
Delete
Pending draft ... Click to resume editing
Discard draft