reset the HANA SYSTEM user password

• SSH to the HANA system and login as root
• SU to the <sid>adm user
  • su – anaadm
  • 
• Identify running HANA services
  • ps aux | grep anaadm
  • 
• Stop the HANA server
  • ./HDB stop
  • 
• Verify services are no longer running
  • ps aux | grep anaadm
  • 
• Start the name server service – this may not get back to a prompt
  • hdbnameserver &
  • 
• Start index server. Run command even though may not be at a prompt.
  • hdbindexserver –console
  • 
• Reset password for user SYSTEM
  • ALTER USER SYSTEM PASSWORD Password1234
  • 
• Stop hdbindexserver service by hitting Ctrl-C
  • 
• Kill hdbnameserver service
  • killall -9 hdbnameserver
• Verify all HDB services are stopped
  • ps aux | grep anaadm
  • 
• Start HANA
  • ./HDB start
• Verify HANA services are running
  • ps aux | grep anaadm
  • 
• Update password in HANA studio
  •