DATABASE ADMIN GUIDE

Uninstall SAP HANA on scaleout system

ensure you are not missing the slice..

SAP HANA can run on single node system or a multinode setup sometime called as Scale-out/Cluster. Uninstallation of SAP HANA database in a scaleout is pretty easier and straight forward as just like on a single node system. You just need to execute the instructions given along.

Prerequisite:-

You have running version’s binary files, and a valid data backup (just in case if you need to restore/use the data in future)

Binaries download instruction (if you haven’t have it already on the system):

Preparing binaries:-

go to support.sap.com > Software Downloads > Installations & Upgrades >

Search for the software for download

select relavant version for download

select SAPCAR extractor and add to download basket

Once you have the selected version in download basket, download it to local machine or transfer to the system where you are running SAP HANA.

Uninstall Process:-

Keep the binaries in a backup or a mount where the data/log is not located (since this is going to get wiped out during the uninstall process). Now, locate the hdbuninst executable from the downloaded binary and exeute it as root:

host1:/backup_location/SAP_HANA_DATABASE # ./hdbuninst
SAP HANA Lifecycle Management - Uninstallation 2.4.87
*****************************************************
Installed SAP HANA installations:
0: SAP HANA Database ABC /hana/shared/ABC HDB_ALONE
 HDB04
 version: 2.00.046.00.1590630718
 hosts: host1 (Database Worker (worker)), hostabc2 (Database Worker (worker))
 edition: SAP HANA Database
 plugins: afl,epmmds
1: None (Abort uninstallation)
Enter SAP HANA installation Id [2]: 0
Do you want to uninstall the following installation?
ABC /hana/shared/ABC HDB_ALONE
 HDB04
 version: 2.00.046.00.1590630718
 hosts: host1 (Database Worker (worker)), hostabc2 (Database Worker (worker))
 edition: SAP HANA Database
 plugins: afl,epmmds
All data volumes and all log volumes will be removed!
Data and log backup files in directory '/hana/shared/ABC' and its subdirectories will be removed as well.
Confirm (y/n): y
Uninstalling SAP HANA Database…
Removing SAP HANA Database instance…
Uninstallation of SAP HANA System is not yet finished.
 To complete uninstallation, run 'hdbuninst - scope=instance' on host: hostabc2
Uninstallation done.
Log file written to '/var/tmp/hdb_ABC_uninstall_2020–09–11_23.02.53/hdbuninst.log' on host 'host1'.

login to the additional node in same cluster, and execute ./hdbuninst — scope=instance from there as well, from same location:

host2:/backup_location/SAP_HANA_DATABASE # ./hdbuninst — scope=instance
SAP HANA Lifecycle Management — Uninstallation 2.4.87
*****************************************************
Installed SAP HANA installations:
0: SAP HANA Database ABC /hana/shared/ABC HDB_ALONE
 HDB04
 version: 2.00.046.00.1590630718
 host: host2 (Database Worker (worker))
 edition: SAP HANA Database
 plugins: afl,epmmds
1: None (Abort uninstallation)
Enter SAP HANA installation Id [1]: 0
Do you want to uninstall the following installation?
ABC /hana/shared/ABC HDB_ALONE
 HDB04
 version: 2.00.046.00.1590630718
 host: host2 (Database Worker (worker))
 edition: SAP HANA Database
 plugins: afl,epmmds
All data volumes and all log volumes will be removed!
Data and log backup files in directory ‘/hana/shared/ABC’ and its subdirectories will be removed as well.
Confirm (y/n): y
Uninstalling SAP HANA Database…
Removing SAP HANA Database instance…
Uninstalling package DAT Configfiles (other)…
Uninstalling package DAT Configfiles (EN, DE)…
Uninstalling package DAT Languages (other)…
Uninstalling package DAT Languages (EN, DE)…
Uninstalling package Offline Cockpit…
Uninstalling package Delivery Units…
Uninstalling package Documentation…
Uninstalling package EPM…
Uninstalling package HWCCT…
Uninstalling package Ini Files…
Uninstalling package Installer…
Uninstalling package Krb5 Runtime…
Uninstalling package Data Quality…
Uninstalling package Binaries…
Uninstalling package Product Manifest…
Uninstalling package Python Runtime…
Uninstalling package Python Support…
Uninstalling package Saphostagent Setup…
Uninstallation done.
Log file written to ‘/var/tmp/hdb_ABC_uninstall_2020–09–11_23.05.04/hdbuninst.log’ on host ‘host2’.

Please check the uninstallation logs from /var/tmp directory of both the nodes and make sure there are no ERR (errors) during the process.

If you find anything +/-, let me know.