cancel
Showing results for 
Search instead for 
Did you mean: 

resetting SYSTEM password

0 Kudos

Hi everyone!

I try to reset HANA SYSTEM user password following this manual

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

.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!

Accepted Solutions (0)

Answers (1)

Answers (1)

ayman_salem
Active Contributor

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

0 Kudos

Thank you for your answer!

The output looks like: "D10_HDB01_sonya.ls.local DEFAULT.PFL".

But changing the directory helps to run hdbenv.

Now I have a problems running nameserver with command:

  • /usr/sap/D10>/HDB10/exe/hdbnameserver -resetUserSystem

The output is:

exe/hdbnameserver: error while loading shared libraries: libhdbpythonbase.so: cannot open shared object file: No such file or directory

Also HDB info and HDB stop returns:

sh: HDB: command not found

ayman_salem
Active Contributor
0 Kudos

the path of the command is wrong, in your case, it should:

<admuser>@sonya:/usr/sap/D10>/usr/sap/D10/HDB01/exe/hdbnameserver -resetUserSystem

....

or change to the directory: cd /usr/sap/D10/HDB01/exe and from there run the command as: ./hdbnameserver -resetUserSystem

0 Kudos

This solution is not working with the same error message

ayman_salem
Active Contributor
0 Kudos

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