SAP HANA notes 29: How to reset system user password in SAP HANA environment

How to reset system user password in SAP HANA environment

Procedure:

step1: log in the putty session with <SID>ADM.

step2:  navigate to: usr/sap/<SID>/HBDXX/exe

step3: stop SAP Application - in case the system installation in non distributive using the cmd as                   below:

           sapcontrol -nr <XX>   -host <HOSTNAME>   -function Stop

           
                                          &

                                  HDB stop  

wait for the process until the SAP application turn off.

step4: Now open another putty session and login with <SID>adm user.

step5:To start the name server of the system DB.

           usr/sap/<SID>/HDBXX> ./hdbenv.sh

step6: Navigate to /usr/sap/<SID>/HBDXX/exe >hdbnameserver -resetusersystem

step7: after completing the step 6 execution.

           provide new password for system user.

step8: start the DB - HDB start

           start the Application -    sapcontrol  -nr <XX> -host <Hostname> -function Start

step9: Hurrah!!!

login with new system user password  in HANA studio.

                                                   ---Thanks for visiting my Blog---