[Solved] 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 SAPHANA Admin user

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

Step 3.Stop the Database
Shut down the instance by executing the following command:/usr/sap/<SID>/HDB<instance>/exe/sapcontrol -nr <instance> -function StopSystem HDB

Step 4.Start the Nameserver in Background
Now start the name server in background by executing the following commands:

○/usr/sap/<SID>/HDB<instance>/exe/hdbnameserver &

Step 5.Start the  Compile Server in Background
start the compile server by executing the following
○/usr/sap/<SID>/HDB<instance>/exe/hdbcompileserver &

Step 6.Start the Indexserver with Special Flag resetUserSystem
Now start the index server by executing this command

/usr/sap/<SID>/HDB<instance>/hdbenv.sh○/usr/sap/<SID>/HDB<instance>/exe/hdbindexserver -resetUserSystem

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

Leave a Reply