How to Reset the SYSTEM User's Password in SAP HANA database

How to Reset the SYSTEM User's Password in SAP HANA Database.

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.

Prerequisites :

You cannot log on to the database as the SYSTEM because the password has been irretrievably lost.

Note:

If you can log on as SYSTEM and you want to change the password, do not use the procedure described here. Use the SAP HANA studio or execute the ALTER USER SQL statement directly: 

ALTER USER SYSTEM PASSWORD .

You have the credentials of the operating system administrator (adm).

Procedure

Log on to the server on which the master index server is running as the operating system user (that is, adm user).

Open a command line interface.

Shut down the instance by executing the following command:

/usr/sap//HDB/exe/sapcontrol -nr -function StopSystem HDB

In a new session, start the name server by executing the following commands:

/usr/sap//HDB/hdbenv.sh
/usr/sap//HDB/exe/hdbnameserver

In a new session, start the compile server by executing the following commands:
/usr/sap//HDB/hdbenv.sh
/usr/sap//HDB/exe/hdbcompileserver

In a new session, start the index server by executing the following commands:

/usr/sap//HDB/hdbenv.sh
/usr/sap//HDB/exe/hdbindexserver -resetUserSystem

Note:

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

After some start-up notifications, the prompt resetting of user SYSTEM - new password 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 is reset and the index server stops.

In the terminals in which they are running, end the name server and compile server processes by pressing CTRL+C.

In a new session, start the instance by executing the following command:

/usr/sap//HDB/exe/sapcontrol -nr -function StartSystem HDB

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.

The SYSTEM user's password is reset. You do not have to change this new password the next time you log on with this user regardless of your password policy configuration.