Register Login

Uninstall SAP HANA XS Advanced

Updated May 18, 2018

How to uninstall SAP HANA XS advanced?

1. Login as <SID>adm.

2. Run /hana/shared/<SID>/xs/installation-scripts/installation/uninstall.

In case of older SAP HANA XS advanced versions <= 1.0.09 you have to specify the <SID>, <instance number>

and "##USE_SEC_STORE##" for the requested file name.

(a) Drop or alter the following users via HANA Studio or hdbsql:

  • DROP USER HDI_BROKER_CONTROLLER CASCADE
  • DROP USER SYS_XS_HANA_BROKER CASCADE
  • DROP USER XSA_ADMIN CASCADE
  • DROP USER SYS_XS_RUNTIME CASCADE
  • DROP USER SYS_XS_UAA_SEC CASCADE
  • DROP USER SYS_XS_UAA CASCADE
  • ALTER USER SYS_XS_SBSS PASSWORD "Reset1234"

(b) Remove sbss:

cd /hana/shared/<SID>/xs

sapjvm_8/bin/java -jar ./installdata/apps/sbss/sbss.jar -cmd prune! -url "jdbc:sap://<hostname>:<port>" -user SYSTEM -pwd <password SYSTEM user> -sbssPwd "Reset1234"

//<port>: 3<instance number>15 in a single DB system

// in old installations the sbss.jar is in another path: ./installation-scripts/db/sbss/sbss.jar

3. Remove the SAP HANA XS advanced configuration entires from the daemon.ini (/usr/sap/<SID>/HDB<instance number>/<host>/daemon.ini):

[xscontroller] instances = 1[xsexecagent] instances = 1[xsuaaserver] instances = 1

4. Remove the "xs_worker" role via hdbnsutil -removeHostRole <HOST> --role=xs_worker.

In case of a multi-host system the host, on which the xscontroller is running, must be removed last

5. Remove the SAP HANA XS advanced software via: chmod -R 777 /hana/shared/<SID>/xs rm -rf /hana/shared/<SID>/xs


×