Skip to Content

resetting SYSTEM password

Hi everyone!

I try to reset HANA SYSTEM user password following this manual

https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.03/en-US/6b13cdd1982f4aa6b90b443663d17d7e.html

.I stuck on step 4, where I use command:

/usr/sap/D10/HDB01/hdbenv.sh

And receive: hdbenv.sh: Error: Instance not found for host <my host name>

What does it actually mean in my case? What I'm doing wrong?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 07 at 09:59 PM

    It looks like you are using an instance number other than 01 for your host

    So you can check which instance number for which host, (in your case) go to the directory "/usr/sap/D10/SYS/profile" and look at the files there.

    you should see file like D10_HDB<instance>_<hostname>

    After you receive the instance number for your host, change to the directory "/usr/sap/D10/HDB<instance>" and run the ./hdbenv.sh

    I hope that helps you

    Add comment
    10|10000 characters needed characters exceeded

    • It seems the hdbenv.sh did not run correctly

      try the whole steps again and note that step 4 is executed as described in a new session.

      4. In a new session, start the name server of the system database by executing the following commands

      ....

      ....

      but first test which hostname that you have with command: hostname

      It should match the last part of the profile file name, in your case: D10_HDB01_sonya.ls.local

      if not, start the hdbenv as follows: /usr/sap/D10/HDB01/hdbenv.sh sonya.ls.local