SYSTEM User Password reset in SP09 .

    With HANA SP09, we do not need to user ALTER command to reset System user .

  1. Login with <sid>adm
  2. Index master server– Please make sue you have loged on Index master server.
  3. Stop hana server  – /usr/sap/<SID>/HDB<no> HDB stop
  4. you can check process status using commnad HDB info, /usr/sap/<SID>/HDB<no> HDB info
  5. Start server name server ,compileserver using hdbnameserver & hdbcompileserver &
  6. Start indexserver with flag resetUserSyestem using hdbindexserver -resetUserSyestem
  7. specify new password. This will be your new password for SYSTEM user.
  8. Index server is shutdown once password is reset. you can check using HDB info
  9. Kill running server processes (name server and compileserver)
  10. Start HANA server, using HDB start

Hope this helps

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply