How to Reset System User Password in SAP Hana

If the SYSTEM user’s password is lost, you can reset it as the operating system administrator by starting the index server in emergency mode.

Step 1. Login to SAP HANA Server

Log on to the server on which the of the master index server is running

Step 2.Switch to SAP HANA Admin user

Now we need to switch to SAP HANA admin user using following command
su – sidadm

Step 3.Stop the Database

Shut down the instance by executing the following command:/usr/sap//HDB/exe/sapcontrol -nr -function StopSystem HDB

Step 4.Start the Nameserver in Background

Now start the name server in background by executing the following commands:

○xyz/usr/sid/HDB/exe/hdbnameserver &

Step 5.Start the  Compile Server in Background

start the compile server by executing the following
○xyz/usr/sid/HDB/exe/hdbcompileserver &

Step 6.Start the Indexserver with Special Flag resetUserSystemNote

Now start the index server by executing this command

xyz/usr/sid/HDB/hdbenv.sh
○xyz/usr/sid/HDB/exe/hdbindexserver -resetUserSystemNote

Note:In a scale-out system, you only need to execute the commands on the master index server.

The following prompt appears: resetting of user SYSTEM – new password

Step 7.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 is reset and the index server stops.

Step 8.Kill Compileserver and Nameserver

In the terminals in which they are running, run the following command

HDBinfo

HDB info displays the list of hdb process that are running.

Now you kill the corresponding Process ID of compile server and name server by below command

Kill -9

Step 9.Start the Database

Then start the instance by executing the following command:xyz/usr/sid//HDB/exe/sapcontrol -nr -function StartSystem

If you previously deactivated the SYSTEM user, it is now also reactivated. This means you will need to deactivate it again.