Our current HANA Platform Edition 2.0 database version is at SPS02 rev20 and we want to update the revision to SPS02 rev24. We will be using the HDBLCM command line interface for this revision update activity.
Prerequisites
- Read and refer to the SAP Help Guide.
- Download the media files. Copy and extract the downloaded files into your specific location on your server.
- Perform a system backup before executing the update.
- Ensure you have sidadm and SYSTEM access (SYSTEMDB and TENANTDB).
- Obtain the installed HANA components and current version HANA database server / client.
SAP HANA Database Client
1. Stop the SAP application and HANA database.
2. Change directory where the HDBLCM is extracted. Right click on the hdbuninst and open with Administrator. You are about to uninstall the HANA database client. 🙂
3. You will prompt with the command line interface. Choose 0 to select the installed HANA database client and “y” to proceed with the un-installation. Press Enter once done.
SAP HANA Lifecycle Management - Uninstallation 2.2.27
*****************************************************
Installed SAP HANA installations:
0: SAP HANA Database Client 1.00.112.04.1467296086
E:\usr\sap\DEV\hdbclient
1: None (Abort uninstallation)
Enter SAP HANA installation Id [1]: 0
Do you want to uninstall the following installation?
SAP HANA Database Client 1.00.112.04.1467296086 E:\usr\sap\DEV\hdbclient
Confirm (y/n): y
Uninstalling SAP HANA Database Client...
Uninstalling package Client Installer...
Uninstalling package ADO.NET...
Uninstalling package HALM Client...
Uninstalling package JDBC...
Uninstalling package ODBC...
Uninstalling package Python DB API...
Uninstalling package REPOTOOLS...
Uninstalling package ODBO...
Uninstalling package SQLDBC...
Uninstalling package Product Manifest...
Uninstalling package Python Runtime...
Uninstallation done.
Log file written to 'C:\Users\itsiti\hdb_client_uninstall_2
018-08-13_02.40.46\hdbuninst_client.log' on host 'itsiti'.
press any key...
4. Next, right click on hdbsetup.exe and open with Administrator. This step is to install the HANA database client.
5. Define the path of SAP HANA database client. Click Next.
6. The summary. Click on Install.
7. Finish!
SAP HANA Database Server
1. Change directory to the extracted media location.
cd /SAP_HANA_DATABASE/
ll hdb* hdbinst hdblcm hdblcmgui hdblcmweb hdbsetup hdbuninst hdbupd
2. Launch the HDBLCM. Choose the HANA database required for update.
./hdblcm
SAP HANA Lifecycle Management - SAP HANA Database 2.00.024.04.1530240705
************************************************************************
Scanning software locations...
Detected components:
SAP HANA Database (2.00.024.04.1530240705) in /SAP_HANA_DATABASE/server
Choose an action
Index | Action | Description
--------------------------------------------------------------------
1 | QAS (update) | 2.00.024.02.1525857514
| | aradaem (Database Worker (worker))
| |
2 | DEV (update) | 2.00.020.00.1500920972
| | itsiti (Database Worker (worker))
| |
3 | install | Install new system
4 | extract_components | Extract components
5 | Exit (do nothing) |
Enter selected action index [8]: 2
3. Choose server (2). This will update SAP HANA database server version.
Choose components to be installed or updated: Index | Components | Description ------------------------------------------------------------------------------------------------------------------- 1 | all | All components 2 | server | Update SAP HANA Database from version 2.00.020.00.1500920972 to version 2.00.024.04.1530240705 Enter comma-separated list of the selected indices [1]: 2
4. We are getting below error message. Exit from the HDBLCM command line.
File 'SIGNATURE.SMF' cannot be found in the SAP HANA Database installation kit. You can ignore this error and continue with the execution by passing the ignore option 'check_signature_file' to hdblcm, started as root. See SAP note 2078425, section 'How to prepare SAP HANA packages for installation or update' for instructions how to prepare packages for update or implications of ignoring this error.
5. Extract the media file using SAPCAR with below option.
SAPCAR -xvf IMDB_SERVER20_024_4-80002031.SAR -manifest SIGNATURE.SMF
5. Launch the HDBLCM command again. You will need to provide sidadm and SYSTEM password.
Choose components to be installed or updated: Index | Components | Description ------------------------------------------------------------------------------------------------------------------- 1 | all | All components 2 | server | Update SAP HANA Database from version 2.00.020.00.1500920972 to version 2.00.024.04.1530240705 Enter comma-separated list of the selected indices [1]: 2 Enter System Administrator (devadm) Password: Enter System Database User Name [SYSTEM]: Enter System Database User (SYSTEM) Password: Enter Certificate Host Name For Host 'itsiti' [itsiti]:
6. The summary before execution. Press “y” to continue.
Summary before execution:
=========================
SAP HANA Database
Update Parameters
SAP HANA System ID: DEV
Remote Execution: ssh
Update Execution Mode: standard
System Database User Name: SYSTEM
Certificate Host Names: itsiti -> itsiti
Software Components
SAP HANA Database
Update from version 2.00.020.00.1500920972 to 2.00.024.04.1530240705
Location: /SAP_HANA_DATABASE/server
Do you want to continue? (y/n):
6. The update begins.
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 '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)'... Extracting software... Updating package 'Saphostagent Setup'... Updating package 'Python Support'...
7. The update completed.
Updating SAP HANA Database... Resuming broken upgrade at step 'Importing Content'. Importing delivery units... Importing delivery unit HANA_UI_INTEGRATION_SVC Importing delivery unit HANA_XS_LM Updating Resident hdblcm... Cleaning up old installation of Resident hdblcm... Installing Resident hdblcm... Updating SAP HANA Database Instance Integration on Local Host... Deploying SAP Host Agent configurations... Updating Component List... SAP HANA Database components updated You can send feedback to SAP with this form: https://itsiti:1129/lmsl/HDBLCM/DEV/feedback/feedback.html Log file written to '/var/tmp/hdb_DEV_hdblcm_update_2018-08-13_03.55.49/hdblcm.log' on host 'itsiti'.
8. Bring up the SAP HANA database and SAP application server. Check the R3trans and version installed.
