Using Google Chrome?

Download my
free Chrome Extension, Power Notes Searcher, to make searching for and evaluating SAP notes, much easier.

Thursday, December 14, 2017

Forcefully Prevent HANA Tenant DB From Starting

Print Friendly and PDF
Scenario: Your HANA system is having some serious memory problems.
In the memory you have remaining you can’t get the SYSTEM database to run, so you can’t stop a particular tenant database.

Here’s how you can use the hdbnsutil utility to prevent hdbdaemon from trying to start a tenant database.
As the <sid>adm user, kill off all remaining HANA system processes:
> hdbdaemon -quit
Export the topology:
> hdbnsutil -exportTopology /tmp/topology_export.txt
Edit the file and change the “status” of the tenant database to be “no”:
> vi /tmp/topology_export.txt

Save the file and quit vi.
Reload the topology using hdbnsutil:
> hdbnsutil -importTopology
Now restart hdbdaemon:
> hdbdaemon -start

No comments: