Skip to Content

Steps to reset the HANA SYSTEM user password

UPDATE: Section 3.1.4 Resetting the SYSTEM User's Password in the admin guide for SP7 discusses how to do this: http://help.sap.com/hana/SAP_HANA_Administration_Guide_en.pdf

Props to Former Member for his video. Thought I'd create a searchable document to outline this process.

Reset 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
Tags:
Former Member