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