SAP Basis Basics Part 15

Reset the HANA SYSTEM User Password in the System Database in emergency mode (If the password of the SYSTEM user has been irretrievably lost and you have no other user with the system privilege USER ADMIN who can set a new password for the SYSTEM user.)

1.) Log on to the server on which the name server of the system database is running as the operating system user (that is, <sid>adm user).
2.) Open a command line interface.
3.) Shut down the instance by executing the following command:
/usr/sap/<SID>/HDB<instance>/exe/sapcontrol -nr <instance> -function StopSystem HDB
4.) In a new session, start the name server of the system database by executing the following commands:
/usr/sap/<SID>/HDB<instance>/hdbenv.sh
/usr/sap/<SID>/HDB<instance>/exe/hdbnameserver -resetUserSystem

After some start-up notifications, the prompt resetting of user SYSTEM — new password appears.
5.) After the last notification appears, enter a new password for the SYSTEM user.
You must enter a password that complies with the password policy configured for the system.
The password for the SYSTEM user of the system database is reset and the name server stops.
6.) In a new session, start the instance by executing the following command:
/usr/sap/<SID>/HDB<instance>/exe/sapcontrol -nr <instance> -function StartSystem HDB