Thursday, 5 October 2017

How to Activate Emergency User with hdbnameserver & hdbindexserver in SAP HANA Database

Tags


Activate Emergency User with hdbnameserver & hdbindexserver in SAP HANA Database

If the SYSTEM user’s password is lost, you can use the SAP system user
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.