Activate Emergency User with hdbnameserver & hdbindexserver in SAP HANA Database
to reset the password.
To recover an SAP HANA instance where the SYSTEM user’s password is lost,
you need to have &adm access to the instance where SAP HANA’s master
index server is running.
Open a command line interface, and log on to the server on which
the instance of the SAP HANA master index server is running.
Shut down the instance.
Start the name server:
- /usr/sap/HDB/hdbenv.sh
- /usr/sap//HDB/exe/hdbnameserver
Start an index server in a new console:
- /usr/sap/hdbenv.sh
- /usr/sap/exe/hdbindexserver -console
You will see the output of a starting index server.
When the service has started, you have a console to the SAP HANA
the instance where you are logged on as a SYSTEM user.
Reset the SYSTEM user’s password and store the new password in a
secure location with the following SQL command:
ALTER USER SYSTEM password &
Note: Because you are logged on as a SYSTEM user in this console,
you do not have to change this password after the next login, regardless \ of what your password setting policy.
EmoticonEmoticon
Note: only a member of this blog may post a comment.