SYSTEM Password reset in SP09
SYSTEM User Password reset in SP09 .
With HANA SP09, we do not need to user ALTER command to reset System user .
- Login with <sid>adm
- Index master server– Please make sue you have loged on Index master server.
- Stop hana server – /usr/sap/<SID>/HDB<no> HDB stop
- you can check process status using commnad HDB info, /usr/sap/<SID>/HDB<no> HDB info
- Start server name server ,compileserver using hdbnameserver & hdbcompileserver &
- Start indexserver with flag resetUserSyestem using hdbindexserver -resetUserSyestem
- specify new password. This will be your new password for SYSTEM user.
- Index server is shutdown once password is reset. you can check using HDB info
- Kill running server processes (name server and compileserver)
- Start HANA server, using HDB start
Hope this helps
Be the first to leave a comment
You must be Logged on to comment or reply to a post.