Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SYSTEM Password reset in SP09

Former Member
‎12-12-2014 5:05 PM
0 Kudos

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

Labels in this area
Popular Blog Posts